What is dbt-mcp CLAUDE.md?

Project instructions for dbt-mcp, a server that lets AI assistants use dbt tools. dbt is software for building and managing data transformations, while MCP is a standard way for AI assistants to call tools.

Use them when adding or changing dbt-mcp tools, tool groups, configuration, or interactive tool interfaces. They help keep new tools connected to the server's architecture and tests.

They explain where the server's tools, configuration, prompts, and tests live. They also describe the project rules for defining, naming, grouping, and registering tools.

How dbt-labs/dbt-mcp configures Claude Code

Reuse

Borrowing it

Nothing to install: this file belongs to dbt-labs/dbt-mcp. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.

Copy the file

curl -O https://raw.githubusercontent.com/dbt-labs/dbt-mcp/main/CLAUDE.md

Clone the repo

git clone --depth 1 https://github.com/dbt-labs/dbt-mcp

Made for: Claude Code.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

README.md

[![agentmods](https://agentmods.dev/badge/instructions/dbt-labs/dbt-mcp/claude-md.svg)](https://agentmods.dev/instructions/dbt-labs/dbt-mcp/claude-md)

Your own site

<a href="https://agentmods.dev/instructions/dbt-labs/dbt-mcp/claude-md"><img src="https://agentmods.dev/badge/instructions/dbt-labs/dbt-mcp/claude-md.svg" alt="Measured on agentmods" height="20"></a>

Per session 886 This file is loaded in full into every session.

When invoked 886 The same file — it is already loaded in full.

Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.

Origin original No closer match found in the catalogue.

Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

Model	Per session	Once invoked
Fable 5.1	$0.00886	$0.00886
Opus 5	$0.00443	$0.00443
Sonnet 5	$0.00177	$0.00177
Haiku 4.5	$0.00089	$0.00089

Measured 8d ago against content hash 7c28bb09803e, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-07, from the pricing page.

Security

Grade A, and why

dbt-mcp CLAUDE.md scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 8d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

CLAUDE.md · 71 lines

How it starts

The opening of the file, as written. The whole thing — 71 lines — stays where its author put it; the contents beside it link to each section on GitHub.

CLAUDE.md

Project Overview

dbt-mcp is an MCP (Model Context Protocol) server that exposes dbt functionality as tools to AI assistants. Built on FastMCP from the mcp SDK.

Key Paths

Entry point: src/dbt_mcp/main.py
Server: src/dbt_mcp/mcp/server.py (DbtMCP class, create_dbt_mcp())
Tool infra: src/dbt_mcp/tools/ (definitions, registration, injection, toolsets, tool_names)
Tool categories: discovery/, semantic_layer/, dbt_cli/, dbt_codegen/, dbt_admin/, lsp/, mcp_server_metadata/
Prompts (tool descriptions): src/dbt_mcp/prompts/
Config: src/dbt_mcp/config/
Tests: tests/unit/, tests/integration/

Tool Architecture

Tools follow a consistent pattern:

@dbt_mcp_tool decorator defines the tool with metadata
ToolName enum in tools/tool_names.py — every tool needs an entry
Toolset mapping in tools/toolsets.py — maps tools to categories
Context injection via adapt_context() — tools receive typed context objects, but MCP only sees user-facing params
register_tools() in tools/register.py — precedence-based enablement (individual > toolset > default)

MCP Apps (tools with interactive UI)

Tools can have associated UIs via the meta field:

meta={"ui": {"resourceUri": "ui://dbt-mcp/app-name"}} on @dbt_mcp_tool
structured_output=True required so the host can pass structured JSON to the UI
Return type should be a Pydantic model
Register matching resource with @dbt_mcp.resource(uri=..., mime_type="text/html;profile=mcp-app")
Frontend uses @modelcontextprotocol/ext-apps SDK

Commands

task test:unit — run unit tests
task test:integration — run integration tests (requires dbt Platform credentials)
task install — install dependencies
task check — run linting and type checking. Run before every PR push.
task fmt — format code
task docs:generate — regenerate README tool list and d2 diagram from tool definitions (run after adding/removing tools)
task dev — run server with streamable-http transport
task inspector — run with MCP Inspector
uv run pytest tests/ --ignore=tests/integration -x -q — quick unit test run

Read the full file on GitHub · 71 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

8d ago First seen · 71 lines · 886 tokens per session scan A 7c28bb09803e

Subscribe to this mod's changes

dbt-mcp CLAUDE.md is an instructions file published in the GitHub repository dbt-labs/dbt-mcp (603 stars, last pushed 3d ago), licensed Apache-2.0. It adds 886 tokens to every session, about $0.0044 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

LLM data-analytics data-engineering mcp mcp-server model-context-protocol

codex AGENTS.md

AGENTS.md instructions for openai/codex, covering rust/codex-rs, the codex-core crate, code review rules, crate api surface and model visible context.

openai/codex · 5,153 tokens

vscode buildNext.instructions.md

Working notes and architecture documentation for the new esbuild-based build system in build/next. Use when making changes to the new build pipeline (transpile/bundle commands, NLS plugin, source-map handling, resource copying, or self-hosting watch tasks).

microsoft/vscode · 6,785 tokens

dbt-mcp: Instructions file for Claude Code