SQL / BROWSER UTILITY
SQL Syntax Checker
Check SQL syntax, common mistakes and potential performance issues locally for Oracle, SQL Server, PostgreSQL, MySQL/MariaDB and SQLite.
Checked locally in your browser. Your SQL is not uploaded or executed.
Performance hints identify patterns to review, not measured cost. No hints does not mean the query is fast. Actual performance depends on your data, indexes, statistics and database configuration. Only explicitly labelled deterministic rewrites offer an Apply rewrite button.
Apiary checks syntax and common SQL mistakes, but cannot verify whether tables, columns or permissions exist without connecting to your database.
Copy diagnostics
Looking for an example? Open SQL Syntax Reference.
Coverage and quoting assumptions
Oracle has no full grammar parser here. Its checks cover selected structural patterns, quotes, identifiers and common mistakes; PL/SQL checks are limited to lexical and basic block balance checks.
Other dialects use a third-party parser. Parser acceptance covers that library’s grammar, not every server feature. Rejections appear as Parser warnings because valid vendor syntax may be unsupported. SQLite bracket identifiers and empty IN lists, T-SQL omitted-name qualification and procedural/batch input fall back to lint only.
Assumes standard PostgreSQL strings, T-SQL QUOTED_IDENTIFIER ON, and MySQL’s default backslash escapes. MySQL ANSI_QUOTES and other SQL modes are not inferred. PostgreSQL dollar quotes and Oracle alternative strings are recognized. No schema is inferred.
About this tool
Syntax checks cannot establish that a table or column exists, types are compatible, permissions or constraints allow a change, or the query gives the intended business result. Parser grammars cover subsets of their databases; Oracle uses lint only.
Example: List the names and prices of shop products costing more than 20. Add a comma after price in the SELECT list to try a fixable syntax error.