DBT CLI MCP Server
@MammothGrowth
About DBT CLI MCP Server
DBT CLI MCP Server
Basic information
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"dbt-cli-mcp": {
"command": "uv",
"args": [
"venv"
]
}
}
}Tools
8Run dbt models (requires absolute `project_dir`)
Run dbt tests (requires absolute `project_dir`)
List dbt resources (requires absolute `project_dir`)
Compile dbt models (requires absolute `project_dir`)
Debug dbt project setup (requires absolute `project_dir`)
Install dbt package dependencies (requires absolute `project_dir`)
Load CSV files as seed data (requires absolute `project_dir`)
Preview model results (requires absolute `project_dir`)
Overview
What is DBT CLI MCP Server?
The DBT CLI MCP Server is a Model Context Protocol (MCP) server that wraps the dbt CLI tool, enabling AI coding agents to interact with dbt projects through standardized MCP tools.
How to use DBT CLI MCP Server?
Install with Python 3.10+, uv, and dbt CLI. Clone the repository, create a virtual environment, and install dependencies. Use the command-line interface directly or configure the server in an MCP client (e.g., Claude for Desktop) using the provided JSON configuration. All tools require the absolute path to the dbt project directory.
Key features of DBT CLI MCP Server
- Execute dbt commands through MCP tools
- Supports run, test, compile, ls, debug, deps, seed, show
- Configurable dbt executable path and profiles directory
- Environment variable management for dbt projects
- Command-line interface for direct interaction
- Integration tests against a real dbt project
Use cases of DBT CLI MCP Server
- AI agents running dbt models automatically
- Debugging dbt project setup via MCP client
- Previewing model results with dbt_show
- Installing dbt package dependencies
FAQ from DBT CLI MCP Server
What is the most critical requirement when using the DBT CLI MCP tools?
You must specify the full absolute path to your dbt project directory with the project_dir parameter. Relative paths will not work.
How are dbt profiles handled?
The server automatically sets DBT_PROFILES_DIR to the absolute path specified in project_dir. The project directory must contain a valid dbt_project.yml and a profiles.yml file that matches the profile referenced in the project.
What are the prerequisites for installation?
Python 3.10 or higher, the uv tool for Python environment management, and the dbt CLI installed on your system.
How do I configure the server for an MCP client like Claude for Desktop?
Add an entry to the client's configuration with the uv command, pointing to the server script, and optionally set environment variables like DBT_PATH or ENV_FILE.
Can I override the default dbt executable path?
Yes, via the --dbt-path command-line option or the DBT_PATH environment variable. The default is dbt.
More Data & Analytics MCP servers
Bright Data MCP
luminati-ioA powerful Model Context Protocol (MCP) server that provides an all-in-one solution for public web access.
HubSpot MCP Server
baryhuangA Model Context Protocol (MCP) server that enables AI assistants to interact with HubSpot CRM data, providing built-in vector storage and caching mechanisms help overcome HubSpot API limitations while improving response times.
ArXiv MCP Server
blazickjpA Model Context Protocol server for searching and analyzing arXiv papers
Google Ads MCP
cohnenAn MCP tool that connects Google Ads with Claude AI/Cursor and others, allowing you to analyze your advertising data through natural language conversations. This integration gives you access to campaign information, performance metrics, keyword analytics, and ad management—all th
Deep Research
u14appUse any LLMs (Large Language Models) for Deep Research. Support SSE API and MCP server.
Comments