handyman
Hazuu Tools

SQL Formatter & Beautifier

Format, beautify, and clean up your SQL queries instantly with support for multiple dialects.

Input SQL
Output
Formatted output will appear here...
info

About SQL Formatter

SQL Formatter is a free online tool that takes any SQL query — no matter how compressed or inconsistently indented — and restructures it with proper indentation, uppercased keywords, and logical line breaks aligned to the syntax of your chosen dialect. Paste a minified production query, a single-line ORM output, or a tangled multi-join statement and click Format: the output pane instantly renders a clean, readable version you can copy straight back into your codebase or ticket.

Database engineers and backend developers reach for this tool when reviewing a slow query reported in a monitoring dashboard, when trying to understand a stored procedure inherited from another team, or when writing a new query that needs to match a team's SQL style guide before it goes into a code review. The dialect selector covers Standard SQL, MySQL, PostgreSQL, PL/SQL, and T-SQL, so the keyword handling and spacing rules match the actual database engine in your stack. An indentation toggle lets you output 2-space, 4-space, or tab-indented SQL to fit your editor or linter configuration.

All formatting runs entirely in your browser using the sql-formatter JavaScript library. Your queries are never uploaded, stored, or transmitted to any server. Credentials, table names, personally identifiable WHERE-clause values, and internal schema logic remain on your own machine. The tool is free, requires no account, and has no usage limits.

star

Key Features

check_circle

Dialect-aware formatting

Choose from Standard SQL, MySQL, PostgreSQL, PL/SQL, or T-SQL. The formatter applies the spacing and keyword conventions specific to each engine so the output looks native to your database stack.

check_circle

Keyword uppercasing

SQL keywords such as SELECT, FROM, WHERE, GROUP BY, and HAVING are automatically capitalized, following the widely accepted convention for distinguishing commands from identifiers.

check_circle

Configurable indentation

Pick 2-space, 4-space, or tab indentation before formatting so the output slots into your project's existing code style without any manual adjustment.

check_circle

Minify mode included

Flip to Minify to strip all comments and collapse whitespace into a single-line query — useful when embedding SQL in application strings, log entries, or environment variables.

check_circle

Upload and download .sql files

Load a .sql file from disk directly into the editor and save the formatted result as formatted.sql without copying and pasting between windows.

check_circle

100% client-side, no data upload

Every format and minify operation runs in your browser. Connection strings, table names, and WHERE-clause values containing real data never leave your machine.

help

How to Use

01

Paste Your SQL

Copy your SQL query and paste it into the input editor on the left.

02

Select Dialect & Format

Choose your SQL dialect, then click "Format" to beautify or "Minify" to compress.

03

Copy the Result

Use the copy button to grab your formatted SQL, or download it as a .sql file.

code_blocks

Example

A compressed multi-statement query is formatted with 2-space indentation and uppercased keywords, making each clause immediately readable.

Minified SQL input
SELECT u.id,u.name,COUNT(o.id) AS order_count FROM users u LEFT JOIN orders o ON u.id=o.user_id WHERE u.is_active=1 GROUP BY u.id,u.name HAVING COUNT(o.id)>0 ORDER BY order_count DESC LIMIT 10;
Formatted SQL output
SELECT
  u.id,
  u.name,
  COUNT(o.id) AS order_count
FROM users u
LEFT JOIN orders o
  ON u.id = o.user_id
WHERE
  u.is_active = 1
GROUP BY
  u.id,
  u.name
HAVING
  COUNT(o.id) > 0
ORDER BY order_count DESC
LIMIT 10;
lightbulb

Common Use Cases

  • arrow_circle_right

    Reading query plans from slow-query logs

    Database monitoring tools dump captured queries as compressed single-line strings. Paste the raw log entry here to expand it into a readable structure before you start analyzing the execution plan or adding indexes.

  • arrow_circle_right

    Reviewing inherited stored procedures

    Stored procedures and views are often written without consistent formatting. Format them here before reading so you can follow the join conditions and WHERE logic without mentally parsing indentation.

  • arrow_circle_right

    Preparing SQL for code reviews

    A multi-join query on a single line is nearly impossible to review in a pull request diff. Format it first so each clause sits on its own line and reviewers can comment on specific conditions.

  • arrow_circle_right

    Matching team SQL style guides

    Many teams require uppercase keywords and a specific indentation width in all checked-in SQL. The dialect and indentation controls let you hit that convention in one pass instead of manually editing every keyword.

  • arrow_circle_right

    Debugging ORM-generated queries

    ORMs like SQLAlchemy, ActiveRecord, and Hibernate output queries as single compressed lines during logging. Format the query here to see the full structure with joins and subqueries before deciding whether to rewrite it.

quiz

Frequently Asked Questions

What is a SQL Formatter? expand_more
A SQL Formatter is a tool that takes SQL queries and restructures them with consistent indentation, keyword capitalization, and logical line breaks, making complex queries easier to read, debug, and maintain.
Which SQL dialects are supported? expand_more
The formatter supports Standard SQL, MySQL, PostgreSQL, PL/SQL (Oracle), and T-SQL (Microsoft SQL Server). Select your dialect from the dropdown in the toolbar for best results.
Is my SQL query secure? expand_more
Yes. All formatting is performed locally in your browser using JavaScript. Your SQL queries are never sent to any external server, keeping your database logic private.
Does this tool uppercase SQL keywords? expand_more
Yes. The formatter automatically capitalizes SQL keywords (SELECT, FROM, WHERE, etc.) for better readability, which is a widely accepted SQL coding convention.
Can I upload a SQL file? expand_more
Yes. Click the upload button in the toolbar to load a .sql file directly from your computer into the editor. The output can also be downloaded as a formatted.sql file.
How is SQL Formatter different from SQL Minifier? expand_more
SQL Formatter expands compressed or messy queries into a readable, indented form — the goal is human readability during development and review. SQL Minifier does the opposite: it strips whitespace and comments to produce the shortest possible query for embedding in application code or reducing log file sizes. They serve opposite workflows; use Formatter when you need to understand a query, and Minifier when you need to compact it.
Does formatting change how the query executes? expand_more
No. SQL engines treat whitespace as insignificant during parsing. A formatted query and its original minified version produce identical execution plans and results.
How is SQL Formatter different from JSON Formatter? expand_more
SQL Formatter is purpose-built for SQL syntax — SELECT, FROM, JOIN, WHERE, GROUP BY, and other database query clauses. JSON Formatter handles curly-brace key-value data. The two tools operate on completely different grammars and cannot process each other's input.