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

# sqlfluff — The SQL Linter for Humans

License: permissive · Maintenance: active · Downloads: 11.5M/mo

## What it is and what it does

SQLFluff is a dialect-flexible SQL linter designed to catch formatting, spacing, and style violations in SQL code. It works as a command-line tool that analyzes SQL files, reports issues with line and position information, and can automatically fix most violations. The tool is built to handle real-world SQL workflows, including templated SQL with Jinja and dbt projects.

It supports a wide range of SQL dialects—from ANSI SQL to vendor-specific variants like BigQuery, Snowflake, PostgreSQL, MySQL, and many others—making it useful across different database platforms and cloud data warehouses. The linter can be configured per project and integrates into development workflows via CLI, VS Code extension, or Docker, allowing teams to enforce consistent SQL style without manual review.

Use it for:

- Enforce consistent SQL formatting and style across a team's data pipeline or dbt project
- Automatically fix common SQL formatting issues like spacing and indentation in bulk
- Lint SQL code in CI/CD pipelines to catch style violations before deployment
- Validate SQL syntax and style for a specific database dialect (e.g., BigQuery, Snowflake)
- Integrate SQL quality checks into VS Code or other editors during development
- Standardize templated SQL with Jinja and dbt formatting in ELT applications

## 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 formatting issues across multiple SQL dialects, with support for Jinja templating and dbt.

Yes. SQLFluff is actively maintained, has no known vulnerabilities, installs with low friction, and carries a permissive MIT License. It fills a clear need for SQL code quality in modern data workflows. Install it if you work with SQL across multiple dialects, use dbt, or want to enforce team SQL style standards.

## Install

pip install sqlfluff
uv add sqlfluff
poetry add sqlfluff

## Installing sqlfluff

Before you install: Low friction install with 12 lightweight runtime dependencies. Active maintenance with releases monthly; last release 7 days ago. Repository shows strong community engagement with 9853 stars.

License in practice: MIT License (permissive) allows commercial and private use with minimal restrictions; you must include the license notice and copyright statement.

Quickstart:

pip install sqlfluff
echo "SELECT a FROM tbl;" > test.sql
sqlfluff lint test.sql --dialect ansi
sqlfluff fix test.sql --dialect ansi

Requires Python 3.10 or later. Optional Rust-backed parser available via extra install.

Verify before relying:

- Completeness of dialect support coverage (documentation notes 'perhaps not in full')
- Performance characteristics on large SQL files or projects
- Integration maturity with dbt workflows beyond basic support
- Build requirements for optional Rust-backed parser on unsupported platforms

## Package facts

- License: MIT License Copyright (c) 2018-2026 Alan Cruickshank Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"),… (full text in the JSON record) (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 11.5M/month (top 5,000 on PyPI)
- Known vulnerabilities: none known

## Tags

sql linter formatter, sql code quality checker, sql style guide enforcement, sql dialect support, dbt sql linting, jinja sql templating, sql auto-fix, sql formatting tool, sql-linting, data-pipeline, dbt-integration

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