dbt-core-mcp
Verified Safeby NiclasOlofsson
Overview
A Model Context Protocol (MCP) server that empowers AI assistants (like Copilot) to interact with and manage dbt projects. It enables natural language control over dbt operations, providing project metadata, lineage, impact analysis, SQL query execution, and intelligent build/test workflows, all while respecting the user's local dbt environment.
Installation
uvx dbt-core-mcpEnvironment Variables
- EXPERIMENTAL_FEATURES
- DBT_PROFILES_DIR
- DBT_TARGET
Security Notes
The server executes user-provided dbt commands via `dbt.invoke()` within a Python subprocess running a dynamically generated script. While it does not introduce new, direct arbitrary code execution vectors outside of dbt's capabilities, it acts as a command executor for AI agents. The security posture heavily depends on the underlying dbt project's configuration and dependencies. Maliciously crafted dbt inputs (e.g., specific model names, SQL, or Jinja macros) could potentially lead to privilege escalation if dbt itself or its adapters are vulnerable or misconfigured (e.g., by allowing shell command execution within dbt macros). Network requests are made to the Databricks API for warehouse pre-warming if configured, using credentials from the user's `profiles.yml`.
Similar Servers
dbt-mcp
Provides a Model Context Protocol (MCP) server that exposes various dbt-related functionalities (CLI, Semantic Layer, Discovery, Admin API, Code Generation, LSP) as tools for AI agents to interact with dbt projects in Core, Fusion, and Platform environments.
django-ai-boost
Provides Model Context Protocol (MCP) tools for AI assistants to introspect and interact with Django project details and runtime information.
copilot-kit
Provides a curated collection of GitHub Copilot prompts, instructions, and configurations to enhance developer productivity and streamline AI-assisted programming workflows in VS Code.
mssqlMCP
The SQL Server MCP (Model Context Protocol) Server enables AI assistants like GitHub Copilot within Visual Studio Code to interact with SQL Server databases, allowing for SQL query execution, detailed database metadata retrieval, and management of connections and security.