Sqruff review
A focused open-source choice for dbt teams needing linting, formatting, and CI workflows.
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
Sqruff is an open-source SQL linter and formatter written in Rust for developers and data teams working with SQL codebases. It checks SQL against configurable rules, formats SQL automatically, and applies fixes through its CLI. The feature set is particularly relevant to dbt teams: Sqruff can lint and format dbt projects, support project-level configuration files, and analyze column-level SQL data lineage. Its published dialect coverage includes ANSI, Athena, BigQuery, ClickHouse, Databricks, DB2, DuckDB, Exasol, Greenplum, Hive, MariaDB, Materialize, MySQL, Oracle, Postgres, Redshift, Snowflake, SparkSQL, SQLite, StarRocks, Teradata, Trino, T-SQL, and Vertica.
For teams that want SQL standards inside development workflows, Sqruff combines automatic fixes, custom rules, editor integration, and continuous integration support. Its Language Server Protocol integration supports broader editor connectivity, while maintained integrations are available for Visual Studio Code and Zed. GitHub Actions integration brings linting into CI workflows, and Docker is also supported. These capabilities make Sqruff a practical fit for teams managing shared SQL conventions across local development, dbt projects, and pull-request workflows.
Sqruff is distributed as open-source software with a free plan, so it suits teams seeking a configurable SQL quality tool without a commercial tier structure. It is a focused option for dbt-centered development and teams comfortable working with CLI, configuration files, LSP, and CI integration. Teams prioritizing broader verified platform or editor coverage should compare alternatives such as SQLFluff, while those specifically seeking linting, formatting, autofix, custom rules, and lineage analysis in a dbt workflow will find Sqruff well aligned.
Sqruff pros and cons
- Where it wins
- Supports 24 SQL dialects with configurable and custom rules
- Formats SQL and applies automatic fixes through its CLI
- Connects dbt, editors, GitHub Actions, Docker, and LSP workflows
- Where it doesn't
- Its verified platform coverage is narrower than SQLFluff’s
- Editor support centers on Visual Studio Code and Zed
- Requires project-level configuration for tailored team standards
Sqruff fact sheet, pricing and score →
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.
Last updated · How we research and update