Sqruff
Sqruff: A focused open-source choice for dbt teams needing linting, formatting, and CI workflows. Ranked #2 of 25 in SQL Linters and Formatters by our editors (9.1/10); pricing: Free plan; best for dbt teams wanting modern linting and formatting.
At a glance
- Editor score9.1 / 10
- PricingFree plan
- Best fordbt teams wanting modern linting and formatting
- Free planYes
- Paid fromFree
- Supported SQL dialectsansi, athena, bigquery, clickhouse, databricks, db2, duckdb, exasol, greenplum, hive, mariadb, materialize, mysql, oracle, postgres, redshift, snowflake, sparksql, sqlite, starrocks, teradata, trino, tsql, vertica
- Automatic fixesYes
- Facts checked20 Sep 2026
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
Our verdict on Sqruff
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.
Your product? Our editors can test Sqruff in depth and publish a review, labelled as paid · from $149/mo →
Sqruff pricing
Sqruff fact sheet
| Free plan | Yes |
|---|---|
| Paid from | Free |
| Supported SQL dialects | 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 |
| Custom rules | Yes |
| Editor extensions | Yes |
| CI/CD integration | Yes |
| Configuration file | Yes |
| Deployment | Cloud, Self-hosted |
| Platforms | Web, macOS |
| Support | Community, Docs |
| Built for | Solo, Small business, Mid-market (editorial estimate) |
| Integrations | 5 integrations: GitHub Actions, Visual Studio Code, Zed, dbt, Docker |
| Pricing | Free plan |
| Website | github.com |
| Facts checked | 20 Sep 2026 |
Sqruff integrations
Sqruff lists 5 integrations on its own site.
- GitHub Actions
- Visual Studio Code
- Zed
- dbt
- Docker
Alternatives to Sqruff
- SQLFluffConfigurable SQL linting with autofix, templating, plugins, and CI workflows.9.4
- pgFormatterA configurable, open-source formatter for PostgreSQL-focused SQL workflows.8.8
- SQL EnlightA Windows toolkit for analyzing, formatting, fixing, and refactoring T-SQL.8.6
Sqruff vs the competition
- Sqruff vs SQLFluff
- Sqruff vs pgFormatter
- Sqruff vs SQL Enlight
- Sqruff vs TSQLLint
- Sqruff vs SQL Formatter
- Sqruff vs SQL Formatter VSCode
Compare Sqruff with any tool side by side →
Used Sqruff? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used Sqruff for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
Sqruff is listed in our SQL Linters and Formatters directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/sqruff/"><img src="https://www.itechguides.com/best/badge/sqruff.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
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