Empower AI agents to understand and interact with your dbt projects.
Visit WebsiteFreeVisit Website
TL;DR - dbt MCP Server
- Provides AI agents with context for dbt Core, Fusion, and Platform projects.
- Enables natural language interaction and SQL generation for dbt.
- Offers access to dbt Semantic Layer, Discovery API, and CLI commands.
Pricing: Free forever
Best for: Individuals & startups
Pros & Cons
Pros
- Facilitates AI-driven automation and interaction with dbt projects
- Provides a unified interface for accessing dbt metadata and executing commands
- Supports dbt Core, dbt Fusion, and dbt Platform environments
- Enhances developer productivity through intelligent assistance and automation
- Offers detailed insights into dbt project structure, lineage, and health
Cons
- Utilizing dbt CLI commands through the MCP server requires trust in the client due to potential data model modifications
- The search functionality is currently in an alpha stage, indicating potential instability or limited features
- Requires understanding of the Model Context Protocol (MCP) for effective integration with AI agents
Preview
Key Features
Generate SQL from natural language using project contextExecute SQL on dbt Platform infrastructure with Semantic Layer supportRetrieve dimensions, entities, and metrics from the dbt Semantic LayerList and query dbt metrics with filtering and grouping optionsAccess dbt Discovery API for macros, models, sources, and exposuresGet detailed information on dbt models, including compiled SQL and schemaRetrieve full lineage graphs (ancestors and descendants) for dbt resourcesExecute dbt CLI commands like build, compile, run, and test
Pricing Plans
Open Source
Free
- Full source code access
- Community support
- Self-hosted
What is dbt MCP Server?
dbt MCP Server is a Model Context Protocol (MCP) server designed to provide AI agents with comprehensive context about your dbt Core, dbt Fusion, and dbt Platform projects. It acts as an intermediary, allowing AI agents to query and interact with various aspects of your dbt environment, including SQL execution, Semantic Layer data, and dbt project metadata. This enables AI agents to generate SQL from natural language, retrieve model details, understand data lineage, and even execute dbt CLI commands.
The server is ideal for organizations looking to integrate AI-driven insights and automation into their data transformation workflows. It facilitates advanced analytics, automated documentation, and intelligent data governance by exposing dbt project information in a structured, accessible way for AI consumption. This enhances developer productivity and allows for more sophisticated interactions with complex data models.
Reviews
Be the first to review dbt MCP Server
Your take helps the next buyer. Verified LinkedIn reviewers get a badge.
Write a reviewBest dbt MCP Server Alternatives
Top alternatives based on features, pricing, and user needs.
ComposioFreemium
Empower your AI agents with real-world skills and seamless integrations across 10,000+ tools.
AWS MCP ServersFree
Connect AI applications to AWS for enhanced cloud-native development and management.
Grafana MCP ServerFree
Connect AI agents to your Grafana instance for intelligent monitoring and interaction.
Neon MCP ServerFree
Neon MCP Server
Mendable AIFreemium
Train a secure AI on your technical resources to answer customer and employee questions.
Explore More
dbt MCP Server FAQ
How does the dbt MCP Server integrate with different dbt environments like dbt Core, dbt Fusion, and dbt Platform?
The dbt MCP Server is designed to provide AI agents with context across dbt Core, dbt Fusion, and dbt Platform. It acts as a universal interface, abstracting the underlying dbt environment to present a consistent model context to AI agents, regardless of where your dbt project resides.
What specific capabilities does the dbt MCP Server offer for interacting with the dbt Semantic Layer?
The dbt MCP Server provides several tools for the dbt Semantic Layer, including
get_dimensions, get_entities, list_metrics, query_metrics for executing metric queries with filtering and grouping, and get_metrics_compiled_sql to retrieve compiled SQL for metrics without execution.What are the security implications of allowing AI agents to utilize dbt CLI commands through the MCP tooling?
Allowing AI agents to utilize dbt CLI commands through the MCP tooling carries significant security implications, as these commands can modify data models, sources, and warehouse objects. It is crucial to proceed only if you fully trust the client and understand the potential impact of such modifications on your data infrastructure.
Can the dbt MCP Server help in understanding the lineage and dependencies within a dbt project?
Yes, the dbt MCP Server offers robust lineage capabilities. It can
get_lineage to retrieve the full lineage graph (ancestors and descendants) with type and depth filtering, and also provides get_lineage_dev for retrieving lineage from a local manifest.json file.How does the experimental MCP Bundle (dbt-mcp.mcpb) simplify the setup process for MCPB-aware clients?
The experimental MCP Bundle (dbt-mcp.mcpb) is published with each release to allow MCPB-aware clients to import the server without additional setup. Clients can download the bundle from the latest release assets and use Anthropic's mcpb CLI documentation to install or inspect it, streamlining the integration process.
Source: github.com