Paste a query and choose your database to find syntax errors with the line and what was expected there. Before parsing, it also flags mistakes that run but do damage or return nothing: UPDATE or DELETE without WHERE, = NULL instead of IS NULL, a comma before FROM, unclosed quotes and brackets, and INSERT with the wrong number of values.
loading toolHow to use the sql checker
- Paste your code into the box (or tap Try a sample).
- Read the list of problems: ✕ marks an error, ! a warning.
- Tap Show next to a problem to jump to that line, fix it, and watch the list update.
Good to know
- Always test UPDATE and DELETE with a SELECT using the same WHERE first.
- NULL is never equal to anything, even NULL: use IS NULL.
Questions
Which databases are supported?
MySQL, PostgreSQL, SQLite, SQL Server (T-SQL), MariaDB, Google BigQuery, Snowflake and Amazon Redshift, using the open-source node-sql-parser grammars.
Does it connect to my database?
No. It only reads the text of your SQL. Nothing is run and nothing is sent anywhere.
Why is my valid query reported?
Very new or rare database features may be missing from the parser’s grammar. If your database runs it, trust your database.
Is my data private?
Yes. Everything happens inside your own browser: nothing you type or choose is uploaded to us or anyone else.
Is it free?
Completely free, with no sign-up, no watermark and no limit on how many times you use it. Light ads keep the site running.
