Developer

SQL Formatter & Beautifier

Prettify, format, and align messy SQL queries for PostgreSQL, MySQL, and SQLite.

Input 1 lines · 231 chars

Formatted 23 lines

SELECT
 u.id ,
 u.name ,
 COUNT(
o.id )AS order_count
FROM
 users u
LEFT

JOIN
 orders o
 ON u.id = o.user_id
WHERE
 u.active = 1
 AND u.created_at > "2025-01-01"
GROUP
 BYu.id ,
 u.name
HAVING
 order_count > 5
ORDER
 BYorder_count DESC
LIMIT 20 ;

All SQL processing happens locally in your browser. Your queries are never sent to any server, cached, or stored.

Messy SQL is hard to read, debug, and maintain. Whether you're troubleshooting a complex join, reviewing a colleague's query, or preparing a production migration, a SQL formatter turns sprawling, single-line queries into clean, indented, readable statements. Our free online SQL beautifier supports PostgreSQL, MySQL, SQLite, and SQL Server syntax — keyword uppercasing, clause alignment, subquery indentation, and one-click minification.

Supported SQL Dialects

PostgreSQL
Full support for PostgreSQL-specific syntax including WITH, RECURSIVE, window functions, DISTINCT ON, and RETURNING.
MySQL / MariaDB
Handles MySQL-specific constructs like backtick identifiers, REPLACE, and LIMIT with OFFSET.
SQLite
Compatible with SQLite syntax including AUTOINCREMENT, TEMP tables, and common table expressions.
SQL Server / T-SQL
Recognizes TOP, FETCH NEXT ROWS ONLY, window functions, and T-SQL procedural keywords.

How the SQL Formatter Works

Paste your SQL — Enter raw, unformatted SQL into the input panel. Single-line or multi-line, it handles both.
Choose a view — Beautify expands the query with indented clauses and uppercased keywords. Minify compresses it into a compact single line.
Copy or download — Use the Copy button or download the formatted query as a .sql file.

Key Features

Keyword Uppercasing
SELECT, FROM, WHERE, JOIN, and 100+ keywords are automatically uppercased.
Clause Alignment
Major clauses start on new lines with consistent indentation for easy scanning.
Subquery Indentation
Nested subqueries are indented properly with clear visual hierarchy.
Beautify & Minify
Switch between expanded and compact views with one click.
Comment Preservation
Single-line (--) and block (/* */) comments are preserved in the output.
100% Private
All formatting happens client-side. Your queries never leave your device.

Common Use Cases

Query Debugging: Format complex multi-join queries to spot missing conditions, incorrect joins, or logic errors.
Code Review: Beautify SQL before committing to ensure consistent style and catch potential issues.
Migration Scripts: Clean up auto-generated or exported SQL before running in production.
Learning SQL: Format example queries to understand clause order, join patterns, and subquery structure.

Frequently Asked Questions

What SQL dialects do you support?

The formatter works with PostgreSQL, MySQL, MariaDB, SQLite, and SQL Server / T-SQL. It recognizes common keywords and syntax patterns across all major dialects.

Is my SQL data safe?

Yes. Every operation runs entirely in your browser using a custom tokenizer and formatter. Your SQL queries never leave your device.

What formatting rules does it apply?

Keywords are uppercased. Major clauses (SELECT, FROM, WHERE, JOIN) start on new lines. Columns are comma-separated with line breaks. Subqueries are indented with 2-space indentation. Comments are preserved.

What is the difference between Beautify and Minify?

Beautify expands the query with proper indentation, line breaks, and uppercased keywords for readability. Minify removes all unnecessary whitespace and compresses the query into the smallest possible form — useful for storage or transmission.

Related Tools

JSON Formatter

Format and validate JSON data structures.

Regex Tester

Test and debug regular expressions in real-time.

YAML to JSON Converter

Convert between YAML and JSON formats.

Timestamp Converter

Convert Unix timestamps to readable dates.