SQL Analyzer.

Paste SQL to see its tables, fields, joins, and query logic at a glance.

Runs entirely in your browser

Choose the dialect used by your SQL for more accurate analysis.

0 characters

Your SQL stays in this browser. It is not executed or uploaded.

Paste SQL to begin.

FIELD NOTES / 034

Read the structure before you run the query.

See statement types, distinct physical tables, aliases, selected and aggregate fields, conditions, joins, grouping, and ordering. Each statement is shown separately.

MyBatis #{name} parameters stay visible. Paste several queries separated by [queryName] markers to analyze each one independently. A query with invalid SQL is flagged without hiding the others.

Use SQL Formatter & Generator when you want to format or generate SQL instead.

Open SQL Formatter & Generator →

Good to know

Does this execute SQL?

No. The analysis uses only text in your browser. It does not connect to a database, inspect your schema, or upload the SQL.

Can it resolve every field?

No. A wildcard or an unqualified column may need schema information. Unsupported syntax is reported rather than guessed.

Which dialects are available?

MySQL, PostgreSQL, SQLite, and SQL Server. Select the one matching your input.

0 / 2,000