dbt-docs-mcp

[](https://mseep.ai/app/ad4aaf73-63ce-42e0-b27c-8541ae1fbab8)

[](https://archestra.ai/mcp-catalog/mattijsdp__dbt-docs-mcp)

Model Context Protocol (MCP) server for interacting with dbt project metadata, including dbt Docs artifacts (manifest.json, catalog.json). This server exposes dbt graph information and allows querying node details, model/column lineage, and related metadata.

This server provides tools to:

• Search dbt Nodes:
• Find nodes (models, sources, tests, etc.) by name (search_dbt_node_names).
• Locate nodes based on column names (search_dbt_column_names).
• Search within the compiled SQL code of nodes (search_dbt_sql_code).
• Inspect Nodes:
• Retrieve detailed attributes for any given node unique ID (get_dbt_node_attributes).
• Explore Lineage:
• Find direct upstream dependencies (predecessors) of a node (get_dbt_predecessors).
• Find direct downstream dependents (successors) of a node (get_dbt_successors).
• Column-Level Lineage:
• Trace all upstream sources for a specific column in a model (get_column_ancestors).
• Trace all downstream dependents of a specific column in a model (get_column_descendants).
• Suggested extensions:
• Tool that allows executing SQL queries.
• Tool that retrieves table/view/column metadata directly from the database.
• Tool to search knowledge-base.

1. Prerequisites: Ensure you have Python installed and uv
2. Clone the repo:

    git clone <repository-url>
    cd dbt-docs-mcp

1. Optional: parse dbt manifest for column-level lineage:

• Setup the required Python environment, e.g.:

    uv sync

• Use the provided script `scripts/