SQL Formatter

SQL Formatter is a JavaScript library for pretty-printing SQL queries.

It started as a port of a PHP Library, but has since considerably diverged.

It supports various SQL dialects: GCP BigQuery, IBM DB2, Apache Hive, MariaDB, MySQL, TiDB, Couchbase N1QL, Oracle PL/SQL, PostgreSQL, Amazon Redshift, SingleStoreDB, Snowflake, Spark, SQL Server Transact-SQL, Trino (and Presto). See language option docs for more details.

It does not support:

• Stored procedures.
• Changing of the delimiter type to something else than.

Last Releases

• 15.6.6June 28, 2025
  Support ODBC date format in TransactSQL #877 (Thanks to @archonic)
• 15.6.5June 18, 2025
  Bugfix Support UUID type and functions in PostgreSQL (#876)
• 15.6.4June 10, 2025
  Bugfix Fix capitalization of IS NOT NULL (#872)