sqlfmt vs Sqruff
sqlfmt
sqlfmt.appSqruff
github.comSide by side
| Figure | sqlfmt | Sqruff |
|---|---|---|
| Price from | $9/mo | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Web | Yes | Yes |
| Windows | — | Yes |
| macOS | — | Yes |
| Linux | — | Yes |
| API | Yes | — |
| Self-hosted | — | Yes |
| Plans published | 2 | 1 |
| Spec score · SQL Linters and Formatters | 7.9 (#12) | 7.5 (#17) |
| Maker | The About page says sqlfmt was built by Sharon Ben-Moshe. | The GitHub organization describes Quary as an open-source analytics platform for engineers and lists the United Kingdom as its location. |
Plans
In their own words
Sqruff
Sqruff is a free SQL linter and formatter written in Rust, focused on formatting valid SQL for particular dialects and providing linting and fixes. It offers configurable automated formatting, custom rules, and column-level data lineage analysis for SQL queries. Dialects include ANSI, Athena, BigQuery, ClickHouse, Databricks, DuckDB, MySQL, Oracle, Postgres, Snowflake, SQLite, and Trino, among others. Dialect and rule settings are read from a project `.sqruff` configuration file. Developers can use the maintained VS Code and Zed integrations, or an LSP server with other LSP-capable editors. A documented GitHub Action supports use in CI, and a browser playground is available. Installation options include Homebrew, a bash installer, pip, cargo, binary releases, and an official Docker image. The public repository provides an Apache-2.0 license. The project identifies dbt project support as experimental and is associated with Quary, an open-source analytics platform for engineers based in the United Kingdom.