skilld
All skills
dbt-labs avatar

/configuring-dbt-mcp-server

@faadc25 official
by dbt Labsdbt-labs/dbt-agent-skills729 stars
62

Generates MCP server configuration JSON, resolves authentication setup, and validates server connectivity for dbt. Use when setting up, configuring, or troubleshooting the dbt MCP server for AI tools like Claude Desktop, Claude Code, Cursor, or VS Code.

Ask your Agent

Use this Skill: https://skilld.dev/gh/dbt-labs/dbt-agent-skills/configuring-dbt-mcp-server

This session only. Nothing lands on disk.

referencesenvironment-variables.md

≈218 tokens on demand. Your agent reads this file only when SKILL.md points to it.

Environment Variable Reference

Variable Required For Description
DBT_PROJECT_DIR CLI commands Path to folder with dbt_project.yml
DBT_PATH CLI commands Path to dbt executable
DBT_HOST Platform access Default: cloud.getdbt.com
DBT_TOKEN Platform (non-OAuth) Personal or service token
DBT_ACCOUNT_ID Admin API Your dbt account ID
DBT_PROD_ENV_ID Platform access Production environment ID
DBT_DEV_ENV_ID SQL/Fusion tools Development environment ID
DBT_USER_ID SQL/Fusion tools Your dbt user ID
MULTICELL_ACCOUNT_PREFIX Multi-cell accounts Account prefix (exclude from DBT_HOST)
DBT_CLI_TIMEOUT CLI commands Timeout in seconds (default: 60)
DBT_MCP_LOG_LEVEL Debugging DEBUG, INFO, WARNING, ERROR, CRITICAL

Source: SKILL.md on GitHub

Third-party checks

1 warning16d5 checks · Risk SAFE
  • Gen Agent Trust Hub16d

    The skill provides instructions and configuration templates for setting up the dbt Model Context Protocol (MCP) server. It emphasizes security best practices for credential management and uses standard tools from dbt-labs.

  • Socket16d

    No alerts

  • Snyk16d

    Risk: LOW · No issues

  • Runlayer6mo

    3/4 files flagged

  • ZeroLeaks5mo

    Score: 93/100 · 2 sections analyzed

Provenance

Signed by skilld at faadc25. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub 2 days ago.

Activeupdated 7 months ago

Capability

user-invocable
false
metadata
{
  "author": "dbt-labs"
}

Topics

  • MCP
  • API
  • dbt
  • configuration
  • claude
  • cursor
  • vscode
  • authentication
  • semantic-layer

README badge

README badge for dbt-labs/dbt-agent-skills/configuring-dbt-mcp-server

What it does

Generates MCP server configuration JSON for dbt, handles credential setup, and validates connectivity across local and remote server types for Claude Desktop, Claude Code, Cursor, and VS Code. Use this when installing or troubleshooting the dbt MCP server to enable AI agents to access the dbt CLI, Semantic Layer, Discovery API, and Admin API.

Generated from the current SKILL.md.

Frequently asked

Does this skill work with Claude Desktop, Cursor, and VS Code?
Yes. The skill provides client-specific setup instructions for Claude Desktop, Claude Code, Cursor, and VS Code, with different configuration paths and formats for each.
What is the difference between local and remote dbt MCP server?
Local server runs via `uvx` on your machine and supports CLI commands (run, build, test) plus platform features if you add credentials. Remote server connects via HTTP to dbt Cloud and handles consumption only (querying metrics, exploring metadata) without CLI access.
Do I need a dbt Cloud account to use this skill?
Not for local CLI-only setups. A dbt Cloud account is required only if you want platform features (Semantic Layer, Discovery API, Admin API) or if you use the remote server.
How should I store sensitive credentials like tokens?
Use environment variable references (e.g., `${DBT_TOKEN}`) in config files instead of literal values, store tokens in `.env` files added to `.gitignore`, and never commit or log token values.
Can I enable SQL and codegen tools?
Yes, but they are disabled by default. Set `DISABLE_SQL=false` or `DISABLE_DBT_CODEGEN=false` as environment variables to enable them.

Generated from the current SKILL.md. These answers refresh after source changes.