CheckOps home

Tools directory

S

CheckOps

SQLFluff

SQLFluff is an MIT dialect-flexible SQL linter and auto-formatter with Jinja and dbt templating support.

Visit website

Latest public signals

Not refreshed yet. Refresh reads the public site and, when the entry has a GitHub repository, the latest release.

Visit Website

Introduction

SQLFluff is a dialect-flexible, configurable SQL linter designed with ELT applications in mind. It works with Jinja templating and dbt, and auto-fixes most linting errors.

It supports many dialects, including ANSI, BigQuery, Databricks, PostgreSQL, Snowflake, Spark SQL and T-SQL, with rules for layout, capitalisation, aliasing, references and more, configured in .sqlfluff. It runs from the command line or in CI.

In the quality loop SQLFluff enforces SQL quality in pull requests.

The source code is at sqlfluff/sqlfluff on GitHub under the MIT licence, with about 10,000 stars; the most recent commit was on 11 November 2026.

Features

  1. Many dialects: Warehouses and databases.
  2. Auto-fix: sqlfluff fix.
  3. Templating: Jinja and dbt.
  4. Configurable rules: Per project.
  5. CI output: Annotations formats.
  6. VS Code extension: Editor integration.

Pros

  1. dbt-friendly: Handles templated SQL.
  2. Free to use: Open source under the MIT licence, so the core tool costs nothing to use.
  3. Actively maintained: The repository had commits as recent as 11 November 2026.
  4. Community: About 10,000 GitHub stars.

Cons

  1. Speed: Large projects can be slow.
  2. Dialect gaps: Some syntax unsupported.
  3. Rule tuning: Defaults may be noisy.
pip install sqlfluff
sqlfluff lint models/ --dialect snowflake
sqlfluff fix models/ --dialect snowflake

Resources:

Pricing

SQLFluff is free and open source under the MIT licence.

  1. Analytics engineers and dbt users.

Conclusion

SQLFluff is the standard SQL linter for data teams.

Agree on rules before enabling fix.

On CheckOps, SQLFluff is filed under the Release & CI gates stage. Related tools listed here include pgTAP, utPLSQL, Atlas, Squawk, Database Lab Engine and dbt tests. Before standardising on one, compare recent maintenance activity, the pricing model as your usage grows, and the integrations you rely on today. Information on this page was verified against the official website, documentation and repository on 11 November 2026.

Alternatives

Other tools on CheckOps that cover similar ground. Open a page, or compare one with SQLFluff side by side.