dbt-docs-mcp

dbt-docs-mcp

3.4

If you are the rightful owner of dbt-docs-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

Model Context Protocol (MCP) server for interacting with dbt project metadata, including dbt Docs artifacts.

The dbt-docs-mcp server is designed to facilitate interaction with dbt project metadata by exposing dbt graph information. It allows users to query node details, model/column lineage, and related metadata. This server is particularly useful for those who need to search, inspect, and explore dbt nodes and their relationships within a project. By leveraging dbt Docs artifacts like `manifest.json` and `catalog.json`, the server provides a comprehensive view of the dbt project's structure and dependencies. It supports various functionalities such as searching for nodes by name or column, inspecting node attributes, and exploring both model and column-level lineage. Additionally, the server can be extended with tools for executing SQL queries and retrieving metadata directly from the database.

Features

  • Search dbt Nodes: Find nodes by name, column names, or within compiled SQL code.
  • Inspect Nodes: Retrieve detailed attributes for any given node unique ID.
  • Explore Lineage: Find direct upstream dependencies and downstream dependents of a node.
  • Column-Level Lineage: Trace all upstream sources and downstream dependents for a specific column in a model.
  • Suggested Extensions: Tools for executing SQL queries and retrieving metadata directly from the database.