SQLFluff
sqlfluff.com
- Free plan
- Windows
- macOS
- Linux
- API
- Self-hosted
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.
Plans
Every plan and priceSQLFluff
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.