Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Sqruff

github.com

  • Free plan
  • Windows
  • macOS
  • Linux
  • Web
  • Browser extension
  • Self-hosted
7.6 Club score Visit github.com

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.

Sqruff

Free

Free plan

Getting started

  1. Open the Sqruff GitHub website
  2. Install with Homebrew, the bash installer, pip, cargo, a binary release or Docker
  3. Create a project `.sqruff` file with dialect and rule settings
  4. Connect the VS Code or Zed extension, or an LSP-capable editor
  5. Add the documented GitHub Action to a CI workflow
  6. 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.