Sqruff
Ranked in SQL Linters and Formatters ·Free plan
About
Sqruff is a SQL linter and formatter written in Rust, with configurable linting, formatting, and automated fixes for a range of dialects. Its supported dialects include ANSI, Athena, BigQuery, ClickHouse, Databricks, DuckDB, MySQL, Oracle, Postgres, Snowflake, SQLite, and Trino, among others. Dialect and rule settings live in a project `.sqruff` configuration file. The project also lists column-level data lineage analysis for SQL queries. Developers can use maintained VS Code and Zed integrations or an LSP server with other LSP-capable editors. A documented GitHub Action supports installing and running Sqruff 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 project provides an Apache-2.0 license, and Sqruff is free. Support for dbt projects is marked experimental.
Who it is for
Sqruff suits developers who want configurable SQL linting and formatting in editors or CI. It may also suit teams interested in column-level lineage, provided experimental dbt project support meets their needs.
What is good
- Supports a broad range of SQL dialects.
- Offers automatic fixes and custom rules.
- Maintains VS Code and Zed integrations, plus an LSP server.
- GitHub Action is documented for CI.
- Free under an Apache-2.0 license.
What to know first
- dbt project support is experimental.
- No other limitations are listed in the provided facts.
Verdict
Sqruff offers free, configurable SQL linting and formatting with editor, LSP, and CI options. Treat dbt support as experimental when deciding whether it fits a project.
Compared on SQL linters and formatters
- Free plan
- Yesgithub.com
- 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, verticagithub.com
- Automatic fixes
- Yesgithub.com
- Custom rules
- Yesgithub.com
- Editor extensions
- Yesgithub.com
- CI/CD integration
- Yesgithub.com
- Configuration file
- Yesgithub.com
Facts
- Purpose
- Sqruff is a SQL linter and formatter written in Rust, focused on formatting valid SQL for specific dialects and providing fast linting and fixing.playground.quary.dev · 29 Sept 2026
- Linting and formatting
- It offers customizable SQL linting and configurable automated formatting.playground.quary.dev · 29 Sept 2026
- Lineage
- The overview lists column-level data lineage analysis for SQL queries as a feature.playground.quary.dev · 29 Sept 2026
- SQL dialects
- Supported dialects include ANSI, Athena, BigQuery, ClickHouse, Databricks, DuckDB, MySQL, Oracle, Postgres, Snowflake, SQLite, Trino, and others.playground.quary.dev · 29 Sept 2026
- Editor integrations
- Sqruff maintains VS Code and Zed integrations and provides an LSP server for other LSP-capable editors.playground.quary.dev · 29 Sept 2026
- CI integration
- The installation guide documents a GitHub Action for installing and running Sqruff in CI.playground.quary.dev · 29 Sept 2026
- Installation
- The guide lists Homebrew, a bash installer, pip, cargo, binary releases, and an official Docker image as installation options.playground.quary.dev · 29 Sept 2026
- Browser playground
- The project provides a browser playground for trying Sqruff.playground.quary.dev · 29 Sept 2026
- Configuration
- Sqruff reads dialect and rule settings from a project `.sqruff` configuration file.playground.quary.dev · 29 Sept 2026
- dbt support
- The overview labels dbt project support as experimental.playground.quary.dev · 29 Sept 2026
- Open source license
- The GitHub repository identifies the project as public and provides an Apache-2.0 license.github.com · 29 Sept 2026
- Maker
- The GitHub organization describes Quary as an open-source analytics platform for engineers and lists the United Kingdom as its location.github.com · 29 Sept 2026
Company
- Headquarters
- United Kingdomgithub.com · 23 Sept 2026
Best Sqruff alternatives
See all 20
Where it ranks on Inferse
Sources
- playground.quary.dev/docs/· checked 29 Sept 2026
- playground.quary.dev/docs/reference/dialects/· checked 29 Sept 2026
- playground.quary.dev/docs/usage/editors/· checked 29 Sept 2026
- playground.quary.dev/docs/getting-started/installation/· checked 29 Sept 2026
- github.com/quarylabs/sqruff· checked 29 Sept 2026
- github.com/quarylabs· checked 29 Sept 2026