SQL Formatter/Beautifier

About SQL formatter/beautifier

The SQL formatter breaks a one-line query into readable lines, indents the main clauses and can convert keywords to uppercase. You choose a dialect, an indent width and whether to capitalize keywords. It is meant for tidying everyday SELECT, INSERT, UPDATE and DELETE statements before you review, share or commit them.

How to use it

1. Paste your statement into the SQL Input box.
2. Pick a SQL Dialect: MySQL, PostgreSQL, SQL Server, Oracle or SQLite.
3. Set Indent Size to 2, 4 or 8 spaces and decide whether Uppercase keywords stays switched on.
4. Click Format SQL.
5. Copy the tidied statement from the Formatted SQL card.

MySQL dialect, 2-space indent, uppercase keywords

select id, name from users where active = 1 and age > 18 order by name limit 10;

SELECT id,
  name
  FROM users
  WHERE active = 1
    AND age > 18
  ORDER BY name
  LIMIT 10;

When to use it

• Reading a long query copied out of an application log or slow-query report.
• Getting consistent capitalization and line breaks before a SQL file goes into code review.
• Making a generated ORM query legible enough to reason about its joins.
• Preparing a tidy query to paste into documentation or a support ticket.

Questions about SQL formatter/beautifier

What does the dialect setting actually change?

Only comma placement. MySQL and PostgreSQL put each comma at the end of a line, while SQL Server, Oracle and SQLite put it at the start of the next one. Keyword handling is identical across dialects.

Why did a function call or IN list get split across lines?

Every comma triggers a line break, including commas inside parentheses. A call such as COALESCE(a, b) or IN (1, 2) is split too, so this formatter suits simple queries better than heavily nested ones.

Are string literals safe from the formatter?

Not entirely. Keyword and comma rules run over the whole text, so a comma or a word like from inside quotes can be changed or broken onto a new line. Re-check any query that carries long text values.

Does formatting change what the query does?

It only adds whitespace and changes letter case on a fixed list of reserved words. Column and table names are left alone unless they happen to equal one of those keywords.

Related tools

• JSON validator & beautifierValidate JSON content and make it looks good.
• URL parserParse details from any URLs.
• JSONPath testerEvaluate JSONPath expressions against a JSON document and inspect every match in your browser.
• String escape and unescapeEscape or unescape text for JavaScript, JSON, HTML, XML, SQL, URL, RegExp, shell and CSV.
• HTML minifierMinify your HTML by removing all the unnecessary characters.
• CSS minifierMinify your CSS by removing all the unnecessary characters.