a5c-ai/babysitter / library/specializations/code-migration-modernization/skills/query-translator
query-translator
VerifiedTranslate SQL queries between different database dialects with function mapping and optimization
SKILL.md
View on GitHub---
name: query-translator
description: Translate SQL queries between different database dialects with function mapping and optimization
allowed-tools: ["Bash", "Read", "Write", "Grep", "Glob", "Edit"]
graph:
domains: [domain:software-engineering]
specializations: [specialization:code-migration-modernization]
skillAreas: [skill-area:database-migrations-zero-downtime, skill-area:schema-evolution]
roles: [role:data-engineer, role:backend-engineer]
workflows: [workflow:technical-debt-reduction]
topics: [topic:refactoring]
---
# 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
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |