dbt-doctor

概述

dbt-doctor是一个专门的MCP服务器，旨在通过AI辅助的质量控制和治理增强dbt项目管理。它提供关于dbt项目健康状况的深度上下文，允许用户与AI助手交互，执行任务如审计覆盖率、分析数据模型、检测模式漂移和自动生成文档。该服务器作为官方dbt-labs/dbt-mcp的补充，专注于分析而非命令执行。 该服务器架构包含一个只读分析层，将AI助手与dbt项目和数据仓库连接，并配备一个安全生成工具包，可将更改无缝合并到现有的YAML模式中。它通过只读SQL执行、严格的SQL验证、无状态连接和文档生成前的预览机制来强调安全性，确保用户完全控制其dbt配置。

试试问 AI

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

• list_models

  Overview of all models and their coverage status

  试试:What models are in my dbt project?试试:Show me all models with low coverage
• get_model_details

  Detailed model information including SQL, columns, lineage, and tests

  试试:Show me details for the fct_orders model试试:What tests are defined for the stg_customers model?
• audit_project

  Project health score and naming convention violations

  试试:What's the health score of my dbt project?试试:Find any naming convention violations
• check_test_coverage

  Models ranked by their test coverage percentage

  试试:Which models have the lowest test coverage?试试:List all models with 0% coverage
• analyze_dag

  Detection of orphan models and high fan-out nodes

  试试:Are there any orphan models in my project?试试:Find models with high fan-out
• get_project_health

  Single-call dashboard summarizing project status

  试试:Give me a complete health report for my project试试:Show me project health dashboard
• profile_model

  Batched column statistics for a model

  试试:Profile the fct_orders model试试:Get column statistics for stg_customers
• execute_query

  Read-only SQL execution against your warehouse

  试试:Count total orders in the last month试试:Show top 10 customers by revenue
• detect_schema_drift

  Comparison of database columns against manifest definitions

  试试:Check for schema drift in my models试试:Find any columns not in manifest.json
• suggest_tests

  Translation of profile data into dbt test recommendations

  试试:Suggest tests for the fct_orders model试试:What tests should I add based on profiling?
• update_model_yaml

  Safe merging of documentation and tests to schema.yml

  试试:Update schema.yml with new tests试试:Add documentation to the stg_customers model
• generate_model_docs

  Complete end-to-end documentation workflow

  试试:Generate documentation for all models试试:Auto-document models with low coverage

可对比工具

安装

pip install dbt-doctor

{
  "mcpServers": {
    "dbt-doctor": {
      "command": "dbt-doctor",
      "args": ["--project-dir", "/absolute/path/to/your/dbt/project"]
    }
  }
}

{
  "mcpServers": {
    "dbt-doctor": {
      "command": "dbt-doctor",
      "args": ["--project-dir", "/absolute/path/to/your/dbt/project"]
    }
  }
}

dbt-doctor 对比