SQL Formatter

The formatter works with standard SQL syntax and is compatible with MySQL, PostgreSQL, SQLite, SQL Server, and Oracle SQL. It handles common keywords like SELECT, FROM, WHERE, JOIN, GROUP BY, ORDER BY, and more.

No, this tool focuses on formatting and beautification. It does not validate whether the SQL is syntactically correct or will execute successfully against a database.

Minification removes unnecessary whitespace, newlines, and comments from your SQL, producing a compact single-line version suitable for embedding in code or reducing data transfer size.

The standard read/write set - SELECT, INSERT, UPDATE, DELETE - plus DDL (CREATE TABLE, ALTER, DROP), CTEs (WITH ... AS), and window functions with OVER (PARTITION BY ...). JOIN keywords and their ON clauses get dedicated alignment so join conditions line up under their joins.

No. The formatter is whitespace- and keyword-aware but semantics-preserving: string literals, identifiers, and values pass through untouched, so the execution plan is identical. Minification removes only insignificant whitespace and comments - but beware optimizer hints embedded in comments; strip the comment and you strip the hint, so keep minified SQL for transport, not as your source of truth.

All descend from ANSI SQL, but each engine adds its own surface: PostgreSQL has RETURNING and DISTINCT ON, MySQL uses backtick identifiers and LIMIT n, SQL Server uses TOP n and square brackets, and SQLite has a famously loose type affinity system. The formatter stays dialect-neutral for shared syntax and leaves engine-specific constructs in place.

Each JOIN keyword starts a new aligned block with its ON or USING clause indented beneath; correlated subqueries get an extra indent level so nesting depth reads at a glance. CTE bodies format like top-level statements inside their WITH wrapper.

Shrinking SQL to one line strips insignificant whitespace and comments for cases where statements travel as single-line strings: ORM debug output, log parsing, SQL embedded in code, and URL transport in admin tools. It is a transport convenience - keep the formatted version as the editable source of truth.