SQL syntax checker
Paste SQL and pick a dialect — get the exact line and column of the first syntax error, or a green check.
✓ Valid syntax for PostgreSQL.
Checks syntax only, for PostgreSQL, MySQL / MariaDB, SQLite, T-SQL (SQL Server), Trino, Athena — it doesn't know your schema (tables, columns or types), so valid syntax against a nonexistent table still passes.
Runs in your browser. Nothing you type is sent anywhere.
How this works
- Uses the node-sql-parser library (Apache-2.0 license) to parse SQL into a syntax tree for the chosen dialect. docs ↗
- Supports PostgreSQL, MySQL/MariaDB, SQLite, T-SQL (SQL Server), Trino and Athena.
- This checks syntax only — it has no connection to a database, so it can't catch a typo'd table or column name.
Do this against your live database in Tablyne.
PostgreSQL GUI →FAQ
Does this check my schema too? +
No — it only verifies the SQL is syntactically valid for the chosen dialect. A query against a table that doesn't exist still passes.
Which dialects are supported? +
PostgreSQL, MySQL/MariaDB, SQLite, T-SQL (SQL Server), Trino and Athena.
Why does the same query fail in one dialect and pass in another? +
Each dialect has its own reserved words and syntax extensions (like T-SQL's TOP or Postgres's DISTINCT ON) — a query using one dialect's extension is invalid in another.