Use it from an assistant or a script
Translates a query or DDL between 14 SQL dialects (MySQL, PostgreSQL, SQL Server, Oracle, SQLite, Snowflake, BigQuery, DuckDB and more): functions, quoting, LIMIT and TOP, and types.
curl -X POST https://pilotbase.pro/api/sql/translate -H "Content-Type: application/json" \
-d '{"sql": "SELECT TOP 5 name FROM users", "read": "tsql", "write": "postgres"}'
# {"sql": "SELECT\n name\nFROM users\nLIMIT 5;", "statements": 1}- MCP tool
- None yet: use the call above.
- Limit
- 20 KB of SQL per call without an account, 200 KB signed in. The SQL isn't stored unless you're signed in and keep it in your history. Dialect names: GET https://pilotbase.pro/api/sql/dialects
About sqlTranslate
Translate queries and DDL between MySQL, PostgreSQL, SQL Server, Oracle, SQLite, Snowflake, BigQuery, DuckDB, Redshift, Spark, Databricks, Hive, Trino and ClickHouse: functions, quoting, LIMIT/TOP and types.
Translation runs on our server; the SQL isn't stored unless you're signed in and keep it in your history.
Built on open-source libraries: sqlglot (Python).
From the makers
Pilotbase: one client for every database you run (PostgreSQL, MySQL, MongoDB, Redis and more), with an AI agent built in.
Get Pilotbase freeMore free data tools
sqlBeautify
Format, highlight and fix SQL as you type
sqlCompare
Diff two SQL files like git, after formatting both
downtimeAlert
We check your URL, API or stats page every 30 seconds and email you when it's down
explainViewer
See where a Postgres query spends its time
keysetBuilder
Keyset pagination queries from your ORDER BY
testData
Realistic fake rows for your tables, as one INSERT for Postgres, MySQL or SQLite