Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

SQLFluff

sqlfluff.com

  • Free plan
  • Windows
  • macOS
  • Linux
  • API
  • Self-hosted
7.5 Club score Visit sqlfluff.com

What SQLFluff is

SQLFluff is a free, open source SQL linter designed with ELT applications in mind. It flags style and syntax issues, parses SQL without requiring database access, and can automatically correct many linting violations with one command. Its documentation describes support for more than 25 dialects, including T-SQL, PostgreSQL, BigQuery, and Snowflake, as well as more than 70 rules covering style, structure, and best practices. SQLFluff supports Jinja templating and dbt, and can run in CI/CD pipelines, including GitHub Actions output for pull request annotations. It is released under the MIT License and can be installed from PyPI with pip or another Python package manager. SQLFluff itself does not execute SQL, but templating macros such as dbt’s run_query may execute it. Its Jinja templater uses Jinja2 SandboxedEnvironment to limit unsafe code execution. The dbt templater requires a relevant adapter and the sqlfluff-templater-dbt package; models that access a database at compile time also need database access. Community support channels include documentation, GitHub, Slack, and Stack Overflow.

Who it suits

SQLFluff suits teams that want to lint SQL for ELT work, including in CI/CD pipelines. It is also relevant to users working with Jinja or dbt templates.

Good to know, and what to watch

  • Free under the MIT License.
  • Parses SQL without database access.
  • Can autofix many linting violations.
  • Supports more than 25 dialects.
  • Integrates with CI/CD workflows.
  • dbt templating needs an adapter and extra package.
  • Some compile-time models require database access.
  • Templating macros may execute SQL.

SQLFluff

Free

Free plan

The verdict

SQLFluff provides free linting, autofix, and dialect support for SQL projects. Teams using dbt should account for its extra package and adapter requirements, and check whether their models need database access during compilation.

What the maker publishes

Auto-fix
SQLFluff can automatically fix many linting violations with a single command. source
dbt requirements
Using the dbt templater requires installing the relevant dbt adapter and sqlfluff-templater-dbt package, and models that access a database at compile time require database access. source
Dialect support
The documentation says SQLFluff supports more than 25 SQL dialects, including T-SQL, PostgreSQL, BigQuery, and Snowflake. source
Headquarters
Unit 82a James Carter Road, Mildenhall, Bury St. Edmunds, England, IP28 7DE source
Installation
The project’s website directs users to install SQLFluff from PyPI using pip or another Python package manager. source
Integrations
SQLFluff can be used in CI/CD pipelines and supports GitHub Actions output for pull request annotations. source
Linting
It reports SQL style and syntax issues so teams can focus code reviews on function rather than form. source
Maintainer
The website identifies SQLFluff Ltd. as incorporated in England and gives its registered address as Unit 82a James Carter Road, Mildenhall, Bury St. Edmunds, England, IP28 7DE. source
Parsing
It parses SQL to catch syntax issues without requiring database access. source
Purpose
SQLFluff is an open source, dialect-flexible SQL linter designed with ELT applications in mind. source
Rules
The documentation lists more than 70 linting rules covering style, structure, and best practices. source
Security
SQLFluff does not execute SQL itself, but templating macros such as dbt’s run_query may execute arbitrary SQL; its Jinja templater uses Jinja2 SandboxedEnvironment to limit unsafe code execution. source
Support
The project lists documentation, GitHub, Slack, and Stack Overflow as community channels. source
Templating
SQLFluff supports Jinja templating and dbt. source

Checked against the maker's pages on 5 Oct 2026.