Pilotbase

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 free

More free data tools