SQL Formatter: Make Long Queries Easy to Read

How to use the SQL Formatter

1. 1. Paste your SQLAdd one query or several, separated by semicolons.
2. 2. Set your styleChoose keyword case and 2 or 4 space indents.
3. 3. Copy the resultCopy the formatted query or download it as a .sql file.

What good SQL formatting looks like

A readable query puts each main clause on its own line, so you can scan it the way you read a report. For example, this:

select id, name from users where city = 'Noida' and active = 1 order by name

becomes this:

SELECT
  id,
  name
FROM
  users
WHERE
  city = 'Noida'
  AND active = 1
ORDER BY
  name

Subqueries are indented one step further, joins sit inside the FROM block, and CASE statements get a line for each WHEN. Lists inside brackets, such as function arguments and IN lists, stay on one line to keep things short.

What this tool will not change

Only spacing and keyword case change. Text in quotes, quoted column names and comments stay exactly as written, so 'select from' inside a string is left alone. Table and column names keep the case you typed.

The tool does not connect to any database and does not run your query. That also means it cannot tell you if a query is wrong, only make it easier to spot the problem yourself. An unclosed quote is the one error it does catch, with the line and column.

MySQL users who write \' inside strings should tick the backslash option. Exported the results as JSON? Move them to a spreadsheet with the JSON to CSV converter, or tidy them with the JSON formatter.

Frequently asked questions

More free tools

• JSON FormatterClean up messy JSON and find the exact line of any error.
• JSON to CSV ConverterConvert JSON arrays to clean CSV, with nested fields flattened.
• Regex TesterTest a regular expression and see its matches and groups.
• Cron Expression GeneratorBuild or explain a cron schedule and see its next 5 run times.
• Base64 Encoder & DecoderEncode and decode Base64 with full Unicode and file support.
• URL Encoder & DecoderPercent-encode text for links, or decode a messy URL to read it.

See all free tools