sqlfmt vs Sqruff
| sqlfmt | Sqruff | |
|---|---|---|
| Free plan | No | Yes |
| Free trial | No | No |
| Paid from | — | Free |
| Open source | No | No |
| Platforms | Web | extension, Linux, macOS, self-hosted, Web, Windows |
| Free plan | Yes | Yes |
| Supported SQL dialects | PostgreSQL, MySQL, SQLite, SQL Server (T-SQL), BigQuery | ansi, athena, bigquery, clickhouse, databricks, db2, duckdb, exasol, greenplum, hive, mariadb, materialize, mysql, oracle, postgres, redshift, snowflake, sparksql, sqlite, starrocks, teradata, trino, tsql, vertica |
| Automatic fixes | Yes | Yes |
| Editor extensions | No | Yes |
| CI/CD integration | Yes | Yes |
| Custom rules | — | Yes |
| Configuration file | — | Yes |
Both are listed in Best SQL Linters and Formatters. On Samsung Mobile US Press, Sqruff scores higher on our published basis.