Check whether a query is valid MySQL or PostgreSQL before you run it.
Loading tool…
The validator parses your SQL with node-sql-parser, a full SQL parser with separate grammars for MySQL/MariaDB and PostgreSQL. If the query is valid you see how many statements it contains and their types; if not, you get the first syntax error with its line and column, for example SELEC * FORM users is caught at once.
Catch typos in a query before it reaches the database.
Check hand-written migration scripts for syntax errors.
See exactly where a query stops being valid.
MySQL (also used for MariaDB) and PostgreSQL. Choose the one your query is written for, because their syntax differs.
No. It checks syntax only, because it has no access to your database. A query can be valid SQL and still fail if a table doesn't exist.
Yes. Separate them with semicolons; the result lists each statement's type.
It shows what the parser expected at that position and what it found instead, with the line and column, which usually points straight at the typo.
No. Everything runs in your browser; nothing you paste or upload is sent to our servers.