dbt Semantic Layer MCP Server Featured
A server that enables querying the dbt Semantic Layer through natural language conversations with Claude Desktop and other AI assistants, allowing users to discover metrics, create queries, analyze data, and visualize results.
TommyBez
README
dbt Semantic Layer MCP Server
A Model-Connector-Presenter (MCP) server for seamlessly querying the dbt Semantic Layer through Claude Desktop and other compatible AI assistants.
What is the dbt Semantic Layer?
The dbt Semantic Layer is a powerful feature that allows you to define metrics once in your dbt project and reuse them consistently across your entire data stack. It provides:
- A single source of truth for business metrics
- Consistent metric definitions across all data tools
- Simplified access to complex metrics for all team members
About This Project
This MCP server acts as a bridge between AI assistants (like Claude) and the dbt Semantic Layer, enabling you to:
- Query metrics directly through natural language conversations
- Explore available metrics and their definitions
- Analyze data with dimensional breakdowns and filters
- Visualize results within your AI assistant interface
Features
- 🔍 Metric Discovery: Browse and search available metrics in your dbt Semantic Layer
- 📊 Query Creation: Generate and execute semantic queries through natural language
- 🧮 Data Analysis: Filter, group, and order metrics for deeper insights
- 📈 Result Visualization: Display query results in an easy-to-understand format
Prerequisites
- A dbt Cloud account with Semantic Layer enabled
- API access to your dbt Cloud instance
- Node.js (v14 or later)
Installation
Via Smithery (Recommended)
The easiest way to install is via Smithery:
npx -y @smithery/cli install @TommyBez/dbt-semantic-layer-mcp --client claude
Usage
Once installed and configured, you can interact with the dbt Semantic Layer directly from Claude Desktop:
- Ask about available metrics: "What metrics are available in my dbt Semantic Layer?"
- Query specific metrics: "Show me monthly revenue for the last quarter grouped by product category"
- Analyze trends: "What's the week-over-week growth in user signups?"
Troubleshooting
If you encounter issues:
- Verify your API credentials are correct
- Ensure your dbt Cloud project has Semantic Layer enabled
- Check that your metrics are properly defined in your dbt project
Contributing
Contributions are welcome! Please feel free to submit a Pull Request.
License
This project is licensed under the MIT License - see the LICENSE file for details.
Acknowledgments
Recommended Servers
Audiense Insights MCP Server
Enables interaction with Audiense Insights accounts via the Model Context Protocol, facilitating the extraction and analysis of marketing insights and audience data including demographics, behavior, and influencer engagement.
graphlit-mcp-server
The Model Context Protocol (MCP) Server enables integration between MCP clients and the Graphlit service. Ingest anything from Slack to Gmail to podcast feeds, in addition to web crawling, into a Graphlit project - and then retrieve relevant contents from the MCP client.
Kagi MCP Server
An MCP server that integrates Kagi search capabilities with Claude AI, enabling Claude to perform real-time web searches when answering questions that require up-to-date information.
Exa Search
A Model Context Protocol (MCP) server lets AI assistants like Claude use the Exa AI Search API for web searches. This setup allows AI models to get real-time web information in a safe and controlled way.
Playwright MCP Server
Provides a server utilizing Model Context Protocol to enable human-like browser automation with Playwright, allowing control over browser actions such as navigation, element interaction, and scrolling.
Apple MCP Server
Enables interaction with Apple apps like Messages, Notes, and Contacts through the MCP protocol to send messages, search, and open app content using natural language.
contentful-mcp
Update, create, delete content, content-models and assets in your Contentful Space
Supabase MCP Server
A Model Context Protocol (MCP) server that provides programmatic access to the Supabase Management API. This server allows AI models and other clients to manage Supabase projects and organizations through a standardized interface.
serper-search-scrape-mcp-server
This Serper MCP Server supports search and webpage scraping, and all the most recent parameters introduced by the Serper API, like location.
The Verge News MCP Server
Provides tools to fetch and search news from The Verge's RSS feed, allowing users to get today's news, retrieve random articles from the past week, and search for specific keywords in recent Verge content.