collate-sqlfluff
The SQL Linter for Humans
Decision gist · record as of 2026-08-14
Yes. SQLFluff is production-stable, actively maintained, permissively licensed under MIT, and has low install friction. It solves a real problem—enforcing SQL code quality across dialects—with broad dialect support and auto-fix capability. No known vulnerabilities. Install it if you need to lint or format SQL in your codebase or data pipeline.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python 3.9 or later.
- Low install friction with a pure-Python wheel and 13 common runtime dependencies.
- Active maintenance with releases monthly and a recent commit on 2026-05-28.
License · maintenance · safety
permissive license (permissive) — MIT License permits unrestricted use, modification, and distribution with minimal restrictions—suitable for both open-source and commercial projects.
last release 2026-05-28 (78 days) · last repo commit 2026-05-28
0 known vulnerabilities (OSV.dev, 2026-08-14) · 770,912 downloads/mo, #5,103 on PyPI
Alternatives
Verify before relying
pip install collate-sqlfluff
from sqlfluff.core import Linter
linter = Linter(dialect='ansi')
result = linter.lint_string('SELECT a FROM tbl')- Whether the package's Python API is considered stable or subject to breaking changes between minor versions.
- Performance characteristics when linting large SQL files or many files in batch.
What it is and what it does
SQLFluff is a dialect-aware SQL linter designed to catch formatting, spacing, and style issues in SQL code. It supports a wide range of SQL dialects—including Snowflake, BigQuery, PostgreSQL, MySQL, Redshift, DuckDB, and many others—as well as Jinja templating and dbt projects. The tool can both report violations and automatically fix most of them, making it useful for enforcing consistent SQL style across teams and codebases.
You use it primarily as a command-line tool (via `sqlfluff lint` and `sqlfluff fix`) but can also integrate it into Python workflows through its API. It has 13 runtime dependencies including click for CLI, Jinja2 for template support, and pytest for testing. The package is actively maintained with monthly releases and works on Python 3.9 through 3.13.
Use it for
- Enforce consistent SQL formatting and style across a team's dbt project or data pipeline.
- Automatically fix whitespace, indentation, and spacing issues in SQL files during CI/CD.
- Lint SQL code in multiple dialects without rewriting rules for each database system.
- Integrate SQL quality checks into a pre-commit hook or IDE workflow.
- Validate SQL templates that use Jinja variables before execution.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes.
SQLFluff is production-stable, actively maintained, permissively licensed under MIT, and has low install friction. It solves a real problem—enforcing SQL code quality across dialects—with broad dialect support and auto-fix capability. No known vulnerabilities. Install it if you need to lint or format SQL in your codebase or data pipeline.
Install
collate-sqlfluff on PyPI
Before you install
Low install friction with a pure-Python wheel and 13 common runtime dependencies. Active maintenance with releases monthly and a recent commit on 2026-05-28.
Requires Python 3.9 or later.
License in practice
MIT License permits unrestricted use, modification, and distribution with minimal restrictions—suitable for both open-source and commercial projects.
Quickstart
pip install collate-sqlfluff
from sqlfluff.core import Linter
linter = Linter(dialect='ansi')
result = linter.lint_string('SELECT a FROM tbl')Verify before relying
- Whether the package's Python API is considered stable or subject to breaking changes between minor versions.
- Performance characteristics when linting large SQL files or many files in batch.
Package facts
| License | permissive license permissive |
| Python support | Supports the current Python release >=3.9 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 13 packagesplatformdirschardetclickcoloramadiff-coverJinja2pathspecpytestpyyamlregextblibtomlitqdm |
| Maintenance | Actively maintained 78 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 770,912 / month, #5,103 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 5 - Production/StableEnvironment :: ConsoleIntended Audience :: DevelopersLicense :: OSI Approved :: MIT LicenseOperating System :: MacOSOperating System :: Microsoft :: WindowsOperating System :: POSIXOperating System :: UnixProgramming Language :: PythonProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.9Programming Language :: Python :: Implementation :: CPythonProgramming Language :: SQLTopic :: Software Development :: Quality AssuranceTopic :: Utilities |
Evidence: collate_sqlfluff-3.5.3-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “sql style checker”
- collate-sqlfluffSQLFluff is a SQL linter and auto-fixer that checks SQL code for…
- sqlfluffSQLFluff is a SQL linter and auto-fixer that checks SQL code for…
- sqlvalidatorFormats, validates, and checks SQL SELECT statements for syntactic…
Give your agent the search over MCP, or paste the wish link into any chat.
More Utilities packages
Converts domain names between Unicode and ASCII-compatible encoding (Punycode) according to IDNA 2008 and Unicode Technical Standard 46, with security validation and broader script coverage than the standard library.
Install it if you work with internationalized domain names, need to validate domains, or use HTTP clients that depend on it transitively.
Detects and normalizes text encoding from unknown or ambiguous sources, supporting all IANA character sets that Python's core library provides codecs for, with the ability to register custom codecs.
Setuptools is a Python build backend and package management tool that handles building, distributing, and installing Python packages, including support for C/C++ extension modules.
Pluggy provides a plugin system that lets you define hook specifications and register implementations to be called in sequence, enabling extensible Python applications without tight coupling.
Install it if you're building an extensible application or framework.
Pygments is a syntax highlighter that colorizes source code and text in over 500 languages and formats, outputting to HTML, LaTeX, RTF, SVG, images, or ANSI terminal sequences.
Install it if you need to display or transform source code.
Six provides utility functions to write Python code that runs on both Python 2.7 and Python 3.3+, smoothing over language differences between the two versions.
See also shandy-sqlfmt · sqlfluff · sqlfluff-templater-dbt · sqlfluffrs · acryl-sqlglot · sqlglot · sqlglotrs · sqlglotc · collate-sqllineage · simple-ddl-parser