How to use

Use this to lint SQL text for common PostgreSQL issues.

Paste your SQL into the input box.
Choose options (allow multiple statements, require trailing semicolon, strict mode).
Click Check SQL to see errors, warnings, and a normalized copy.
Use Copy output to share the report.

FAQ

Does this tool fully validate PostgreSQL syntax?

No—this is a fast lint checker for common mistakes and dialect red flags; it does not implement the full PostgreSQL parser.

Will it run my query against a database?

No. The check runs locally in your browser and does not execute SQL.

What errors can it catch reliably?

Unclosed quotes/comments, unbalanced parentheses, and multiple-statement detection are handled reliably.

Can it help with MySQL-to-Postgres migration?

Yes—it flags common MySQL patterns like backticks, AUTO_INCREMENT, IFNULL(), REPLACE INTO, and LIMIT offset,count.

Does it support PL/pgSQL and DO $$ blocks?

It understands dollar-quoted strings ($$...$$ / $tag$...$tag$) for linting, but it won’t validate PL/pgSQL grammar.

Why do I see warnings even when Status is PASS?

Warnings mean the SQL might run but looks non-Postgres or risky; enable strict mode to treat warnings as failures.

Is my SQL uploaded or stored anywhere?

No network calls are made by this tool; your input stays in the page.