SQL Query Formatter & Beautifier Online

What is sql formatter?

A SQL query written on one long line, or copied out of an application log, is hard to read and harder to review — joins, subqueries and conditions all run together with no visual structure. This tool reformats a query with consistent indentation, line breaks around clauses (`SELECT`, `FROM`, `WHERE`, `JOIN`, `GROUP BY`), and configurable keyword casing, so the structure of the query is visible at a glance. It's dialect-aware — MySQL, PostgreSQL, SQL Server, Oracle and several others each have their own quoting and casting syntax (backticks, double-quoted identifiers, square brackets, `::type`), and picking the matching dialect keeps those intact instead of misreading them as errors.

When to use it

• Cleaning up a minified or single-line query pulled from an application log, ORM debug output, or a database's slow-query log before reading it.
• Formatting a query consistently before pasting it into a pull request or documentation, so reviewers can actually follow the logic.
• Standardising keyword casing (upper, lower, or left as-is) across a codebase or a team's SQL style guide.
• Making a deeply nested query with several joins and subqueries readable by giving every clause its own indentation level.

How to use this tool

1. Paste a SQL query, or click "Load example" to see a working sample.
2. Pick the SQL dialect that matches your database — this affects how identifiers, casts and dialect-specific syntax are parsed.
3. Choose a keyword case (UPPER, lower, or preserve as typed) and an indent width.
4. Copy the formatted result, download it as a .sql file, or copy a link that restores this exact query and its options.

Example

A single-line query with a join, filter and aggregation, formatted.

Input

select o.id, c.name, sum(o.total) as revenue from orders o join customers c on c.id = o.customer_id where o.status = 'paid' group by o.id, c.name order by revenue desc;

Output

SELECT
  o.id,
  c.name,
  sum(o.total) AS revenue
FROM
  orders o
  JOIN customers c ON c.id = o.customer_id
WHERE
  o.status = 'paid'
GROUP BY
  o.id,
  c.name
ORDER BY
  revenue DESC;

Each clause starts its own line, and JOIN conditions are indented under the FROM they belong to, so the query's structure is visible without reading every token.