dbt-mcp

概述

dbt MCP 服务器是 dbt Labs 开发的一个生产就绪的 MCP 服务器实现，使 AI 代理能够通过模型上下文协议与 dbt 项目交互。它在多个类别中提供广泛的功能，包括 SQL 执行、语义层操作、dbt CLI 命令和文档管理。该服务器提供模型发现、血统分析、指标查询甚至代码生成工具，使数据团队能够通过 AI 增强其 dbt 工作流程。

试试问 AI

装完之后，这里有 5 个你可以让 AI 做的事：

• execute_sql

  Executes SQL on dbt Platform infrastructure with Semantic Layer support.

  试试:Run a SQL query to see top 10 customers by revenue试试:Execute a SQL query against the production database
• text_to_sql

  Generates SQL from natural language using project context.

  试试:Convert 'show me monthly sales for each product' to SQL试试:Generate SQL for total revenue by region
• query_metrics

  Executes metric queries with filtering and grouping options.

  试试:Query monthly revenue metrics试试:Get metrics filtered by product category
• get_model_details

  Gets model details including compiled SQL, columns, and schema.

  试试:Show details for the customers model试试:Get information about the orders model
• get_lineage

  Gets full lineage graph with type and depth filtering.

  试试:Show the lineage for the revenue model试试:Get upstream and downstream dependencies
• run

  Executes models to materialize them in the database.

  试试:Run all models in the project试试:Execute the staging models
• generate_model_yaml

  Generates model YAML with columns, option to inherit upstream descriptions.

  试试:Generate YAML for a new customer model试试:Create model YAML with columns from upstream
• fusion.compile_sql

  Compiles SQL in project context via dbt Platform.

  试试:Compile this SQL with dbt context: SELECT * FROM customers试试:Help me understand what this SQL would compile to
• search_product_docs

  Searches docs.getdbt.com for pages matching a query.

  试试:Find documentation about incremental models试试:Search for information on dbt tests
• get_job_details

  Gets job configuration including triggers, schedule, and dbt commands.

  试试:Show details for the nightly job试试:Get configuration for the weekly refresh
• list_metrics

  Retrieves all defined metrics.

  试试:Show all metrics in the project试试:List all revenue-related metrics
• get_model_health

  Gets health signals: run status, test results, and upstream source freshness.

  试试:Check the health status of the customers model试试:Show test results and freshness for all models

可对比工具

安装

{
  "mcpServers": {
    "dbt": {
      "command": "npx",
      "args": ["@dbt-labs/dbt-mcp"],
      "env": {
        "DBT_PROJECT_DIR": "/path/to/your/dbt/project"
      }
    }
  }
}

npm install -g @modelcontextprotocol/mcpb
mcpb install https://github.com/dbt-labs/dbt-mcp/releases/download/vX.X.X/dbt-mcp.mcpb

FAQ

dbt MCP 服务器是什么？

dbt MCP 服务器是一种模型上下文协议实现，为 AI 代理提供与 dbt 项目交互的工具，包括 SQL 执行、语义层操作和 dbt CLI 命令。

此服务器支持哪些 dbt 产品？

该服务器支持 dbt Core、dbt Fusion 和 dbt Platform，根据您的特定 dbt 设置和访问级别，提供不同的功能。

Hacker News 讨论

开发者社区最近的相关讨论。

• MCP Server for Working with Dbt▲ 1
  帖子 by duck · 2025-04-21

dbt-mcp 对比