SQL Formatting Guide: How to Write Clean and Readable Queries

In software projects, interacting with databases is at the core of overall functionality. What starts as a simple SELECT * FROM users query in a new project often grows into a massive multi-hundred-line structure containing complex JOIN operations, subqueries, and conditional filters.

Writing messy or unformatted SQL queries makes debugging, performance tuning, and code reviews a nightmare. In this guide, we will cover the gold standards for writing clean and readable SQL.

Rules for Writing Clean SQL

To ensure your SQL queries are readable by both you and your teammates, follow these industry-standard conventions:

1. Capitalize SQL Keywords

Although database engines are case-insensitive, humans rely on visual cues. Capitalize standard SQL clauses like SELECT, FROM, WHERE, JOIN, GROUP BY, and ORDER BY. Keep table and column names in lowercase (or as specified by your schema).

Bad: select name, email from users where status = 'active'

Good: SELECT name, email FROM users WHERE status = 'active'

2. Use Indentation and Multi-line Breaks

Avoid writing your entire query on a single line. Place each main clause on a new line, and indent columns or sub-conditions. In complex WHERE clauses with multiple filters, start each condition on a new line, prefixing it with an indented AND or OR.

Bad: SELECT id, name, created_at FROM orders WHERE status = 'pending' AND total_price > 100 ORDER BY created_at DESC;

Good:

SELECT 
  id, 
  name, 
  created_at 
FROM 
  orders 
WHERE 
  status = 'pending' 
  AND total_price > 100 
ORDER BY 
  created_at DESC;

3. Align JOIN Clauses and ON Conditions

When merging data from multiple tables, aligning your JOIN and ON clauses makes the relationship logic clear. Place JOIN on its own line and indent the matching ON condition by one level.

SELECT 
  u.name, 
  o.order_date, 
  o.total_amount 
FROM 
  users u 
  INNER JOIN orders o ON u.id = o.user_id 
WHERE 
  o.status = 'shipped';

Speed Up Query Formatting with our SQL Formatter

Manually restructuring, capitalizing, and indenting SQL queries by hand is tedious and time-consuming, especially when dealing with legacy codebases.

With our online SQL Formatter, you can paste messy, minified, or unformatted queries and instantly clean them up. The formatter automatically capitalizes clauses and applies proper nested indentation rules. The tool works completely client-side in your browser, keeping your database structure secure and confidential.