SQL Formatter

How to use the SQL Formatter

1. 1Paste your SQL query into the input area.
2. 2Pick the database dialect (MySQL, PostgreSQL, SQL Server, etc.).
3. 3Choose an indentation width (2 spaces, 4 spaces or tab).
4. 4Optionally set keyword casing (upper, lower or preserve).
5. 5Click "Format" and read the tidied version.
6. 6Copy the formatted query back to your editor.

Key features

• ✓Support for MySQL, PostgreSQL, SQL Server, SQLite, BigQuery, Oracle
• ✓Configurable indentation and keyword case
• ✓Aligns SELECT columns, JOIN conditions and WHERE clauses
• ✓Handles subqueries and CTEs
• ✓Preserves comments
• ✓Runs offline in the browser

Examples

select u.id, u.name, count(o.id) as orders from users u left join orders o on u.id=o.user_id where u.active=1 group by u.id, u.name order by orders desc limit 20;

SELECT
  u.id,
  u.name,
  COUNT(o.id) AS orders
FROM users u
  LEFT JOIN orders o ON u.id = o.user_id
WHERE u.active = 1
GROUP BY u.id, u.name
ORDER BY orders DESC
LIMIT 20;

Why use this tool

• ◆Turns hard-to-read SQL into reviewable code
• ◆Speeds up debugging and code review
• ◆Enforces consistent style across a team
• ◆Supports many dialects without extra setup
• ◆Your queries stay private

Common use cases

• Preparing queries for a pull request
• Documenting complex reports
• Teaching SQL classes
• Formatting queries pasted from an ORM log
• Standardising code style across a team
• Reformatting queries copied from BI tools

Frequently asked questions