SQL Formatter
Format and beautify SQL queries instantly. Choose your dialect and keyword style. All processing happens in your browser — your queries are never sent to a server.
This tool formats SQL for readability only — it does not execute queries. Processed locally in your browser.
Tip: Press Ctrl+Enter to format.
What is a SQL Formatter?
A SQL formatter (also called a SQL beautifier) takes compact or hand-written SQL and rewrites it with consistent indentation, line breaks, and keyword casing — making queries far easier to read, review, and debug.
How to use
- Paste your SQL query into the input area.
- Choose a dialect — SQL (generic), MySQL, PostgreSQL, or SQLite. The dialect affects keyword recognition and quoting rules.
- Choose keyword casing — UPPER, lower, or Preserve to keep the original case.
- Set indent width — 2 or 4 spaces.
- Click Format SQL or press
Ctrl+Enterto format. - Click the Copy button to copy the formatted output.
Supported SQL syntax
SELECT,FROM,WHERE,ORDER BY,GROUP BY,HAVINGJOIN,LEFT JOIN,INNER JOIN,CROSS JOININSERT INTO,UPDATE,DELETE FROMUNION,UNION ALL, subqueries, aliases- Common SQL functions:
COUNT,SUM,AVG,MAX,MIN,COALESCE,CAST,CASE WHEN
Examples
Before: SELECT u.id,u.name,o.total FROM users u LEFT JOIN orders o ON u.id=o.user_id WHERE u.status='active' ORDER BY u.name
After (PostgreSQL, UPPER, 2-space indent):
SELECT u.id, u.name, o.total FROM users u LEFT JOIN orders o ON u.id = o.user_id WHERE u.status = 'active' ORDER BY u.name
Privacy
Your SQL is processed entirely in the browser. No queries, table names, or any other data are transmitted to any server.
Frequently Asked Questions
Does this formatter execute my SQL queries?
No. This tool is purely a syntax beautifier and reformatter. It never establishes a database connection or executes any query commands.
Is my SQL query or table schema sent to a server?
No. All parsing and formatting happens 100% locally in your browser using the client-side sql-formatter engine. No queries, table names, or data are transmitted over the network.
Why does the output differ between SQL dialects?
Each database dialect (PostgreSQL, MySQL, SQLite, standard SQL) has unique reserved words, quotation rules, and operator syntax. Selecting your target dialect guarantees idiomatic formatting.
Can I format multiple queries in a single block?
Yes. Separate individual statements with semicolons, and the formatter will beautify each query sequentially with clean paragraph breaks in between.