Online SQL Formatter & Minifier

A secure, client-side utility to beautify (format) or minify (compress) SQL queries.

Dialect:

Snowflake ▼

Indent:

Tabs ▼

Action:

Format ▼

-- Result will appear here...

-- This is a publicly-available example query from the MIT Data Science tutorial, and is not necessarily a real query.
-- Source: https://www.mit.edu/~amidi/teaching/data-science-tools/tutorial/queries-with-sql/

SELECT
  f.origin_airport,
  apt.airport AS origin_airport_name,
  f.airline,
  air.airline AS airline_name,
  COUNT(*) AS nb_flights,
  AVG(
    CASE
      WHEN f.departure_delay > 15 THEN 1
      ELSE 0
    END
  ) AS perc_delayed

FROM flights f

LEFT JOIN airports apt
ON f.origin_airport = apt.iata_code
  AND condition_2

LEFT JOIN airlines air
ON f.airline = air.iata_code
  AND condition_2

WHERE
  f.scheduled_departure >= '2015-01-01'
  AND f.scheduled_departure < '2015-04-01'
GROUP BY 1, 2, 3, 4
HAVING nb_flights > 100
QUALIFY row_number() over (partition by airline order by nb_flights desc) = 1
ORDER BY perc_delayed DESC, 1, 2, 3
LIMIT 20
;

Why use this Client-Side SQL Formatter?

Most online SQL formatters send your code to a backend server to be processed. This creates a security risk for data engineers working with proprietary schemas or PII.

This tool runs 100% in your browser (using JavaScript). Your SQL code never leaves your device, making it safe for corporate environments, Snowflake/Redshift schemas, and production debugging.

Supported Dialects & Features

This tool utilizes the sql-formatter library to support specific syntax for modern cloud data warehouses:

Snowflake: Properly formats QUALIFY, LATERAL FLATTEN, and JSON traversal.
BigQuery: Handles Google Standard SQL, improving readability for nested structures (Structs/Arrays) and UNNEST operations.
AWS Redshift: Optimizes readability for complex ETL/ELT transformations and long transaction blocks.
Standard SQL: Also supports PostgreSQL, MySQL, Spark, and DB2.

Modes

Beautify (Format): Adds smart indentation, vertical alignment for SELECT columns, and strict casing for keywords. Best for debugging and code reviews.
Minify (Compress): Removes all unnecessary whitespace, newlines, and comments to reduce query size. Best for application logs and embedding SQL in code.