SQLFluff

What SQLFluff is

SQLFluff is an 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 fix many linting violations with one command. Documentation describes support for more than 25 dialects, including T-SQL, PostgreSQL, BigQuery, and Snowflake, as well as more than 70 rules for 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. The project is free under the MIT License and can be installed from PyPI using pip or another Python package manager. SQLFluff itself does not execute SQL, but templating macros such as dbt's run_query may do so; its Jinja templater uses Jinja2 SandboxedEnvironment to limit unsafe code execution. The dbt templater requires the relevant adapter and sqlfluff-templater-dbt package. Models that access a database at compile time also need database access. Community channels include documentation, GitHub, Slack, and Stack Overflow.