SQL Query Formatter & Prettifier

RAW SQL QUERY INPUT

Raw / Minified SQL Query

FORMATTED SQL OUTPUT

Prettified SQL Query

SQL Query Formatting & Readability Guide

Clean SQL query formatting is essential for database administration, code reviews, and performance debugging. Properly indented SQL queries make complex JOIN operations and filter conditions immediately obvious.

Key Formatting Conventions

Uppercase Keywords: Capitalize SELECT, FROM, WHERE, LEFT JOIN, GROUP BY, ORDER BY.
Newlines per Clause: Place top-level clauses on dedicated new lines.
Nested Subquery Indentation: Indent subqueries by 2 spaces.

Related Developer Tools

Generate UUID v7 primary keys with the UUID v7 Generator, format JSON payloads with the JSON Formatter, or validate schemas with the JSON Schema Validator.

Frequently Asked Questions

Common questions about this tool.

What does the SQL Formatter do? ▼

The SQL Formatter takes raw, unformatted, or minified SQL queries and formats them with consistent indentation, capitalized SQL keywords (SELECT, FROM, WHERE, JOIN), and structured clauses.

Which SQL dialects are supported? ▼

Supports Standard ANSI SQL, PostgreSQL, MySQL, MariaDB, SQLite, Microsoft SQL Server (T-SQL), and Google BigQuery.

Why should SQL keywords be capitalized? ▼

Capitalizing SQL keywords (e.g. `SELECT`, `GROUP BY`, `ORDER BY`) visually distinguishes structural command logic from table names and column identifiers.

Does this tool format complex nested subqueries? ▼

Yes! Subqueries enclosed in parentheses are recursively indented to maintain readability across deep joins.

Is my SQL query data kept private? ▼

100% private. Formatting is executed locally in your browser without sending database schemas or query strings to any external server.