Specifiction
For vendors
AdvertiseTop spots, featured rows, home sponsor Get listedAdd a product we don't cover yet Claim a listingFree: verify the domain, then correct your page Vendor dashboardNumbers, orders and placements
List your tool
Vendor dashboard
Tech riderRev. 29 Sept 2026

Sqruff

Ch 047.2of 26 SQL Linters and Formatters
  1. 1Runs onBrowser, Linux, Mac, self-hosted, Web, Windows
  2. 2CostsFree plan
  3. 3Supported 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
  4. 4Automatic fixesYes
  5. 5Custom rulesYes
  6. 6Editor extensionsYes
  7. 7CI/CD integrationYes
  8. 8Configuration fileYes
8 lines stated Written from the maker's own pages: github.com
Visit site Alternatives
The Sqruff homepage

Overview

Sqruff is ranked #4 of 26 in SQL linters and formatters on Specifiction. It runs on Browser extension, Linux, macOS, Self-hosted, Web, Windows. There is a free plan.

Sqruff plans and pricing

All plans
Sqruff Free Open-source SQL linter and formatter github.com · 29 Sept 2026

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
All accessCh 01 Squawk AndroidAPI 7.4 All accessCh 02 sqlfmt Free planAPILinux Free to start7.3 All accessCh 03 Poor SQL Free planAPILinux Free to start7.2 All accessCh 05 TSQLLint Free planBrowserLinux Free to start7.2 All accessCh 06 JSQLFormatter Free planLinuxMac Free to start7.1 All accessCh 07 Sleek Free planBrowserLinux Free to start7.1

Where it ranks on Specifiction

Is Sqruff yours?

Claim it for free: prove the domain, then correct facts, plans and screenshots. An editor reviews every change.

Claim it free Promote Sqruff

Sources