Which AI clients are supported?

This skill provides specific configuration steps for Claude Desktop, Claude Code (CLI), Cursor, and VS Code.

Can I use this with dbt Core?

Yes, the local server configuration supports dbt Core users by running the server through uvx and pointing to your local project directory.

Do I need a dbt Cloud account for the remote server?

Yes, the remote server option requires a dbt Cloud account with AI features enabled and a valid Personal Access Token or Service Token.

What is the dbt MCP server?

It is a bridge that allows AI tools like Claude to interact with your dbt CLI, Semantic Layer, and APIs to perform data modeling tasks.

How do I find my dbt Environment ID?

In dbt Cloud, navigate to Deploy > Environments and click on your environment; the ID is the final numeric string at the end of the URL.

dbt MCP Server Setup

Name: dbt MCP Server Setup
Author: dbt-labs

bydbt-labs

•

Analytics & Monitoring

Guides the configuration and troubleshooting of dbt MCP server connections for AI-powered data engineering and analytics workflows.

The dbt MCP Server Setup skill provides a comprehensive framework for connecting AI tools like Claude Desktop, Claude Code, Cursor, and VS Code to the dbt ecosystem. By streamlining the setup process for both local CLI-driven workflows and remote dbt Cloud environments, this skill ensures that developers can seamlessly integrate AI capabilities with dbt's Semantic Layer, Discovery API, and CLI commands. It handles complex configuration tasks such as credential management, environment variable mapping, and client-specific JSON generation, making it an essential utility for analytics engineers looking to automate data modeling tasks with LLMs.

Key Features

0113 GitHub stars

02Step-by-step guidance for Local vs. Remote server selection

03Verification and troubleshooting steps for successful MCP deployment

04Credential discovery support for dbt Cloud Accounts and Tokens

05Environment variable mapping for dbt CLI and Semantic Layer tools

06Configuration templates for Claude Desktop, Cursor, and VS Code

Use Cases

01Connecting Cursor to the dbt Semantic Layer for AI-driven metric exploration

02Integrating dbt CLI commands directly into Claude Code for automated model building

03Configuring dbt Cloud API access for cross-project data lineage and discovery

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add dbt-labs/dbt-agent-skills configuring-dbt-mcp-server

For use in Claude.ai and ChatGPT

Download Skill