Tool · Validate

SQL validator

Check whether a query parses as valid SQL for a specific dialect. Pick your dialect, paste the query, and it’s validated as you type — a valid query is formatted for you, and a syntax error is pinpointed to the line and column. It’s a syntax check, not a database connection, so it never runs your query or touches your data.

Valid PostgreSQL

input

PostgreSQL — valid

SELECT
  id,
  name
FROM
  users
WHERE
  created_at > now()
ORDER BY
  name

What “valid” means here

The validator parses your SQL against the grammar of the dialect you choose — the same parser the formatter uses. It catches syntax errors (a missing comma, an unclosed parenthesis, a keyword in the wrong place) and dialect mismatches, such as using TOP in a PostgreSQL query. It does not check that your tables or columns exist — that requires a live connection.

More SQL tools

Explain a SQL query Optimize a SQL query Convert between dialects SQL minifier