sqlfluff

What problem does it solve?

This skill removes SQL style drift by linting and auto-formatting SQL according to a configurable rule set, so teams catch inconsistencies before they reach production.

Core Features & Use Cases

• SQL linting with configurable quality gates: Run checks locally and in CI to enforce formatting and conventions (e.g., indentation, keyword casing, aliasing).
• dbt-templated SQL support: Render dbt Jinja macros and models via the dbt templater so linting applies to compiled SQL.
• Auto-fixing and safe/unsafe corrections: Apply deterministic fixes with sqlfluff fix, with control over potentially unsafe transformations.
• Developer workflow integration: Use pre-commit hooks and GitHub Actions annotations to surface violations inline on PRs.
• Custom rule extensibility: Implement custom SQLFluff rules as a plugin to meet organization-specific standards.

Quick Start

Install SQLFluff and the dbt templater, then lint a dbt models directory using the target dialect and templater settings.