sqlfluff-templater-dbt
Lint your dbt project SQL
Decision gist · record as of 2026-08-14
Yes, if you use dbt and want to lint your project's SQL. The plugin is actively maintained, has no known vulnerabilities, uses a permissive MIT license, and integrates cleanly with SQLFluff's existing multi-dialect support. Install it when you need to enforce SQL quality standards on dbt-generated code.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires dbt-core to be installed and a valid dbt project structure with dbt_project.yml present for template resolution.
- Low install friction with a pure-Python wheel.
- Actively maintained with a release 7 days ago and 9853 GitHub stars.
License · maintenance · safety
permissive license (permissive) — MIT License permits unrestricted use, modification, and distribution with minimal restrictions—suitable for commercial and open-source projects alike.
last release 2026-08-07 (7 days) · last repo commit 2026-08-14 · 9,853 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 3,717,769 downloads/mo, #2,518 on PyPI
Alternatives
Verify before relying
pip install sqlfluff-templater-dbt
from sqlfluff.core import Linter
linter = Linter(dialect='snowflake', templater='dbt')
result = linter.lint_string('SELECT * FROM {{ ref("my_model") }}')- Specific dbt versions or configurations required for full compatibility with this templater plugin.
- Whether the templater supports all dbt features (macros, packages, custom tests) or has known limitations.
- Performance characteristics when linting large dbt projects with many models and dependencies.
What it is and what it does
sqlfluff-templater-dbt is a plugin that extends SQLFluff's linting capabilities to work with dbt projects. It allows SQLFluff to parse and lint dbt template syntax—Jinja2 expressions, dbt macros, and ref() calls—by rendering them through dbt's templating engine before analysis. This bridges the gap between dbt's SQL generation and SQLFluff's dialect-aware linting, letting you enforce SQL style and correctness rules across your entire dbt project.
The plugin is designed for teams using dbt for ELT workflows who want to maintain consistent SQL quality and formatting standards. It integrates dbt-core and jinja2-simple-tags to handle template resolution, then applies SQLFluff's linting rules to the rendered output. You can use it to auto-fix formatting issues, catch SQL errors, and enforce organizational style guides on dbt-generated SQL.
Use it for
- Enforce SQL formatting and style standards across a dbt project's models and tests.
- Auto-fix spacing, indentation, and syntax issues in dbt SQL before deployment.
- Catch SQL dialect-specific errors in dbt models targeting Snowflake, BigQuery, or other databases.
- Integrate dbt SQL linting into CI/CD pipelines to gate model deployments on code quality.
- Validate dbt macros and templated SQL for consistency across teams.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you use dbt and want to lint your project's SQL.
The plugin is actively maintained, has no known vulnerabilities, uses a permissive MIT license, and integrates cleanly with SQLFluff's existing multi-dialect support. Install it when you need to enforce SQL quality standards on dbt-generated code.
Install
sqlfluff-templater-dbt on PyPI
Before you install
Low install friction with a pure-Python wheel. Actively maintained with a release 7 days ago and 9853 GitHub stars. Requires sqlfluff, dbt-core, and jinja2-simple-tags as runtime dependencies.
Requires dbt-core to be installed and a valid dbt project structure with dbt_project.yml present for template resolution.
License in practice
MIT License permits unrestricted use, modification, and distribution with minimal restrictions—suitable for commercial and open-source projects alike.
Quickstart
pip install sqlfluff-templater-dbt
from sqlfluff.core import Linter
linter = Linter(dialect='snowflake', templater='dbt')
result = linter.lint_string('SELECT * FROM {{ ref("my_model") }}')Verify before relying
- Specific dbt versions or configurations required for full compatibility with this templater plugin.
- Whether the templater supports all dbt features (macros, packages, custom tests) or has known limitations.
- Performance characteristics when linting large dbt projects with many models and dependencies.
Package facts
| License | permissive license permissive |
| Python support | Not specified |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 3 packagessqlfluffdbt-corejinja2-simple-tags |
| Maintenance | Actively maintained 7 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 3,717,769 / month, #2,518 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.14Programming Language :: Python :: Implementation :: CPythonTopic :: Software Development :: Quality AssuranceTopic :: Utilities |
Evidence: sqlfluff_templater_dbt-4.3.0-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 › “dbt sql linting”
- sqlfluff-templater-dbtEnables SQLFluff to lint and auto-fix dbt project SQL using dbt…
- 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…
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 collate-sqlfluff · dbt-extractor · sqlfluff · dbt-core-interface · shandy-sqlfmt · sqlfluffrs · sqlglot · sqlglotrs · collate-sqllineage · dbt-osmosis