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": ...