SQL Formatting Best Practices Every Developer Should Know

You'll spend far more time reading SQL than writing it. Formatting conventions turn an unreadable wall of text into a query you can scan in seconds.

Bad vs good

SELECT id,name,email,created_at FROM users WHERE status='active' AND plan='pro' ORDER BY created_at DESC LIMIT 10;

Same query, formatted:

SELECT
  id,
  name,
  email,
  created_at
FROM users
WHERE status = 'active'
  AND plan = 'pro'
ORDER BY created_at DESC
LIMIT 10;

The rules that matter

• Keywords (SELECT, FROM, WHERE) in uppercase.
• One column per line in long SELECT lists.
• Indent continuations with two spaces.
• Put AND / OR at the start of the line.
• Alias tables meaningfully: users u.

Try the SQL formatter

FAQ