Tested tool guide
Tested browser tools
Checked August 16, 2026
What SQL Dialect Converter does, with a checked example
Five SQL engines agree on the broad shape of a SELECT, but each spells the details differently. MySQL writes LIMIT at the end, SQL Server puts TOP in the select list, PostgreSQL casts with ::, Oracle numbers rows with ROWNUM. This tool rewrites a query between PostgreSQL, MySQL, SQLite, SQL Server, and Oracle so it runs unchanged on the target engine. What surprises people most: a converted query that parses cleanly is not a query that behaves identically, because AUTO_INCREMENT, SERIAL, and IDENTITY auto-number rows in subtly different ways. The conversion runs in your browser; pasted queries are not uploaded.
Worked example
A concrete input and expected output from the current implementation.
Input
SELECT id, name
FROM customers
ORDER BY name
LIMIT 5;
->
Expected output
SELECT TOP (5) id, name
FROM customers
ORDER BY name;
MySQL and SQLite place the row limit at the end with LIMIT. SQL Server has no LIMIT clause, so the limit moves into the select list as TOP (n) and the ORDER BY is kept, because it determines which five rows are returned. TOP without ORDER BY would parse but return arbitrary rows.
