SQL Formatter

A client-side utility to beautify (or minify) complex SQL queries across multiple data warehouse dialects.

Dialect:

Indent:

Action:

Export:

-- 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
;

About This Project

This tool beautifies and minifies complex SQL queries, empowering Data Engineers to focus on logic and problem-solving by automating the visual formatting of their code.

Privacy: Runs entirely in your browser. Your proprietary queries never leave your machine.
Features:
- Vertical Formatting for readability, smart indentation, and strict keyword casing.
- Supported Dialects: Snowflake, BigQuery, Redshift, PostgreSQL, Spark, MySQL, and Standard SQL.