dbt-mcp
The dbt-mcp provides a Model Context Protocol server that facilitates interaction with dbt models, including executing, profiling, and managing models, metadata retrieval, and integration with tools like IDEs and data platforms.
Added on:
Created by:
Apr 27 2025
The dbt-mcp provides a Model Context Protocol server that facilitates interaction with dbt models, including executing, profiling, and managing models, metadata retrieval, and integration with tools like IDEs and data platforms.
Added on:
Created by:
Apr 27 2025
dbt Labs
Featured
What is dbt-mcp?
This MCP (Model Context Protocol) server for dbt enables advanced management and interaction with dbt data models. It offers features such as executing models, generating documentation, retrieving model details, and integrating with various data tools. Its architecture supports automation and programmatic control over dbt projects, making it ideal for data engineers, analysts, and Plattform integrations seeking streamlined model management and data pipeline orchestration. Users can deploy and connect to the server via CLI, IDE, or cloud configurations, facilitating scalable and collaborative data operations.
Who will use dbt-mcp?
- Data Engineers
- Data Analysts
- Platform Integrators
- Data Engineering Teams
- Data Platform Developers
How to use the dbt-mcp?
- Step1: Install the MCP server using the provided install script.
- Step2: Configure the server by setting environment variables for dbt host, token, and environment ID.
- Step3: Connect your MCP client (e.g., VS Code, Cursor, Claude Desktop) to the server using the configuration instructions.
- Step4: Use the MCP client or API to run dbt commands, retrieve model details, or manage your dbt models.
- Step5: Monitor and manage the server via command palette or configuration files to start, stop, or adjust the server as needed.
dbt-mcp's Core Features & Benefits
The Core Features
- Execute dbt models and commands
- Retrieve model metadata and details
- Generate dbt documentation
- Query and list dbt models and metrics
- Integrate with IDEs and cloud platforms
The Benefits
- Streamlines management of dbt models
- Enables programmatic control over data pipelines
- Supports automation and integration with various tools
- Facilitates collaboration across data teams
- Provides a scalable solution for model metadata management
dbt-mcp's Main Use Cases & Applications
- Automated execution and testing of dbt models in CI/CD pipelines
- Metadata management and documentation generation for data models
- Integration with IDEs for real-time model interaction and debugging
- Data pipeline orchestration and monitoring
- Platform integration for managing multiple dbt environments
FAQs of dbt-mcp
Developer
You may also like:
Developer Tools
A desktop application for managing server and client interactions with comprehensive functionalities.
A Model Context Protocol server for Eagle that manages data exchange between Eagle app and data sources.
A chat-based client that integrates and uses various MCP tools directly within a chat environment for enhanced productivity.
A Docker image hosting multiple MCP servers accessible through a unified entry point with supergateway integration.
Provides access to YNAB account balances, transactions, and transaction creation through MCP protocol.
A fast, scalable MCP server for managing real-time multi-client Zerodha trading operations.
A remote SSH client facilitating secure, proxy-based access to MCP servers for remote tool utilization.
A Spring-based MCP server integrating AI capabilities for managing and processing Minecraft mod communication protocols.
A minimalistic MCP client with essential chat features, supporting multiple models and contextual interactions.
A secure MCP server enabling AI agents to interact with Authenticator App for 2FA codes and passwords.
Research And Data
A server implementation supporting Model Context Protocol, integrating CRIC's industrial AI capabilities.
Provides real-time traffic, air quality, weather, and bike-sharing data for Valencia city in a unified platform.
A React application demonstrating integration with Supabase via MCP tools and Tambo for UI component registration.
A MCP client integrating Brave Search API for web searches, utilizing MCP protocol for efficient communication.
A protocol server enabling seamless communication between Umbraco CMS and external applications.
NOL integrates LangChain and Open Router to create a multi-client MCP server using Next.js
Connects LLMs to Firebolt Data Warehouse for autonomous querying, data access, and insight generation.
A client framework for connecting AI agents to MCP servers, enabling tool discovery and integration.
Spring Link facilitates linking and managing multiple Spring Boot applications efficiently within a unified environment.
An open-source client to interact with multiple MCP servers, enabling seamless tool access for Claude.
Cloud Platforms
A Spring-based chatbot for Cloud Foundry that integrates with AI services, MCP, and memGPT for advanced capabilities.
Automates MCP server creation for AWS services using boto3, simplifying server setup for development.
A serverless MCP hosted in AWS Lambda that interacts with AWS Bedrock for AI model processing via API Gateway.
A server-client MCP facilitating communication and data exchange between AI services and storage systems.
Enables interaction with SharePoint Online via REST API, supporting site, list, and user management functions.
A comprehensive suite of containers for efficient microservices deployment and management.
A client and server setup facilitating GitLab SSE communication via a supergateway for real-time updates.
A cross-platform package manager designed to manage all MCP servers efficiently and seamlessly.
A demo project showing how to build an MCP client agent to connect to external services via MCP protocol.
Implements an MCP server and client using FastMCP and LangChain for structured asynchronous communication.