I craft unique cereal names, stories, and ridiculously cute Cereal Baby images.

dbt-semantic-layer-mcp-server
MCP Server for querying DBT Semantic Layer
1
Github Watches
1
Github Forks
8
Github Stars
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
相关推荐
Evaluator for marketplace product descriptions, checks for relevancy and keyword stuffing.
I find academic articles and books for research and literature reviews.
This GPT assists in finding a top-rated business CPA - local or virtual. We account for their qualifications, experience, testimonials and reviews. Business operators provide a short description of your business, services wanted, and city or state.
Confidential guide on numerology and astrology, based of GG33 Public information
Emulating Dr. Jordan B. Peterson's style in providing life advice and insights.
Your go-to expert in the Rust ecosystem, specializing in precise code interpretation, up-to-date crate version checking, and in-depth source code analysis. I offer accurate, context-aware insights for all your Rust programming questions.
Advanced software engineer GPT that excels through nailing the basics.
Converts Figma frames into front-end code for various mobile frameworks.
Discover the most comprehensive and up-to-date collection of MCP servers in the market. This repository serves as a centralized hub, offering an extensive catalog of open-source and proprietary MCP servers, complete with features, documentation links, and contributors.
Micropython I2C-based manipulation of the MCP series GPIO expander, derived from Adafruit_MCP230xx
The all-in-one Desktop & Docker AI application with built-in RAG, AI agents, No-code agent builder, MCP compatibility, and more.
Mirror ofhttps://github.com/agentience/practices_mcp_server
A unified API gateway for integrating multiple etherscan-like blockchain explorer APIs with Model Context Protocol (MCP) support for AI assistants.
Reviews

user_tNP2RwlK
As a dedicated user of the dbt-semantic-layer-mcp-server by TommyBez, I am thoroughly impressed with its capabilities. This server seamlessly integrates with dbt to provide a powerful and efficient semantic layer, making data transformation and analytics a breeze. The clear documentation and robust performance make it a standout tool in the data engineering toolkit. Highly recommend!