Babysitter query-translator

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

install

source · Clone the upstream repo

git clone https://github.com/a5c-ai/babysitter

Claude Code · Install into ~/.claude/skills/

T=$(mktemp -d) && git clone --depth=1 https://github.com/a5c-ai/babysitter "$T" && mkdir -p ~/.claude/skills && cp -r "$T/library/specializations/code-migration-modernization/skills/query-translator" ~/.claude/skills/a5c-ai-babysitter-query-translator && rm -rf "$T"

manifest: library/specializations/code-migration-modernization/skills/query-translator/SKILL.md

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