SQLFluff
The modular SQL linter and auto-formatter for multi-dialect enterprise data teams.
Why consider SQLFluff?
SQLFluff is an open-source, dialect-flexible SQL linter and automatic code formatter written in Python by Alan Cruickshank. SQLFluff parses and formats ANSI SQL, Postgres, Snowflake, BigQuery, ClickHouse, and dbt Jinja templates according to corporate code quality standards.
Learn SQLFluff by building
Practical setup notes, real use cases, and copy-ready examples in one focused guide.
In this guide2 sections
Overview of SQLFluff
SQLFluff enforces consistent SQL styling and catches syntax bugs in automated CI/CD pipelines.
Quickstart
pip install sqlfluffsqlfluff lint queries/ --dialect postgressqlfluff fix queries/ --dialect postgresSQLFluff is licensed under the permissive MIT License.
Related tools
More options with a similar category or technology profile.
diskus
Minimal, fast alternative to du -sh written in Rust using multi-threaded directory traversal.
peco
Simplistic interactive filtering tool for Unix pipelines, process lists, and file trees.
Dapr CLI
Command-line tool for managing Dapr distributed application runtime environments and sidecars.
Freeze
Generate beautiful image screenshots and SVGs of code snippets and terminal outputs.