SQL Formatter

// HOW TO USE

1. 01Paste a SQL query into the input area.
2. 02Click Format to pretty-print, or Minify to collapse to a single line.
3. 03Reserved keywords are uppercased; major clauses (SELECT, FROM, WHERE, JOIN, …) start a new line; AND/OR indent under the parent clause.

// WHEN TO USE

Use this when you're reading or writing SQL in test setup and teardown scripts, data seeding queries, or ORM-generated queries that you want to inspect. Formatted SQL makes JOIN chains, nested subqueries, and multi-condition WHERE clauses readable at a glance — catching a missing JOIN condition or a wrong filter before the test run is cheaper than debugging a data-state failure mid-suite.

// WHAT BUGS THIS FINDS

• Incorrect JOIN condition

  A test setup query JOINs on the wrong column, silently producing a Cartesian product — formatted output makes ON clauses easy to review side by side.

• Missing WHERE filter

  A teardown DELETE without a WHERE clause wipes the entire table; formatted SQL makes the absent clause obvious in code review.

• Operator precedence in compound conditions

  AND/OR precedence without parentheses produces a different filter than intended — formatting indents AND/OR blocks so the logic reads unambiguously.

• Type mismatch in comparison

  Comparing a VARCHAR column to an unquoted literal or a numeric string causes implicit conversion — readable formatting surfaces the literal type at a glance.

// QA USE CASES