SQL Translate
Requirements
Agent: builder or migrator (may write translated SQL to files)
Tools used: sql_translate, read, write, altimate_core_validate
Translate SQL queries from one database dialect to another using sqlglot's transpilation engine.
Workflow
Determine source and target dialects — If the user did not specify both dialects, ask which source and target dialects to use. Common dialects: snowflake, bigquery, postgres, mysql, tsql, hive, spark, databricks, redshift, duckdb.
Get the SQL to translate — Either:
- Read from a file path provided by the user (use
read)
- Accept inline SQL from the user's message
- Read from clipboard or stdin if mentioned
Call sql_translate with:
sql: The SQL query text
source_dialect: The source dialect
target_dialect: The target dialect
Review the result:
- If
success is true, present the translated SQL
- If there are
warnings, explain each one and what may need manual adjustment
- If
success is false, explain the error and suggest fixes
Format the output showing:
- Original SQL (labeled with source dialect)
- Translated SQL (labeled with target dialect)
- Any warnings about lossy translations or features that need manual review
Offer next steps if applicable:
- Suggest running
altimate_core_validate on the translated SQL to verify syntax
- Offer to write the translated SQL to a file
- Offer to translate additional queries
Usage
The user invokes this skill with optional dialect and SQL arguments:
/sql-translate — Interactive: ask for source dialect, target dialect, and SQL
/sql-translate snowflake postgres — Translate from Snowflake to PostgreSQL (will ask for SQL)
/sql-translate snowflake postgres SELECT DATEADD(day, 7, CURRENT_TIMESTAMP()) — Full inline translation
Supported Dialects
| Dialect |
Key |
| Snowflake |
snowflake |
| BigQuery |
bigquery |
| PostgreSQL |
postgres |
| MySQL |
mysql |
| SQL Server |
tsql |
| Hive |
hive |
| Spark SQL |
spark |
| Databricks |
databricks |
| Redshift |
redshift |
| DuckDB |
duckdb |
| SQLite |
sqlite |
| Oracle |
oracle |
| Trino/Presto |
trino / presto |
Use the tools: sql_translate, read, write, altimate_core_validate.
1---2name: sql-translate3description: Translate SQL queries between database dialects (Snowflake, BigQuery, PostgreSQL, MySQL, etc.)4metadata:5 source: https://skillmd.com/skills/altimateai-altimate-code/sql-translate6---78# SQL Translate910## Requirements11**Agent:** builder or migrator (may write translated SQL to files)12**Tools used:** sql_translate, read, write, altimate_core_validate1314Translate SQL queries from one database dialect to another using sqlglot's transpilation engine.1516## Workflow17181. **Determine source and target dialects** — If the user did not specify both dialects, ask which source and target dialects to use. Common dialects: `snowflake`, `bigquery`, `postgres`, `mysql`, `tsql`, `hive`, `spark`, `databricks`, `redshift`, `duckdb`.19202. **Get the SQL to translate** — Either:21 - Read from a file path provided by the user (use `read`)22 - Accept inline SQL from the user's message23 - Read from clipboard or stdin if mentioned24253. **Call `sql_translate`** with:26 - `sql`: The SQL query text27 - `source_dialect`: The source dialect28 - `target_dialect`: The target dialect29304. **Review the result**:31 - If `success` is true, present the translated SQL32 - If there are `warnings`, explain each one and what may need manual adjustment33 - If `success` is false, explain the error and suggest fixes34355. **Format the output** showing:36 - Original SQL (labeled with source dialect)37 - Translated SQL (labeled with target dialect)38 - Any warnings about lossy translations or features that need manual review39406. **Offer next steps** if applicable:41 - Suggest running `altimate_core_validate` on the translated SQL to verify syntax42 - Offer to write the translated SQL to a file43 - Offer to translate additional queries4445## Usage4647The user invokes this skill with optional dialect and SQL arguments:48- `/sql-translate` — Interactive: ask for source dialect, target dialect, and SQL49- `/sql-translate snowflake postgres` — Translate from Snowflake to PostgreSQL (will ask for SQL)50- `/sql-translate snowflake postgres SELECT DATEADD(day, 7, CURRENT_TIMESTAMP())` — Full inline translation5152## Supported Dialects5354| Dialect | Key |55|---------|-----|56| Snowflake | `snowflake` |57| BigQuery | `bigquery` |58| PostgreSQL | `postgres` |59| MySQL | `mysql` |60| SQL Server | `tsql` |61| Hive | `hive` |62| Spark SQL | `spark` |63| Databricks | `databricks` |64| Redshift | `redshift` |65| DuckDB | `duckdb` |66| SQLite | `sqlite` |67| Oracle | `oracle` |68| Trino/Presto | `trino` / `presto` |6970Use the tools: `sql_translate`, `read`, `write`, `altimate_core_validate`.