Skip to content
SPECIFICTION
Get listed

Sqruff

github.com

Free plan WebWindowsmacOSLinuxSelf-hostedBrowser extension
Visit github.com
Spec score 7.5 #17 of 26 in SQL Linters and Formatters

What it is

Sqruff is a free SQL linter and formatter written in Rust, focused on formatting valid SQL for particular dialects and providing linting and fixes. It offers configurable automated formatting, custom rules, and column-level data lineage analysis for SQL queries. Dialects include ANSI, Athena, BigQuery, ClickHouse, Databricks, DuckDB, MySQL, Oracle, Postgres, Snowflake, SQLite, and Trino, among others. Dialect and rule settings are read from a project `.sqruff` configuration file. Developers can use the maintained VS Code and Zed integrations, or an LSP server with other LSP-capable editors. A documented GitHub Action supports use 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 repository provides an Apache-2.0 license. The project identifies dbt project support as experimental and is associated with Quary, an open-source analytics platform for engineers based in the United Kingdom.

Spec sheet

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.Read 29 Sep 2026 · playground.quary.dev
Headquarters
United KingdomRead 23 Sep 2026 · github.com
Maker
The GitHub organization describes Quary as an open-source analytics platform for engineers and lists the United Kingdom as its location.Read 29 Sep 2026 · github.com
Browser playground
The project provides a browser playground for trying Sqruff.Read 29 Sep 2026 · playground.quary.dev
CI integration
The installation guide documents a GitHub Action for installing and running Sqruff in CI.Read 29 Sep 2026 · playground.quary.dev
Configuration
Sqruff reads dialect and rule settings from a project `.sqruff` configuration file.Read 29 Sep 2026 · playground.quary.dev
dbt support
The overview labels dbt project support as experimental.Read 29 Sep 2026 · playground.quary.dev
Editor integrations
Sqruff maintains VS Code and Zed integrations and provides an LSP server for other LSP-capable editors.Read 29 Sep 2026 · playground.quary.dev
Installation
The guide lists Homebrew, a bash installer, pip, cargo, binary releases, and an official Docker image as installation options.Read 29 Sep 2026 · playground.quary.dev
Lineage
The overview lists column-level data lineage analysis for SQL queries as a feature.Read 29 Sep 2026 · playground.quary.dev
Linting and formatting
It offers customizable SQL linting and configurable automated formatting.Read 29 Sep 2026 · playground.quary.dev
Open source license
The GitHub repository identifies the project as public and provides an Apache-2.0 license.Read 29 Sep 2026 · github.com
SQL dialects
Supported dialects include ANSI, Athena, BigQuery, ClickHouse, Databricks, DuckDB, MySQL, Oracle, Postgres, Snowflake, SQLite, Trino, and others.Read 29 Sep 2026 · playground.quary.dev

Plans and prices

Sqruff Free Open-source SQL linter and formatter Read 29 Sep 2026 · github.com

Every Sqruff plan and price →

Strong points and limits

Strong points

  • Supports a broad range of SQL dialects.
  • Configurable rules and automated fixes.
  • VS Code, Zed, and LSP editor support.
  • GitHub Action documented for CI.
  • Browser playground available.

Limits

  • dbt project support is experimental.

Who it suits

Sqruff suits developers who want configurable SQL linting and formatting across many dialects. It also suits teams that want editor integrations or a documented GitHub Action for CI.

Verdict

Sqruff combines SQL linting, formatting, and fixes with editor, CI, and browser-playground options. Treat dbt support as experimental when assessing it for a dbt project.

Where Specifiction places it

Alternatives to SqruffAll alternatives →