SQL Formatter & Beautifier Online — Format, Highlight & Minify SQL Queries

Paste your SQL query into the input panel on the left. The formatter automatically applies proper indentation and formatting as you type — no button press required. If you prefer to trigger formatting manually, click the Format button in the toolbar. The formatted output appears in the right panel with syntax highlighting. You can then click Copy to copy it to your clipboard or Download to save it as a .sql file.

The formatter handles Generic SQL, MySQL, PostgreSQL, SQLite, and SQL Server (T-SQL) syntax. The dialect selector in the toolbar lets you label your query with the target database. The tokenizer handles dialect-specific syntax including MySQL backtick identifiers, PostgreSQL dollar-quoted strings and :: cast syntax, SQL Server square bracket identifiers and TOP clause, and SQLite-specific functions. Most standard SQL constructs — SELECT, JOIN, subqueries, CASE/WHEN, window functions, CTEs — work across all dialects.

Formatting (beautifying) adds proper indentation, newlines before each major clause, and consistent keyword casing to make queries readable for humans. Each SELECT column, WHERE condition, and JOIN clause is placed on its own indented line. Minifying does the opposite — it removes all unnecessary whitespace and comments to produce the shortest possible query string. Minified SQL is useful for embedding queries in code strings, logging, or sending over a wire where readability is less important than compactness.

Use the Keywords dropdown in the toolbar. Select UPPERCASE to convert all SQL keywords (SELECT, FROM, WHERE, JOIN, etc.) to uppercase — the most common convention in professional SQL. Select lowercase to convert all keywords to lowercase — common in some PostgreSQL and application-layer codebases. Select Preserve to leave keyword casing exactly as typed, without modification. The setting applies instantly without needing to reformat.

Yes. The formatter handles multiple SQL statements separated by semicolons. Each statement is formatted independently, with a blank line between them in the output for readability. This works for scripts containing a mix of SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, ALTER TABLE, and other statement types. Comments (-- line comments and /* block comments */) are preserved and formatted at the correct indentation level.

Yes. Subqueries inside parentheses are detected automatically and indented one level deeper than the outer query. Common Table Expressions (CTEs) using WITH ... AS (...) are formatted with the CTE body properly indented. Nested subqueries increase indentation with each level. CASE/WHEN/THEN/ELSE/END expressions are formatted with each WHEN and ELSE on its own indented line, and END is dedented back to the CASE level.

Yes — all SQL formatting runs entirely in your browser using JavaScript. Your queries are never sent to any server, never logged, and never stored outside your browser tab. This makes the tool safe for formatting queries that contain sensitive table names, column names, production data patterns, credentials in connection strings, or any proprietary database schema. Closing the tab permanently discards everything you pasted.

Yes. Click the Upload button in the toolbar to select a .sql or .txt file from your computer, or drag and drop the file directly onto the panel. The file contents are loaded into the input editor and formatted automatically. You can then download the formatted output using the Download button, which saves the result as query.sql.