skills.rest
ivanshamaev
ivanshamaevCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

sqlfluff

Filters and routes S3 events to multiple destinations with customizable workflows and triggers.

14|1|Updated May 5, 2026
Search Tags:#linting#dbt#sql#pre-commit#ci quality gates#sql formatter#github actions annotations
One-click install
npx skills add https://github.com/ivanshamaev/de-agent-skills --skill sqlfluff
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqlfluff
Source: https://github.com/ivanshamaev/de-agent-skills/tree/main/skills/sqlfluff
Command: npx skills add https://github.com/ivanshamaev/de-agent-skills --skill sqlfluff

SYSTEM DOCUMENTATION & REQUIREMENTS

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.

Frequently Asked Questions about sqlfluff

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I enforce consistent SQL formatting in CI pipelines?▼

You can enforce consistent SQL formatting in CI by linting SQL files against a configurable SQLFluff rule set, using GitHub Actions annotations to surface style violations directly on pull requests.

Can I lint dbt models that use Jinja macros?▼

Yes, you can lint dbt models using Jinja macros by configuring the dbt templater to render macros and models, ensuring linting applies to the compiled SQL output.

How do I automatically fix SQL style violations locally?▼

Automatically fix SQL style violations locally by running sqlfluff fix to apply deterministic corrections, with configurable control over potentially unsafe transformations.

Does SQLFluff support pre-commit hooks for local validation?▼

Yes, SQLFluff supports pre-commit hooks for local validation, allowing developers to catch SQL style inconsistencies and formatting errors before they reach production.

How do I configure dialect-specific parsing and suppress inline violations?▼

Configure dialect-specific parsing via the .sqlfluff file and suppress inline violations using optional noqa comments to bypass specific linting rules where needed.

Can I implement custom SQL linting rules for organization-specific standards?▼

Yes, you can implement custom SQL linting rules as a plugin to meet organization-specific standards, extending the configurable SQLFluff rule set beyond default conventions.

Related Skills

Explore More Software Engineering Skills→
lciaccilciacci

sqlfluff

Lint standalone SQL files with sqlfluff and project dialect configuration.

Community
Intermediate
musher-devmusher-dev

formatting-sql

Configure SQL formatting standards with SQLFluff, pg_formatter, and atlas fmt.

Official
Intermediate
mvillmowmvillmow
18

ci-run-precommit

Run pre-commit hooks to validate code before committing in local or CI workflows.

Community
Intermediate
sfc-gh-dflipposfc-gh-dflippo
34

dbt-modeling

Create dbt models with CTE patterns and ref/source macros.

Community
Basic