Best SQL Linters and Formatters in 2026
Updated
In short: Squawk is ranked #1 of 26 as of 4 October 2026, ahead of sqlfmt and Poor SQL. The best-ranked option with a free plan is sqlfmt.
SQL linters and formatters can help you apply conventions to queries and catch style issues during development. Compared on automatic fixes, custom rules, configuration files and supported SQL dialects, the entries also show how they connect to CI/CD pipelines and editors. Free plans and paid starting prices make it possible to weigh those capabilities alongside cost. Sqruff, TSQLLint and pgFormatter appear first, with sqlfmt and Sleek also among the early entries. Consider which dialects your projects use, whether you want automated corrections as well as checks, and how much control you need over rules and workflow integration.
26 SQL linters and formatters ranked on what their makers publish — plans and prices, free tiers, platforms and the facts on their own pages.
26ranked
12free plans on this page
4 Oct 2026last checked
Input list SQL Linters and Formatters 25 channels on this page · 110 of 200 spec lines stated by the makers
Ch Tool Free planPaid fromSupported SQL dialectsAutomatic fixesCustom rulesEditor extensionsCI/CD integrationConfiguration file Spec sheet Score
01 Squawk Free plannot statedPaid fromnot statedSupported SQL dialectsPostgreSQLAutomatic fixesNoCustom rulesNoEditor extensionsYesCI/CD integrationYesConfiguration fileYes 6/8spec lines stated 7.4
02 sqlfmt Free planYesPaid fromnot statedSupported SQL dialectsPostgreSQLAutomatic fixesYesCustom rulesnot statedEditor extensionsYesCI/CD integrationYesConfiguration filenot stated 5/8spec lines stated 7.3
03 Poor SQL Free planYesPaid fromnot statedSupported SQL dialectsT-SQLAutomatic fixesYesCustom rulesNoEditor extensionsYesCI/CD integrationNoConfiguration fileNo 7/8spec lines stated 7.2
04 Sqruff Free planYesPaid fromnot statedSupported SQL dialectsansi, athena, bigquery, clickhouse, databricks, db2, duckdb, exasol, greenplum, hive, mariadb, materialize, mysql, oracle, postgres, redshift, snowflake, sparksql, sqlite, starrocks, teradata, trino, tsql, verticaAutomatic fixesYesCustom rulesYesEditor extensionsYesCI/CD integrationYesConfiguration fileYes 7/8spec lines stated 7.2
05 TSQLLint Free planYesPaid fromnot statedSupported SQL dialectsT-SQL (Transact-SQL)Automatic fixesYesCustom rulesYesEditor extensionsYesCI/CD integrationnot statedConfiguration fileYes 6/8spec lines stated 7.2
06 JSQLFormatter Free plannot statedPaid fromnot statedSupported SQL dialectsOracle, SQL Server, MySQL, MariaDB, PostgreSQL, H2, DuckDB, BigQuery, Redshift, Databricks, SnowflakeAutomatic fixesnot statedCustom rulesnot statedEditor extensionsYesCI/CD integrationnot statedConfiguration filenot stated 2/8spec lines stated 7.1
07 Sleek Free planYesPaid fromnot statedSupported SQL dialectsPostgreSQL, MySQL, MariaDB, SQLite, SQL Server, OracleAutomatic fixesYesCustom rulesNoEditor extensionsYesCI/CD integrationnot statedConfiguration filenot stated 5/8spec lines stated 7.1
08 SQL Formatter Free plannot statedPaid fromnot statedSupported SQL dialectsStandard 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/PrestoAutomatic fixesYesCustom rulesnot statedEditor extensionsYesCI/CD integrationnot statedConfiguration fileYes 4/8spec lines stated 7.1
09 pgFormatter Free planYesPaid fromnot statedSupported SQL dialectsSQL-92, SQL-99, SQL-2003, SQL-2008, SQL-2011, PostgreSQL; works with other databasesAutomatic fixesYesCustom rulesnot statedEditor extensionsYesCI/CD integrationYesConfiguration fileYes 6/8spec lines stated 6.9
10 SQLint Free planYesPaid fromnot statedSupported SQL dialectsStandard SQL (BigQuery)Automatic fixesYesCustom rulesnot statedEditor extensionsnot statedCI/CD integrationYesConfiguration fileYes 5/8spec lines stated 6.7
11 PgSanity Free planYesPaid fromnot statedSupported SQL dialectsPostgreSQLAutomatic fixesnot statedCustom rulesnot statedEditor extensionsnot statedCI/CD integrationnot statedConfiguration filenot stated 2/8spec lines stated 6.6
12 SQL Formatter VSCode Free plannot statedPaid fromnot statedSupported SQL dialectsBigQuery, DB2 for LUW, DB2 for IBM i, DuckDB, Hive, MariaDB, MySQL, N1QL, PL/SQL, PostgreSQL, Amazon Redshift, SingleStoreDB, Snowflake, Spark, SQLite, Trino (Presto), Transact-SQLAutomatic fixesYesCustom rulesnot statedEditor extensionsYesCI/CD integrationnot statedConfiguration fileYes 4/8spec lines stated 6.5
13 Valk Guard Free planYesPaid fromnot statedSupported SQL dialectsPostgreSQLAutomatic fixesNoCustom rulesNoEditor extensionsnot statedCI/CD integrationYesConfiguration fileYes 6/8spec lines stated 6.2
14 SQLCheck Free planYesPaid fromnot statedSupported SQL dialectsMicrosoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite3Automatic fixesNoCustom rulesnot statedEditor extensionsNoCI/CD integrationnot statedConfiguration fileNo 5/8spec lines stated 6.1
15 SQL Enlight Free plannot statedPaid fromnot statedSupported SQL dialectsT-SQLAutomatic fixesYesCustom rulesYesEditor extensionsYesCI/CD integrationYesConfiguration fileYes 6/8spec lines stated 5.9
16 SQL Pretty Printer Free planYesPaid fromnot statedSupported SQL dialects30+; SQL Server, Oracle, MySQL, PostgreSQL, Snowflake, BigQueryAutomatic fixesYesCustom rulesnot statedEditor extensionsYesCI/CD integrationnot statedConfiguration filenot stated 4/8spec lines stated 5.9
17 sqlfmt Free planYesPaid fromnot statedSupported SQL dialectsPostgreSQL, MySQL, SQLite, SQL Server (T-SQL), BigQueryAutomatic fixesYesCustom rulesnot statedEditor extensionsNoCI/CD integrationYesConfiguration filenot stated 5/8spec lines stated 5.8
18 SQL Linter by SqlInt Free planYesPaid fromnot statedSupported SQL dialectsStandard SQL (ANSI), PostgreSQL, MySQL, SQLite, BigQuery, Snowflake, SQL Server (T-SQL)Automatic fixesYesCustom rulesnot statedEditor extensionsnot statedCI/CD integrationnot statedConfiguration filenot stated 3/8spec lines stated 5.7
19 prettier-plugin-sql-cst Free planYesPaid fromnot statedSupported SQL dialectsSQLite, BigQuery, PostgreSQL, PL/pgSQL, MySQL, MariaDBAutomatic fixesYesCustom rulesnot statedEditor extensionsYesCI/CD integrationnot statedConfiguration fileYes 5/8spec lines stated 5.6
20 Primova SQL Formatter & Linter Free planYesPaid fromnot statedSupported SQL dialectsStandard SQL, PostgreSQL, MySQL, SQLite, MariaDB, T-SQL (SQL Server), BigQuery, SnowflakeAutomatic fixesnot statedCustom rulesnot statedEditor extensionsNoCI/CD integrationnot statedConfiguration filenot stated 3/8spec lines stated 5.6
21 Public Tools SQL Formatter Free planYesPaid fromnot statedSupported SQL dialectsStandard SQL, PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, Oracle PL/SQL, BigQuery, Snowflake, Redshift, Spark, Hive, Trino, DuckDB, ClickHouse, Db2, N1QL, SingleStore, TiDBAutomatic fixesNoCustom rulesnot statedEditor extensionsnot statedCI/CD integrationnot statedConfiguration filenot stated 3/8spec lines stated 5.6
22 RegSQL Free planYesPaid fromnot statedSupported SQL dialectsPostgreSQL, MySQL, MariaDB, SQLite, BigQuery, SQL Server, Snowflake, Oracle PL/SQL; the site also states 9 dialects but visibly names 8Automatic fixesYesCustom rulesnot statedEditor extensionsnot statedCI/CD integrationnot statedConfiguration filenot stated 3/8spec lines stated 5.6
23 Prettier SQL Free planYesPaid fromnot statedSupported SQL dialectssql, 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, snowflakeAutomatic fixesYesCustom rulesnot statedEditor extensionsnot statedCI/CD integrationnot statedConfiguration fileYes 4/8spec lines stated 5.5
24 sql-tools Free planYesPaid fromnot statedSupported SQL dialectsSnowflake, BigQuery, Databricks, PostgreSQL, MySQL, SQL ServerAutomatic fixesnot statedCustom rulesnot statedEditor extensionsnot statedCI/CD integrationnot statedConfiguration filenot stated 2/8spec lines stated 5.4
25 SQLFluff Free planYesPaid fromnot statedSupported SQL dialectsnot statedAutomatic fixesnot statedCustom rulesYesEditor extensionsnot statedCI/CD integrationnot statedConfiguration filenot stated 2/8spec lines stated 5.4
Is your tool on this list?
Numbered spots on this list can be sponsored. They are labelled, and the editorial order and scores never change for payment.
Questions about this list
Which SQL linters and formatter is ranked first on Specifiction?
Squawk is ranked #1 of 26 with a score of 7.4. sqlfmt is second and Poor SQL third.
How many of these have a free plan?
12 of the 25 on this page publish a free plan on their own pricing pages.
How is this list ranked?
Ranked on what each maker publishes, the fullest spec sheet first: how deeply the product is documented, the platforms it runs on, a free tier or trial to test it, and its standing. Paid placements never change a rank.
More in Developer Tools
All developer tools listsAccessibility Testing Software 168Log Management Software 107AI Coding Assistants 103Package Managers 93AI Agent Platforms 73Reverse Engineering Tools 73Software Composition Analysis Software 65Browser Automation Tools 63Integrated Development Environments 62Artifact repository software 60Code Playground Software 58Network Monitoring 56