SQL Formatter

Format and beautify SQL for MySQL, PostgreSQL, SQL Server, Oracle, SQLite and more — or minify it to one line.

Open file

Input

337 characters

Output

SELECT
  u.id,
  u.name,
  COUNT(o.id) AS orders,
  SUM(o.total) AS spent
FROM
  users u
  LEFT JOIN orders o ON o.user_id = u.id
  AND o.status IN ('paid', 'shipped')
WHERE
  u.created_at >= '2026-01-01'
  AND u.country = 'TH'
GROUP BY
  u.id,
  u.name
HAVING
  SUM(o.total) > 1000
ORDER BY
  spent DESC
LIMIT
  20;

UPDATE users
SET
  last_seen = now ()
WHERE
  id = 42;

2 statements · 27 lines

How to use

Paste one or more SQL statements, pick your database dialect and the output updates as you type.
Choose the indent and whether keywords, functions and data types are written in UPPER or lower case, or kept as you typed them.
Minify puts the query on one line and removes comments — handy for logs or code strings. Text inside quotes is never changed.

Good to know

The formatter only changes spacing and letter case — it doesn't run or check your query against a database.
Your SQL is formatted in your browser and never sent to a server.