KitScout

Platforms

dbt MCP servers, Agent Skills & plugins

33 tools that work with dbt: 4 MCP servers, 28 Agent Skills and 1 Claude Code plugin. 0 of the remote servers answered our live check, 0 worked without an API key, and 1 come from an official or verified publisher. Ranked by GitHub stars plus official, live and free-to-try signals.

Most common uses: SQL databases (18), Warehouses & analytics (BigQuery, Snowflake...) (11), Cloud providers & infrastructure as code (1), Vector databases & embeddings (1).

All tools

Type
Publisher
Runs
Status
Access
ToolStarsLast updateLicense
dbt-mcp
A MCP (Model Context Protocol) server for interacting with dbt.
MCP server
622——
dbt-transformation-patterns
Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building
SkillInstall · skills CLI
42,4956 days agoMIT
dbt-transformation-patterns
Production-ready patterns for dbt (data build tool) including model organization, testing strategies, documentation, and incremental processing.
SkillInstall · skills CLI
49,6721 day agoMIT
dbt-doctor
AI-driven quality & governance MCP Server for dbt projects. Audit coverage, profile data, detect schema drift, and auto-generate documentation — all t
MCP server
105——
dbt_ingest
Map dbt `schema.yml` / `properties.yml` models and sources into ktx semantic-layer overlays and column notes. Covers `sources:` vs `models:`, column `
SkillInstall · skills CLI
1,63223 days agoApache-2.0
adding-dbt-unit-test
Creates unit test YAML definitions that mock upstream model inputs and validate expected outputs. Use when adding unit tests for a dbt model or practi
SkillInstall · skills CLI
7638 days agoApache-2.0
answering-natural-language-questions-with-dbt
Writes and executes SQL queries against the data warehouse using dbt's Semantic Layer or ad-hoc SQL to answer business questions. Use when a user asks
SkillInstall · skills CLI
7638 days agoApache-2.0
building-dbt-semantic-layer
Use when creating or modifying dbt Semantic Layer components — semantic models, metrics, dimensions, entities, measures, or time spines. Covers Metric
SkillInstall · skills CLI
7638 days agoApache-2.0
configuring-dbt-mcp-server
Generates MCP server configuration JSON, resolves authentication setup, and validates server connectivity for dbt. Use when setting up, configuring, o
SkillInstall · skills CLI
7638 days agoApache-2.0
creating-mermaid-dbt-dag
Generates a Mermaid flowchart diagram of dbt model lineage using MCP tools, manifest.json, or direct code parsing as fallbacks. Use when visualizing d
SkillInstall · skills CLI
7638 days agoApache-2.0
fetching-dbt-docs
Retrieves and searches dbt documentation pages in LLM-friendly markdown format. Use when fetching dbt documentation, looking up dbt features, or answe
SkillInstall · skills CLI
7638 days agoApache-2.0
maintaining-dbt-documentation
Audits dbt documentation coverage and drafts missing model/column descriptions in the project's own house style, one folder at a time, for human revie
SkillInstall · skills CLI
7638 days agoApache-2.0
migrating-dbt-core-to-v2
Use when a user needs help triaging dbt-core to dbt v2 migration errors. Runs dbt-autofix first, then classifies remaining errors into actionable cate
SkillInstall · skills CLI
7638 days agoApache-2.0
migrating-dbt-project-across-platforms
Use when migrating a dbt project from one data platform or data warehouse to another (e.g., Snowflake to Databricks, Databricks to Snowflake) using db
SkillInstall · skills CLI
7638 days agoApache-2.0
querying-the-dbt-information-schema
Use when answering questions about a dbt v2 project's own metadata — which models, sources, tests, columns, configs, tags, packages or lineage exist,
SkillInstall · skills CLI
7638 days agoApache-2.0
running-dbt-commands
Formats and executes dbt CLI commands, selects the correct dbt executable, and structures command parameters. Use when running models, tests, builds,
SkillInstall · skills CLI
7638 days agoApache-2.0
troubleshooting-dbt-job-errors
Diagnoses dbt Cloud/platform job failures by analyzing run logs, querying the Admin API, reviewing git history, and investigating data issues. Use whe
SkillInstall · skills CLI
7638 days agoApache-2.0
upgrading-dbt
Use when a user wants to upgrade, update, or migrate a dbt project to the latest version — e.g. "upgrade my dbt project," "migrate this off dbt 1.5,"
SkillInstall · skills CLI
7638 days agoApache-2.0
using-dbt-for-analytics-engineering
Builds and modifies dbt models, writes SQL transformations using ref() and source(), creates tests, and validates results with dbt show. Use when doin
SkillInstall · skills CLI
7638 days agoApache-2.0
using-dbt-state
Use when a user is enabling, configuring, optimizing, or debugging dbt State (the server-backed reuse mechanism that clones or skips nodes instead of
SkillInstall · skills CLI
7638 days agoApache-2.0
working-with-dbt-mesh
Use when changing a dbt model in a way that could break its consumers — renaming, removing, or retyping a column, or changing a model that downstream
SkillInstall · skills CLI
7638 days agoApache-2.0
altimate-code
Delegates dbt and warehouse work to altimate-code, a specialized CLI agent with 100+ purpose-built data tools (SQL analysis, column-level lineage, dbt
PluginAnthropic marketplace
41 day agoMIT
altimate-code
Delegates dbt and warehouse work to altimate-code, a specialized CLI agent with 100+ purpose-built data tools. USE THIS SKILL FIRST whenever the task
SkillInstall · skills CLI
13618 days agoMIT
dbt-lineage
dbt model and column lineage, downstream impact and test proposals; no warehouse or dbt compile
MCP serverGitHub-verified authorLocal · Cargo
235 days agoMIT
creating-dbt-models
Creates dbt models following project conventions. Use when working with dbt models for: (1) Creating new models (any layer - discovers project's namin
SkillInstall · skills CLI
13618 days agoMIT
dbt-model-enhancement
Scoped enhancement of ONE existing dbt model from a ticket, with a validated PR as the deliverable. Use when: (1) User says "update <model> per JIRA-1
SkillInstall · skills CLI
13618 days agoMIT
debugging-dbt-errors
Debugs and fixes dbt errors systematically. Use when working with dbt errors for: (1) Task mentions "fix", "error", "broken", "failing", "debug", "wro
SkillInstall · skills CLI
13618 days agoMIT
developing-incremental-models
Develops and troubleshoots dbt incremental models. Use when working with incremental materialization for: (1) Creating new incremental models (choosin
SkillInstall · skills CLI
13618 days agoMIT
documenting-dbt-models
Documents dbt models and columns in schema.yml. Use when working with dbt documentation for: (1) Adding model descriptions or column definitions to sc
SkillInstall · skills CLI
13618 days agoMIT
migrating-sql-to-dbt
Converts legacy SQL to modular dbt models. Use when migrating SQL to dbt for: (1) Converting stored procedures, views, or raw SQL files to dbt models
SkillInstall · skills CLI
13618 days agoMIT
refactoring-dbt-models
Safely refactors dbt models with downstream impact analysis. Use when restructuring dbt models for: (1) Task mentions "refactor", "restructure", "extr
SkillInstall · skills CLI
13618 days agoMIT
testing-dbt-models
Adds schema tests and data quality validation to dbt models. Use when working with dbt tests for: (1) Adding or modifying tests in schema.yml files (2
SkillInstall · skills CLI
13618 days agoMIT
dbt-plan
Predicts the DDL a dbt change will execute, before you run it. Reads files, not the warehouse.
MCP serverGitHub-verified authorLocal · PyPI
210 days agoApache-2.0