SQL Query Formatter

What Does This Tool Do?

It reformats SQL - adding consistent line breaks before major clauses (SELECT, FROM, WHERE, JOIN, GROUP BY, ORDER BY, HAVING) and indenting nested subqueries - without changing the query's meaning or the data it would return.

Why Use This Tool?

SQL pasted from a single-line export, a chat message, or a minified query is hard to read and debug. Consistent formatting makes clause structure and joins immediately clear at a glance.

How to Use It

1. Paste your SQL query.
2. Click Format.
3. Copy the cleanly formatted result.

Limitations

This is a practical formatter for common SQL syntax (SELECT/INSERT/UPDATE/DELETE, JOINs, subqueries) - it does not validate the query against a real database schema or execute anything. Use the SQL Query Validator for a syntax check.

Example

select o.id,o.total,c.name from orders o left join customers c on c.id=o.customer_id where o.status='paid' and o.created_at>='2026-09-01' order by o.created_at desc limit 50

becomes:

select
    o.id,
    o.total,
    c.name
from orders o
left join customers c on c.id=o.customer_id
where o.status='paid' and o.created_at>='2026-09-01'
order by o.created_at desc
limit 50

Why Formatting Helps Debugging

• Each clause starts its own line, so the query's shape - what is selected, joined, filtered and sorted - is clear at a glance.
• Joins stand out, so a missing join condition is easy to spot.
• Selected columns are listed one per line, which makes it easy to see duplicates or columns you do not need.
• Diffs in code review show exactly which condition changed.

Where Messy SQL Comes From

• ORM query logs (Laravel's toSql(), Django's connection.queries, Hibernate logs).
• Slow query logs and EXPLAIN sessions.
• Reports and BI tools that export one-line SQL.

Read our guide to formatting SQL queries. Shrink a query for embedding with the SQL Minifier, or build statements with the SQL Query Generator.