Sqruff
github.com
- Free plan
- Windows
- macOS
- Linux
- Web
- Browser extension
- Self-hosted
What Sqruff is
Sqruff is a free SQL linter and formatter written in Rust. It checks SQL and can apply configurable formatting and automatic fixes, with dialect and rule settings stored in a project `.sqruff` configuration file. Supported dialects include ANSI, Athena, BigQuery, ClickHouse, Databricks, DuckDB, MySQL, Oracle, Postgres, Snowflake, SQLite, Trino, and others. The project also lists column-level data lineage analysis for SQL queries. Developers can use its VS Code or Zed integrations, or connect through its LSP server to other LSP-capable editors. A documented GitHub Action supports installing and running Sqruff in CI, and a browser playground lets users try it. 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. Sqruff is associated with Quary, an open-source analytics platform for engineers based in the United Kingdom. Support for dbt projects is marked experimental.
Who it suits
Sqruff suits developers who want configurable SQL linting and formatting across supported dialects. It can fit editor and CI workflows, while dbt users should note that project support is experimental.
Good to know, and what to watch
- Offers configurable formatting and automatic fixes.
- Supports many SQL dialects.
- Integrates with VS Code, Zed, and other LSP editors.
- A GitHub Action supports CI use.
- Several installation methods and a browser playground are available.
- dbt project support is experimental.
- Its dialect and rule settings use a project configuration file.
Plans
Every plan and priceSqruff
Free plan
Getting started
- Open the Sqruff GitHub website
- Install with Homebrew, the bash installer, pip, cargo, a binary release or Docker
- Create a project `.sqruff` file with dialect and rule settings
- Connect the VS Code or Zed extension, or an LSP-capable editor
- Add the documented GitHub Action to a CI workflow
- Try SQL in the browser playground
Limits to check
Sqruff is offered as a free plan at no cost. Support for dbt projects is identified as experimental.
The verdict
Sqruff combines SQL linting, formatting, automatic fixes, editor integrations, and CI support in a free, open-source project. Its dbt support is experimental, so teams relying on dbt should account for that limitation.
Questions people ask
What does Sqruff cost?
The Sqruff plan is free at no cost.
Which SQL dialects does it support?
Listed dialects include 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.
Can Sqruff fix SQL automatically?
Yes. It provides configurable formatting and automatic fixes.
Does it integrate with editors and CI?
Yes. Integrations are provided for VS Code and Zed, an LSP server supports other compatible editors, and a GitHub Action is documented for CI.
Is Sqruff open source?
The public repository uses the Apache-2.0 license.
How can Sqruff be installed?
Options include Homebrew, a bash installer, pip, cargo, binary releases and an official Docker image.
What the maker publishes
- Browser playground
- The project provides a browser playground for trying Sqruff. source
- CI integration
- The installation guide documents a GitHub Action for installing and running Sqruff in CI. source
- Configuration
- Sqruff reads dialect and rule settings from a project `.sqruff` configuration file. source
- dbt support
- The overview labels dbt project support as experimental. source
- Editor integrations
- Sqruff maintains VS Code and Zed integrations and provides an LSP server for other LSP-capable editors. source
- Headquarters
- United Kingdom source
- Installation
- The guide lists Homebrew, a bash installer, pip, cargo, binary releases, and an official Docker image as installation options. source
- Lineage
- The overview lists column-level data lineage analysis for SQL queries as a feature. source
- Linting and formatting
- It offers customizable SQL linting and configurable automated formatting. source
- Maker
- The GitHub organization describes Quary as an open-source analytics platform for engineers and lists the United Kingdom as its location. source
- Open source license
- The GitHub repository identifies the project as public and provides an Apache-2.0 license. source
- 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. source
- SQL dialects
- Supported dialects include ANSI, Athena, BigQuery, ClickHouse, Databricks, DuckDB, MySQL, Oracle, Postgres, Snowflake, SQLite, Trino, and others. source
Checked against the maker's pages on 29 Sept 2026.