SQL Analyzer.
Paste SQL to see its tables, fields, joins, and query logic at a glance.
Choose the dialect used by your SQL for more accurate analysis.
Your SQL stays in this browser. It is not executed or uploaded.
Paste SQL to begin.
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.