dbt-core-mcp
Verified Safeby iamsocool24
Overview
The dbt Core MCP Server enables interaction with dbt projects, providing tools to query project metadata, run dbt commands, inspect data models, sources, and tests, view compiled SQL, and analyze lineage and impact within a Model Context Protocol (MCP) framework.
Installation
uv run dbt-core-mcpSecurity Notes
The server design generally appears robust. It uses `asyncio.create_subprocess_exec` to run `dbt` commands in the user's environment, constructing the command arguments safely using `json.dumps` to prevent shell injection through user-provided parameters. It employs `yaml.safe_load` for configuration files. The `psutil` library is used for process checking, which is a common and generally safe practice. No hardcoded secrets, obfuscation, or direct use of `eval` or `exec` on untrusted input were identified. The primary security consideration lies in the permissions granted to the `dbt` installation itself and the database credentials configured in `profiles.yml`, which is external to the server's source code and managed by the user. The server will operate with the same privileges as the user's `dbt` environment.
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.
db-mcp-server
Provides AI assistants with structured access to multiple database systems (MySQL, PostgreSQL, SQLite, TimescaleDB) through the Model Context Protocol (MCP).
duckdb_mcp
Integrate SQL databases with AI assistants (e.g., Claude) using the Model Context Protocol (MCP) for data querying, tool execution, and resource management.
dbt-core-mcp
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.