---
id: collate-sqlfluff
version: "3.5.3"
license: MIT License Copyright (c) 2023 Alan Cruickshank Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to… (full text in the JSON record)
license_treatment: permissive
maintenance: active
---

# collate-sqlfluff — The SQL Linter for Humans

License: permissive · Maintenance: active · Downloads: 770.9K/mo

## 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 above — verify before relying.

SQLFluff is a SQL linter and auto-fixer that checks SQL code for style and syntax errors across multiple SQL dialects, with support for Jinja templating and dbt.

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

pip install collate-sqlfluff
uv add collate-sqlfluff
poetry add collate-sqlfluff

## Installing collate-sqlfluff

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.

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')

Requires Python 3.9 or later.

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: MIT License Copyright (c) 2023 Alan Cruickshank Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to… (full text in the JSON record) (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 770.9K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

sql linter, sql formatter, sql style checker, sql code quality, sql auto-fix, sql dialect support, dbt sql linting, sql-linting, code-quality, dbt-integration

[View on SkillFed](https://skillfed.io/packages/collate-sqlfluff) · [View on PyPI](https://pypi.org/project/collate-sqlfluff/)