SQLFluff
SQLFluff: A configurable open-source SQL linter for SQL and dbt teams. Ranked #16 of 33 in Linters by our editors (7.6/10); pricing: Free plan; best for SQL and dbt teams.
At a glance
- Editor score7.6 / 10
- PricingFree plan
- Best forSQL and dbt teams
- Free planYes
- Paid fromFree
- CI supportYes
- Facts checked21 Sep 2026
Where it wins
- Supports 26 SQL dialects and multiple templating formats
- Automatically fixes supported lint findings
- Works with CI/CD, pre-commit, GitHub Actions, and Python
Where it doesn't
- Self-hosted platform coverage only
- No native IDE support
- Autofix applies only to supported findings
Our verdict on SQLFluff
SQLFluff is an open-source SQL linter for developers and data teams working with ELT applications. It checks SQL for style and syntax issues, supports configurable rules, and can automatically fix supported findings. SQLFluff is suited to SQL and dbt teams that want consistent linting across projects, including teams that need parsing without database access. It is installed as a Python package and can be invoked from the command line or through its Python API.
Dialect and templating support are central to the product. SQLFluff supports 26 SQL dialects along with Jinja, placeholder, Python, and dbt templating. Its configurable rule sets allow teams to adapt linting to their conventions, while plugins provide a path for custom rules. Integration options include pre-commit, GitHub Actions, CI/CD workflows, and diff-quality, making it a practical fit for repositories where SQL checks are part of the development process.
The open-source, free model keeps access straightforward, with self-hosted deployment rather than a hosted platform. The product is focused on repository, command-line, and pipeline workflows; it does not include native IDE support, and automatic fixing is limited to supported findings. Choose SQLFluff when dialect coverage, dbt and Jinja templating, configurable rules, and CI integration matter most. Teams seeking an IDE-centered SQL linting experience or a hosted service should consider an alternative built around those requirements.
Your product? Our editors can test SQLFluff in depth and publish a review, labelled as paid · from $149/mo →
SQLFluff pricing
SQLFluff fact sheet
| Free plan | Yes |
|---|---|
| Paid from | Free |
| Languages supported | 28 |
| Autofix | Yes |
| Custom rules | Yes |
| Security rules | Not verified |
| IDE support | Not verified |
| CI support | Yes |
| Deployment | Self-hosted |
| Support | Community, Docs |
| Built for | Solo, Small business, Mid-market, Enterprise (editorial estimate) |
| Integrations | 5 integrations: Jinja, dbt, pre-commit, GitHub Actions, diff-quality |
| Pricing | Free plan |
| Website | sqlfluff.com |
| Facts checked | 21 Sep 2026 |
SQLFluff integrations
SQLFluff lists 5 integrations on its own site.
- Jinja
- dbt
- pre-commit
- GitHub Actions
- diff-quality
Alternatives to SQLFluff
- ESLintA free, extensible JavaScript linter with autofix, plugins, and broad developer-tool integrations.9.4
- RuffFree Python linting and formatting with more than 900 built-in rules.9.2
- ShellCheckA free, open-source linter for shell syntax, portability, robustness and security checks.9.0
See all SQLFluff alternatives →
Also Ranked In
SQLFluff is ranked in 3 of our directories.
Used SQLFluff? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used SQLFluff for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
SQLFluff is listed in our Linters directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/sqlfluff/"><img src="https://www.itechguides.com/best/badge/sqlfluff.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.
Last updated · How we research and update