Query Translator

• 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

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