How to use: SQL Formatter

Description

Beautify SQL queries: keywords on new lines with indent, SELECT lists one column per line, subqueries nested, string literals and comments untouched.

• Developer Tools
• Because everything is computed client-side, SQL Formatter is safe to use with sensitive data such as API keys, tokens or private logs.

How to use

Using SQL Formatter takes three steps:

1. Paste your data into the input box (or load the example).
2. Configure the options to match your target format or scenario.
3. Copy, download or inspect the output — it updates live as you type.

Run

Examples

A JOIN with filters — clauses break onto new lines, AND indents under WHERE, the string literal stays untouched.

Input

select o.id, o.total, c.name from orders o join customers c on c.id = o.customer_id where o.total > 100 and c.country = 'DE' order by o.total desc limit 10;

Output

SELECT o.id,
  o.total,
  c.name
FROM orders o
JOIN customers c
  ON c.id = o.customer_id
WHERE o.total > 100
  AND c.country = 'DE'
ORDER BY o.total DESC
LIMIT 10;

This output was produced by actually running the tool, not written by hand.

Use cases

Common situations where SQL Formatter helps:

• Beautify SQL queries: keywords on new lines with indent, SELECT lists one column per line, subqueries nested, string literals and comments untouched.

Parameters

This tool has no options — it works on the input alone.

FAQ

Good to know

• Everything runs client-side, so extremely large inputs are limited by your browser tab’s memory rather than by a server upload limit.

Related tools

SQL Formatter → · Developer Tools →