SQL Query Formatter

About this tool

Beautify SQL by uppercasing keywords and placing each major clause on its own line, making complex queries readable.

Example

Input: select * from users where id=1

Output: SELECT * FROM users WHERE id=1

Privacy

This tool runs entirely in your browser. Your data is processed locally and never uploaded to a server.

How to use this tool

1. Paste your SQL query into the input box.
2. Choose the format or beautify action for the query.
3. Review the formatted SQL with keywords uppercased and clauses split onto separate lines.
4. Copy the cleaned query back into your editor or database tool.

Step by step, what happens

1. The formatter reads the SQL text and identifies common clauses like SELECT, FROM, WHERE, ORDER BY, and JOIN.
2. It normalizes keyword casing so SQL keywords appear in uppercase while leaving identifiers and string values unchanged.
3. It inserts line breaks before major clauses to make the query easier to scan and edit.
4. It returns a readable version of the same query without changing the query's meaning.

Worked example

Here is how the formatter handles a small query with filtering and sorting.

Input: select id, name from users where active = 1 order by name

1. The tool detects the SELECT, FROM, WHERE, and ORDER BY clauses in the input.
2. It changes the SQL keywords to uppercase and puts each major clause on its own line.
3. It keeps the column names, table name, and condition values as they are.

Tips and common mistakes

• Paste valid SQL if you want the best formatting, because the tool works by recognizing SQL structure.
• If your query already has line breaks, the formatter should still clean up keyword casing and clause placement.
• Do not expect it to change table names, column names, or filter values, because it is only formatting the query.
• If the result looks off, check for missing commas, quotes, or parentheses in the original SQL before formatting again.

Frequently asked questions