pgFormatter comparisons
pgFormatter is compared head-to-head with SQLFluff, Sqruff and SQL Enlight and more: 7 head-to-heads in SQL Linters and Formatters, each with the specs and prices we checked.
pgFormatter head-to-head
- pgFormatter vs SQLFluff
- pgFormatter vs Sqruff
- pgFormatter vs SQL Enlight
- pgFormatter vs TSQLLint
- pgFormatter vs SQL Formatter
- pgFormatter vs SQL Formatter VSCode
- pgFormatter vs Prettier SQL
pgFormatter vs each of them
| # | Tool | Free plan | Paid from | Supported SQL dialects | Automatic fixes | Custom rules | Editor extensions | Score |
|---|---|---|---|---|---|---|---|---|
| 3 | pgFormatter | Yes | Free | SQL-92, SQL-99, SQL-2003, SQL-2008, SQL-2011, PostgreSQL; works with other databases | Yes | Yes | 8.8 | |
| 1 | SQLFluff | Yes | Free | Yes | 9.4 | |||
| 2 | Sqruff | Yes | Free | ansi, athena, bigquery, clickhouse, databricks, db2, duckdb, exasol, greenplum, hive, mariadb, materialize, mysql, oracle, postgres, redshift, snowflake, sparksql, sqlite, starrocks, teradata, trino, tsql, vertica | Yes | Yes | Yes | 9.1 |
| 4 | SQL Enlight | T-SQL | Yes | Yes | Yes | 8.6 | ||
| 5 | TSQLLint | Yes | Free | T-SQL (Transact-SQL) | Yes | Yes | Yes | 8.4 |
| 6 | SQL Formatter | Free | Standard SQL, BigQuery, ClickHouse, IBM DB2, IBM DB2i, DuckDB, Apache Hive, MariaDB, MySQL, TiDB, Couchbase N1QL, Oracle PL/SQL, PostgreSQL, Amazon Redshift, SingleStoreDB, Snowflake, Spark, SQLite, SQL Server Transact-SQL, Trino/Presto | Yes | Yes | 8.3 | ||
| 7 | SQL Formatter VSCode | Free | BigQuery, DB2 for LUW, DB2 for IBM i, DuckDB, Hive, MariaDB, MySQL, N1QL, PL/SQL, PostgreSQL, Amazon Redshift, SingleStoreDB, Snowflake, Spark, SQLite, Trino (Presto), Transact-SQL | Yes | Yes | 8.1 | ||
| 8 | Prettier SQL | Yes | Free | sql, bigquery, db2, db2i, hive, mariadb, mysql, n1ql, postgresql, plsql, redshift, singlestoredb, snowflake, spark, sqlite, transactsql, tsql, trino, clickhouse; node-sql-parser databases: bigquery, db2, hive, mariadb, mysql, postgresql, transactsql, flinksql, snowflake | Yes | 8.0 |
Compare pgFormatter with any SQL linter and formatter
These are the matchups our editors wrote up. The compare tool pairs pgFormatter with any other product in SQL Linters and Formatters — and up to four at once — from the same checked specs.
Compare pgFormatter with any tool side by side →
Every SQL linters and formatters head-to-head →
Our full pgFormatter verdict, pricing and fact sheet →
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.
Compared by iTechGuides Editors · Editorial team · Updated Oct 2026
Last updated · How we research and update