SQL Beautifier

SQL beautification is the process of reformatting raw, minified, or inconsistently formatted SQL code into a clean, readable, and standardized form. Raw SQL queries - especially those generated by ORMs, extracted from logs, or written by multiple developers over time - often lack consistent indentation, have mixed keyword casing, and pack complex logic into dense, unreadable lines. A SQL beautifier applies consistent rules for keyword capitalization (SELECT, FROM, WHERE), clause indentation (each major clause on its own line with logical sub-clauses indented),column alignment (one column per line with aligned commas), andstatement spacing (blank lines between separate statements and around subqueries). The result is SQL that reveals its logical structure at a glance.

1. Tokenization - The SQL input is broken into tokens: keywords, identifiers, operators, string literals, numbers, and punctuation. The tokenizer handles quoted identifiers, string escapes, comments (single-line and multi-line), and dialect-specific operators like PostgreSQL's -> and ->> or MySQL's backtick quoting.
2. Clause Detection - SQL keywords are classified into clause starters (SELECT, FROM, WHERE, JOIN, GROUP BY, ORDER BY, HAVING, LIMIT), sub-starters (AND, OR, ON), and other tokens. The parser tracks nesting depth for parentheses, subqueries, and CASE expressions.
3. Reformatting - Based on the token classification, line breaks and indentation are inserted: each major clause starts on a new line at the base indent, comma-separated lists are expanded to one per line, parenthesized subqueries are indented, and JOIN conditions are formatted with ON alignments.
4. Keyword Case & Spacing - All recognized SQL keywords are converted to the selected case (UPPER or lower). Extra whitespace is collapsed to single spaces. Commas are moved to the leading or trailing position based on preferences. Comments are preserved with their original formatting.

• Keyword Capitalization: All SQL keywords are converted to either UPPERCASE (SELECT, FROM, WHERE) or lowercase based on user preference. This makes the structural elements of the query visually distinct from identifiers like table and column names.
• Clause Indentation: Each major clause begins on a new line. SELECT columns are indented 4 spaces from the SELECT keyword when they span multiple lines. WHERE, AND, OR conditions are indented to align with each other. Subqueries in parentheses receive an additional indentation level.
• Column & Value Alignment: Columns in SELECT lists, values in INSERT statements, and conditions in WHERE clauses are formatted one per line when they exceed the specified width. Commas can be placed at the start of the line (leading) or end (trailing) based on preference.
• JOIN & ON Formatting: Each JOIN clause starts on a new line. The ON condition is indented below its JOIN keyword. Multiple ON conditions connected by AND are split across lines with proper alignment. LEFT, RIGHT, INNER, and CROSS JOIN variants are all handled.
• Complex Expression Handling: CASE expressions are formatted with WHEN, THEN, ELSE, and END on separate lines. Window functions (OVER, PARTITION BY, ORDER BY within OVER) receive special formatting. CTEs (WITH clause) have each CTE on its own line with comma separators.

This tool runs entirely in your browser using client-side JavaScript. Your SQL queries, database schema information, and reformatted output are never uploaded to any server, stored in any database, or transmitted over the network. All tokenization, parsing, clause detection, keyword capitalization, indentation, and reformatting execute locally on your device. There are no API calls, analytics tracking, cookies, or data collection of any kind. This makes it completely safe for formatting SQL from proprietary databases, confidential analytics, or production queries containing sensitive business data.