Query Translator Skill

Translates SQL queries between different database dialects, handling function mapping, syntax differences, and performance optimization.

Purpose

Enable SQL migration for:

• Dialect conversion
• Function mapping
• Syntax translation
• Performance hint conversion
• Query optimization suggestions

Capabilities

1. Dialect Conversion

• Oracle to PostgreSQL
• SQL Server to MySQL
• MySQL to PostgreSQL
• And more combinations

2. Function Mapping

• Date/time functions
• String functions
• Math functions
• Custom function equivalents

3. Syntax Translation

• Pagination (LIMIT/OFFSET/ROWNUM)
• String concatenation
• NULL handling
• Boolean expressions

4. Performance Hint Conversion

• Index hints
• Join hints
• Optimizer directives
• Execution plan guidance

5. Query Optimization Suggestions

• Index recommendations
• Query restructuring
• Join optimization
• Subquery refactoring

Tool Integrations

Tool	Purpose	Integration Method
SQLGlot	Universal SQL parser	Library
AWS SCT	Schema conversion	CLI
ora2pg	Oracle to PostgreSQL	CLI
pgLoader	MySQL to PostgreSQL	CLI
SSMA	SQL Server migration	CLI

Output Schema

{
  "translationId": "string",
  "timestamp": "ISO8601",
  "source": {
    "dialect": "string",
    "query": "string"
  },
  "target": {
    "dialect": "string",
    "query": "string"
  },
  "transformations": [
    {
      "type": "function|syntax|hint",
      "original": "string",
      "translated": "string",
      "notes": "string"
    }
  ],
  "optimizations": [],
  "warnings": [],
  "manualReviewNeeded": []
}

Integration with Migration Processes

• database-schema-migration: Query migration
• cloud-migration: Cloud database adaptation

Related Skills

• schema-comparator: Schema analysis
• data-migration-validator: Validation queries

Related Agents

• database-migration-orchestrator: Uses for migration