SQRust

A fast SQL linter written in Rust. The Ruff for SQL.

165 rules. Single binary. No Python required.

Why SQRust?

If you use sqlfluff, you know the pain: linting a 200-file dbt project takes minutes in CI. SQRust solves that.

Benchmarked on 500 real SQL files from GitLab's public dbt project (32,000 lines of production Snowflake SQL):

10× faster than sqruff. 682× faster than sqlfluff. More rules than both combined.

Measured with hyperfine (5 runs, real corpus, all tools in ANSI mode). Run the benchmark yourself.

Install

cargo (recommended):

cargo install sqrust-cli

Pre-built binary:

# macOS (Apple Silicon)
curl -sSL https://github.com/nafistiham/SQRust/releases/latest/download/sqrust-aarch64-apple-darwin.tar.gz | tar -xz
sudo mv sqrust /usr/local/bin/

# macOS (Intel)
curl -sSL https://github.com/nafistiham/SQRust/releases/latest/download/sqrust-x86_64-apple-darwin.tar.gz | tar -xz
sudo mv sqrust /usr/local/bin/

# Linux (x86_64)
curl -sSL https://github.com/nafistiham/SQRust/releases/latest/download/sqrust-x86_64-unknown-linux-gnu.tar.gz | tar -xz
sudo mv sqrust /usr/local/bin/

Build from source:

git clone https://github.com/nafistiham/SQRust.git
cd SQRust
cargo build -p sqrust-cli --release
# binary at: target/release/sqrust

Usage

# Lint a directory
sqrust check models/

# Lint a single file
sqrust check query.sql

# Auto-fix layout issues
sqrust fmt models/

Output:

models/orders.sql:12:5: [Convention/SelectStar] Avoid SELECT *; list columns explicitly
models/orders.sql:34:1: [Layout/TrailingWhitespace] Trailing whitespace on line
models/payments.sql:8:24: [Convention/ColonCast] Avoid PostgreSQL-style ::cast; use CAST() instead
models/payments.sql:41:1: [Layout/LongLines] Line exceeds 120 characters (was 143)

Rules

165 rules across 5 categories, mapped to sqlfluff's catalog where applicable.

Full rule list → docs/rules.md (coming soon)

Comparison

Configuration

Create a sqrust.toml in your project root. sqrust automatically finds it by walking up from the path you lint — no flags needed:

[sqrust]
exclude = ["dbt_packages/**", "target/**"]

[rules]
disable = [
    "Convention/SelectStar",
    "Layout/LongLines",
]

All 165 rules are enabled by default. Use disable to turn off specific rules by name.

See sqrust.toml.example for a fully annotated template.

v0.2.0 (planned): Ruff-style allowlist — opt into rule categories with select = ["Convention"] instead of opting out. Fields are reserved; using them now gives a clear error.

Pre-commit

# .pre-commit-config.yaml
repos:
  - repo: https://github.com/nafistiham/SQRust
    rev: v0.1.0
    hooks:
      - id: sqrust
        args: [check]

Run the Benchmark Yourself

curl -sSL https://raw.githubusercontent.com/nafistiham/SQRust/main/bench/benchmark.sh | bash

Or clone and run:

git clone https://github.com/nafistiham/SQRust
cd SQRust/bench
./benchmark.sh            # uses jaffle-shop as corpus
./benchmark.sh /your/dbt/project   # or point at your own project

Requires: hyperfine, sqlfluff, sqruff, sqrust on PATH.

Contributing

git clone https://github.com/nafistiham/SQRust
cd SQRust
cargo test --workspace   # all tests must pass

Each rule lives in sqrust-rules/src/<category>/<rule_name>.rs with a test file in sqrust-rules/tests/. Every rule has ≥13 tests. We use TDD — tests first.

License

MIT