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

json
{
  "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