dbt testing & code quality · SQLFluff (open source project)

SQLFluff

Open-source SQL linter and auto-formatter with a dedicated templater for dbt projects across multiple SQL dialects.

Visit SQLFluff Alternatives

SQLFluff is a dialect-flexible SQL linter and auto-formatter that understands Jinja templating, which makes it usable directly against dbt models rather than only against plain SQL. Its dbt templater, maintained in the same repository, resolves ref() and macro calls before linting so rules are checked against the SQL a warehouse would actually run, and most rule violations can be auto-fixed rather than only flagged. It is run from the command line, in CI, or from an editor plugin, and is the linter used inside dbt Cloud's Studio IDE. As a pure linter and formatter, SQLFluff checks style and structural consistency, not data correctness, so teams typically pair it with a data-testing tool like Recce or Datafold for full quality coverage. It is free, MIT-licensed and self-hosted by nature since it runs wherever the project's code does.

At a glance

Vendor SQLFluff (open source project)
Pricing model Open source + paid options
Free tier Yes
Deployment Self-hosted
Open source Yes (MIT)
Best for Analytics engineering teams wanting consistent, auto-fixable SQL style enforcement across a dbt codebase.

Pricing

Free, open-source CLI tool; no paid tiers.

Pricing has not been verified yet — see the vendor's site.

Features

  • Configurable SQL linting across multiple dialects
  • Auto-fix for most rule violations
  • Dedicated dbt templater resolving ref() and macros before linting
  • CI and pre-commit integration
  • Used as the built-in linter in dbt Cloud's Studio IDE
  • Editor plugins for VS Code and others

Integrations

Profile last reviewed September 21, 2026

Head to head

Alternatives

dbt-checkpoint Open-source pre-commit hook library that enforces naming, documentation and testing standards on dbt models before they merge. dbt_project_evaluator Official dbt Labs package that audits a dbt project's modeling, testing, documentation and structure against best practices. Recce Open-source data-diffing agent that reviews the downstream impact of a dbt pull request before it merges.

SQLFluff in the index now

Terms to know

dbt (data build tool) An open-source tool from dbt Labs that lets analytics teams write data transformations as version-controlled, tested SQL. Data modeling The practice of organizing data into entities, relationships and schemas that make it accurate and efficient to query. Analytics engineer A role that builds and maintains the transformed, tested data models analysts and dashboards rely on.

Related guides

How to choose a dbt testing and code quality tool Work out which layer you are missing — SQL style, project governance, data-impact review, or a whole dev environment — before comparing products.