# Query Translator

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

- Skill: `majiayu000/query-translator` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add majiayu000/query-translator`
- Raw SKILL.md: https://api.skillmd.com/api/skills/majiayu000/query-translator/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: majiayu000 (https://skillmd.com/u/majiayu000)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/majiayu000/query-translator

---


# 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