SQLFluff
An open-source, dialect-flexible SQL linter for humans.
At a glance
- Editor scoreNot yet scored
- PricingFree plan
- Best forSQL and dbt teams
- Free planYes
- Paid fromNone
- 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.
SQLFluff pricing
SQLFluff fact sheet
| Free plan | Yes |
|---|---|
| Paid from | None |
| 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.—
- RuffFree Python linting and formatting with more than 900 built-in rules.—
- ShellCheckA free, open-source linter for shell syntax, portability, robustness and security checks.—
See all SQLFluff alternatives →
Also listed in
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 Sep 2026
Advertiser disclosure: iTechGuides is reader-supported. We may earn a commission when you click some links. It never changes a score or a verdict. How we rank.