Free Developer Tool - runs 100% in your browser
SQL Formatter
Scroll down to learn more about this tool
Format and beautify SQL queries online
This SQL formatter turns long single-line queries into readable, well-indented SQL. Major clauses - SELECT, FROM, WHERE, GROUP BY,ORDER BY, HAVING - each start a new line, joins are broken out with theirON conditions, AND/OR chains are stacked, and keywords are uppercased (or lowercased, your choice). String literals and quoted identifiers are preserved untouched.
Why formatted SQL matters
SQL copied out of ORMs, logs and monitoring tools usually arrives as one enormous line. Formatting it is the first step of every optimization or debugging session: you can't reason about a query plan when you can't see the query's shape. Consistently formatted SQL is also easier to code-review and diff - a one-clause change shows as a one-line diff instead of an unreadable blob.
Works with any SQL dialect
The formatter is dialect-agnostic and handles the shared core of MySQL, PostgreSQL, SQL Server, SQLite and Oracle: joins of every kind, subqueries, CASE expressions, CTEs (WITH), INSERT/UPDATE/DELETE, and comments. Since it's a formatter - not a parser - it never rewrites your logic; it only adds whitespace and adjusts keyword casing.
Everything runs locally in the browser, so production queries containing table names and business logic stay private. Comparing two versions of a query? Format both here, then use thetext diff checker.