dbt Docs | AI Builder Hub Review & Alternatives | Flaex AI

VERIFIED

dbt Docs

Safety: 75/100

0.0(0)

Exposes dbt project metadata (manifest, catalog) via MCP, enabling search, lineage exploration, and node inspection for dbt projects.

MCP ServersData & DatabasesSearch & WebDevelopmentAI & LLMSocial MediaUtilitiesFreemium

Boost this tool

Subscribe to listing upgrades or segmented pushes.

Overview

Exposes dbt project metadata (manifest, catalog) via MCP, enabling search, lineage exploration, and node inspection for dbt projects.

This server is relatively safe for read-only access to dbt metadata. The primary risk lies in the exposure of sensitive information within the dbt project itself. Ensure the MANIFEST_PATH is secured and dbt project descriptions are sanitized.

Performance depends on the size of the dbt project and the complexity of the queries. Column-level lineage can be computationally intensive.

The primary cost is the computational resources required to run the server. There are no external API costs.

Python22 starsMITReleased 4/8/2025CI/CD

Connections & Capabilities

Connects To

GitHubTwitter

Capabilities

Read

Client Compatibility

Claude Desktop

full

Cursor

full

Windsurf

untested

VS Code (Copilot)

untested

Quickstart

Claude Desktop Config

{
    "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"
        }
        }
    }
}

Tools (8)

safe

search_dbt_node_names

Finds dbt nodes by name.

Read-only search operation.

safe

search_dbt_column_names

Locates dbt nodes based on column names.

Read-only search operation.

safe

search_dbt_sql_code

Searches within the compiled SQL code of dbt nodes.

Read-only search operation.

safe

get_dbt_node_attributes

Retrieves detailed attributes for a given dbt node ID.

Read-only retrieval of node attributes.

safe

get_dbt_predecessors

Finds direct upstream dependencies of a dbt node.

Read-only lineage exploration.

safe

get_dbt_successors

Finds direct downstream dependents of a dbt node.

Read-only lineage exploration.

safe

get_column_ancestors

Traces all upstream sources for a specific column in a model.

Read-only column-level lineage tracing.

safe

get_column_descendants

Traces all downstream dependents of a specific column in a model.

Read-only column-level lineage tracing.

Security

Auth Method

Environment Variable

Known Risks

!Exposure of sensitive data within dbt project metadata.
!Dependency on potentially vulnerable external libraries.
!Lack of granular access control beyond file system permissions.
!Potential for denial-of-service attacks if the server is overwhelmed with requests.

Safety Score

low risk

Positive

+Primarily read-only access to dbt metadata.
+No direct database access or modification capabilities.
+Limited execution capabilities, focused on metadata retrieval.
+Relies on pre-generated dbt artifacts (manifest.json, catalog.json).

Risks

-Exposure of dbt project metadata if MANIFEST_PATH is not properly secured.
-Potential for information leakage if sensitive data is included in dbt descriptions or tags.
-Dependency on external libraries (networkx, rapidfuzz, dbt-core) which could introduce vulnerabilities.
-Lack of built-in authentication mechanisms beyond environment variables.

Use Cases

Data Governance

-Understanding data lineage for compliance purposes
-Identifying the impact of changes to dbt models
-Auditing data transformations within the dbt project

Data Engineering

-Debugging dbt model dependencies
-Optimizing dbt model performance by identifying bottlenecks
-Discovering and reusing existing dbt models

Data Science

-Understanding the source of data used in machine learning models
-Validating data transformations performed by dbt
-Discovering relevant data features for model training

Who Is This For?

Best For

Data engineers seeking to understand dbt project dependencies
Data governance teams requiring data lineage information
Data scientists exploring data transformations within dbt
Analytics engineers debugging dbt models

Not Ideal For

Environments requiring real-time data lineage updates
Projects with extremely large and complex dbt graphs
Use cases requiring direct database interaction or modification

Autonomy & Execution

Default ModeRead-only

Sandboxed

The server operates in a read-only mode, limiting the risk of unintended modifications. Autonomy is limited to the scope of metadata exploration.

StatelessYes

Retry LogicNot documented

ConcurrencySingle-threaded

Production Tip

Monitor the server's resource usage and ensure the dbt manifest and catalog files are regularly updated.

FAQ

What dbt artifacts are required to run this server?

The server requires `manifest.json` and `catalog.json` generated by dbt.

How do I update the dbt metadata used by the server?

You need to re-run `dbt docs generate` to update the `manifest.json` and `catalog.json` files, and then restart the server.

Does this server support authentication?

Currently, authentication is limited to securing the file system where the manifest and catalog files are stored. No built-in authentication.

Can I use this server to execute dbt commands?

No, this server is read-only and only provides access to dbt metadata.

How do I configure the server?

Configuration is primarily done through environment variables, such as `MANIFEST_PATH`, `SCHEMA_MAPPING_PATH`, and `MANIFEST_CL_PATH`.

What is the purpose of the `schema_mapping.json` and `manifest_column_lineage.json` files?

These files are used to enable column-level lineage and are generated using the provided `create_manifest_cl.py` script.

Is it possible to extend this server with custom functionality?

Yes, the server can be extended by modifying the `mcp_server.py` file and adding new MCP tools.

Key Features

Data & Databases Search & Web Development AI & LLM Social Media Utilities

Metrics

Discovered2/14/2026

Reviews0

Saved By0 users

dbt Docs

Overview

Connections & Capabilities

Connects To

Capabilities

Client Compatibility

Quickstart

Claude Desktop Config

Tools (8)

Security

Safety Score

Positive

Risks

Use Cases

Data Governance

Data Engineering

Data Science

Who Is This For?

Best For

Not Ideal For

Autonomy & Execution

FAQ

What dbt artifacts are required to run this server?

How do I update the dbt metadata used by the server?

Does this server support authentication?

Can I use this server to execute dbt commands?

How do I configure the server?

What is the purpose of the `schema_mapping.json` and `manifest_column_lineage.json` files?

Is it possible to extend this server with custom functionality?

Key Features

Metrics

Related Tools