Free SQL Formatter

Free SQL Formatter to format, beautify, and minify SQL online with support for PostgreSQL, MySQL, SQLite, SQL Server, BigQuery, Snowflake, and more.

All processing happens in your browser. No data is sent to any server.

SQL Formatter & Minifier

Beautify messy SQL, or compress it for sharing and review.

Paste SQL, pick the dialect if needed, then format or minify.

Browser-only processing 8 dialect presets Copy or download output

Statements

Lines

Characters

552

How to use: Paste SQL, choose the right dialect if parsing fails, then use Format for readability or Minify for compact output.

Formatting Controls

Tune parsing and output style.

SQL dialect

CTEs, JSON, window functions, and PostgreSQL syntax.

Keyword case Function case Lines between queries Logical operator line breaks

Indent width

Tabs Trim comments Semicolon line break Dense operators

Actions

Size change: +14%

Source SQL

Paste or edit your query.

486 chars

Output

Readable result.

WITH
  recent_orders AS (
    SELECT
      o.id,
      o.customer_id,
      o.total_amount,
      o.created_at,
      ROW_NUMBER() OVER (
        PARTITION BY
          o.customer_id
        ORDER BY
          o.created_at DESC
      ) AS row_num
    FROM
      orders o
    WHERE
      o.created_at >= CURRENT_DATE - INTERVAL '30 days'
  )
SELECT
  c.name,
  c.email,
  r.total_amount,
  r.created_at
FROM
  recent_orders r
  INNER JOIN customers c ON c.id = r.customer_id
WHERE
  r.row_num = 1
  AND r.total_amount > 250
ORDER BY
  r.created_at DESC;