Convert SQL between dialects
A formatter re-indents; it can’t rewrite TOP into LIMIT or NVL into COALESCE. The AI converter translates queries between 8 dialects. Pick a direction below to see exactly what changes, then paste your own query in the app.
Migrating Oracle to PostgreSQL means swapping ROWNUM paging for LIMIT, NVL for COALESCE, SYSDATE for now(), and dropping the DUAL table.
What changes from Oracle to PostgreSQL
| Oracle | PostgreSQL | Why |
|---|---|---|
| ROWNUM <= 20 | LIMIT 20 | Postgres has no ROWNUM; row limiting moves to a LIMIT clause. |
| NVL(x, 0) | COALESCE(x, 0) | NVL is Oracle-only; COALESCE is the SQL-standard equivalent. |
| SYSDATE - 30 | now() - INTERVAL '30 days' | Date arithmetic uses interval literals in Postgres. |
| FROM dual | (omitted) | Postgres allows SELECT with no FROM, so DUAL disappears. |
Frequently asked questions
Is the converted SQL guaranteed to run?
No — treat the output as a first draft, not a migration tool. The converter rewrites the syntax it recognises (paging, string functions, date arithmetic, quoting), but semantics that differ between engines — collation, implicit casts, transaction behaviour — still need a human check. Run the result against a test database before shipping it.
Which dialect pairs are supported?
Any direction between Oracle, SQL Server (T-SQL), MySQL/MariaDB, PostgreSQL, SQLite, Snowflake, BigQuery and Redshift. The examples on this page cover the migration paths people actually ask for; the app itself accepts any from/to combination.
Why can't the formatter just convert the query?
Formatting is a parse-and-reprint: it changes whitespace and casing, never tokens. Converting has to replace one dialect's constructs with another's — TOP with LIMIT, NVL with COALESCE, GETDATE() with NOW() — which is a rewrite, not a reformat. That's why conversion runs through an AI model and formatting runs offline in your browser.
Is my query sent to a server?
Conversion is the one feature that leaves your machine: the query goes to the language model that rewrites it. Formatting, minifying and validating all run locally in the browser and upload nothing.
Do I need an account to convert SQL?
Yes, and the free tier includes a few conversions so you can judge the quality before paying. Formatting stays free and account-free forever.