dbt-docs

by mattijsdp

23 stars

215 downloads

Not rated

GitHub

About

MCP server for dbt-core (OSS) users as the official dbt MCP only supports dbt Cloud. Supports project metadata, model and column-level lineage and dbt documentation.

Details

Author: mattijsdp
GitHub stars: 23
Downloads: 215
Categories: Database, Community, Other, Knowledge Base

- Search nodes by name, column name, or compiled SQL.
- Retrieve detailed attributes of any node by unique ID.
- Find direct upstream predecessors of a node.
- Find direct downstream successors of a node.
- Trace column-level ancestors and descendants.
- Supports extensions for SQL execution and database metadata.

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

Download and install Highlight from highlightai.com/download
Navigate to the plugins tab and select "Add Custom Plugin"
Configure the plugin with the settings below

Plugin Name dbt-docs

Command (node, npx, python, etc.)

Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
Enable "Start Automatically" if you want the plugin to start when Highlight launches

Setting up with Cursor

Open Cursor's settings
Navigate to the MCP section
Click "Add new Global MCP server"
Copy and paste the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "dbt-docs": {
            "dbt-docs-mcp": {
                "command": "uv",
                "args": [
                    "sync"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "dbt-docs": {
            "dbt-docs-mcp": {
                "command": "uv",
                "args": [
                    "sync"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "dbt-docs": {
            "dbt-docs-mcp": {
                "command": "uv",
                "args": [
                    "sync"
                ]
            }
        }
    }
}

Setting up with Claude Desktop

Open Claude Desktop's settings
Go to the Integrations tab
Click "Add MCP Server"
Use the configuration below based on your operating system

Note: Make sure Claude Desktop is running before attempting to connect.

JSON

{
    "mcpServers": {
        "dbt-docs": {
            "dbt-docs-mcp": {
                "command": "uv",
                "args": [
                    "sync"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "dbt-docs": {
            "dbt-docs-mcp": {
                "command": "uv",
                "args": [
                    "sync"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "dbt-docs": {
            "dbt-docs-mcp": {
                "command": "uv",
                "args": [
                    "sync"
                ]
            }
        }
    }
}

Setting up with Windsurf

Open Windsurf's preferences
Go to the Integrations section
Click "Add MCP Integration"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "dbt-docs": {
            "dbt-docs-mcp": {
                "command": "uv",
                "args": [
                    "sync"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "dbt-docs": {
            "dbt-docs-mcp": {
                "command": "uv",
                "args": [
                    "sync"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "dbt-docs": {
            "dbt-docs-mcp": {
                "command": "uv",
                "args": [
                    "sync"
                ]
            }
        }
    }
}

Setting up with Cline

Open Cline's settings
Navigate to the Integrations section
Click "Add MCP Server"
Copy and paste the configuration below based on your operating system

Note: Make sure to restart Cline after adding the configuration.

JSON

{
    "mcpServers": {
        "dbt-docs": {
            "dbt-docs-mcp": {
                "command": "uv",
                "args": [
                    "sync"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "dbt-docs": {
            "dbt-docs-mcp": {
                "command": "uv",
                "args": [
                    "sync"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "dbt-docs": {
            "dbt-docs-mcp": {
                "command": "uv",
                "args": [
                    "sync"
                ]
            }
        }
    }
}

Setting up with Goose

Open Goose's preferences
Go to the Integrations tab
Select "MCP Servers"
Click "Add New Server"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "dbt-docs": {
            "dbt-docs-mcp": {
                "command": "uv",
                "args": [
                    "sync"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "dbt-docs": {
            "dbt-docs-mcp": {
                "command": "uv",
                "args": [
                    "sync"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "dbt-docs": {
            "dbt-docs-mcp": {
                "command": "uv",
                "args": [
                    "sync"
                ]
            }
        }
    }
}

From the repository

Requires Python and uv. Clone the repo, optionally run the provided script to generate column-level lineage data, then start the server with uv run … mcp run … and set the environment variables MANIFEST_PATH, SCHEMA_MAPPING_PATH, and MANIFEST_CL_PATH. Configuration is typically placed in an MCP client’s mcp.json.

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

{
    "mcpServers": {
        "dbt-docs": {
            "dbt-docs-mcp": {
                "command": "uv",
                "args": [
                    "sync"
                ]
            }
        }
    }
}

McpServers

{
    "dbt-docs-mcp": {
        "command": "uv",
        "args": [
            "sync"
        ]
    }
}

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.

Key Functionality

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.

Getting Started

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

    git clone <repository-url>

    cd dbt-docs-mcp

3. Optional: parse dbt manifest for column-level lineage:
- Setup the required Python environment, e.g.:

    uv sync

- Use the provided script scripts/create_manifest_cl.py and simply provide the path to your dbt manifest, dbt catalog and the desired output paths for your schema and column lineage file:

    python scripts/create_manifest_cl.py --manifest-path PATH_TO_YOUR_MANIFEST_FILE --catalog-path PATH_TO_YOUR_CATALOG_FILE --schema-mapping-path DESIRED_OUTPUT_PATH_FOR_SCHEMA_MAPPING --manifest-cl-path DESIRED_OUTPUT_PATH_FOR_MANIFEST_CL

- Depending on your dbt project size, creating column-lineage can take a while (hours)
4. Run the Server:
- If your desired MCP client (Claude desktop, Cursor, etc.) supports mcp.json it would look as below:

    {

        "mcpServers": {

            "DBT Docs MCP": {

            "command": "uv",

            "args": [

                "run",

                "--with",

                "networkx,mcp[cli],rapidfuzz,dbt-core,python-decouple,sqlglot,tqdm",

                "mcp",

                "run",

                "/Users/mattijs/repos/dbt-docs-mcp/src/mcp_server.py"

            ],

            "env": {

                "MANIFEST_PATH": "/Users/mattijs/repos/dbt-docs-mcp/inputs/manifest.json",

                "SCHEMA_MAPPING_PATH": "/Users/mattijs/repos/dbt-docs-mcp/outputs/schema_mapping.json",

                "MANIFEST_CL_PATH": "/Users/mattijs/repos/dbt-docs-mcp/outputs/manifest_column_lineage.json"

            }

            }

        }

    }

No reviews yet — be the first

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.

dbt-docs

About

Details

Jump to

Setting up with Highlight

Setting up with Cursor

JSON

JSON

JSON

Setting up with Claude Desktop

JSON

JSON

JSON

Setting up with Windsurf

JSON

JSON

JSON

Setting up with Cline

JSON

JSON

JSON

Setting up with Goose

JSON

JSON

JSON

From the repository

Claude Desktop / Cursor

McpServers

dbt-docs-mcp

Key Functionality

Getting Started

Install

About

Details

Jump to

Setting up with Highlight

From the repository

Claude Desktop / Cursor

McpServers

dbt-docs-mcp

Key Functionality

Getting Started

Install

More like this

Sequential Thinking

Redis

Filesystem

EverArt

Google Drive

Sqlite