SQL Prettify

SQL to format: SELECT u.id, u.name, p.title FROM users u JOIN posts p ON u.id = p.user_id WHERE u.active = 1 AND p.published = 1 ORDER BY p.created_at DESC;

Keyword Case: UPPER lower Preserve

Indent Style: Standard Tabular Left Tabular Right

Format SQL

Minify SQL

Copy

Formatted SQL

About SQL Prettify

SQL Prettify formats and beautifies SQL queries for improved readability. Well-formatted SQL is easier to understand, debug, and maintain. This tool automatically indents, aligns, and organizes SQL statements according to standard formatting conventions, transforming messy one-line queries into clean, structured code.

The formatter supports multiple formatting options including keyword case (UPPER, lower, or preserve), indent styles (standard, tabular left, tabular right), and minification for production use. It handles complex queries with joins, subqueries, CTEs, and nested statements. The tool also offers minification to remove unnecessary whitespace for optimized query transmission.

Common Use Cases

Database developers format SQL queries for code reviews, documentation, and version control. Data analysts beautify exported queries from tools that generate compact SQL. Teams standardize SQL formatting across projects for consistency. Educators format SQL examples for teaching materials. Developers minify SQL for embedding in applications where size matters. The formatter helps identify syntax errors by making structure visible.

Paste your SQL query into the input field, select formatting options, and click Format SQL. For compact output, use Minify SQL. Copy the result for use in your database tools or code. All formatting happens locally in your browser.