Query Translator Skill

SkillDatabases & data

Translate SQL queries between different database dialects with function mapping and optimization

Instructions available. Your AI can read the instructions. Execution depends on the setup they require.

Add ahel to your AI once: Claude, ChatGPT, Cursor, Claude Code or Codex. Then ask it to use this.

Then ask your AI: use the Query Translator Skill skill

What this skill tells your AI

The instructions your AI receives, as published by a5c-ai/babysitter in library/specializations/code-migration-modernization/skills/query-translator/SKILL.md and read by ahel’s review.

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

ToolPurposeIntegration Method
SQLGlotUniversal SQL parserLibrary
AWS SCTSchema conversionCLI
ora2pgOracle to PostgreSQLCLI
pgLoaderMySQL to PostgreSQLCLI
SSMASQL Server migrationCLI

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

Signals

GitHub stars
2k
Forks
112
Last commit
Sep 2026
Advanced
Item type
skill
Key
query-translator
Source
github.com/a5c-ai/babysitter