MCP cover image
TommyBez_dbt-semantic-layer-mcp-server logo
Public

TommyBez_dbt-semantic-layer-mcp-server

See in Github
2025-03-03

Mirror ofhttps://github.com/TommyBez/dbt-semantic-layer-mcp-server

0

Github Watches

1

Github Forks

0

Github Stars

dbt Semantic Layer MCP Server

smithery badge

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:

  1. Ask about available metrics: "What metrics are available in my dbt Semantic Layer?"
  2. Query specific metrics: "Show me monthly revenue for the last quarter grouped by product category"
  3. 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

  • dbt Labs for creating the dbt Semantic Layer
  • Smithery for the MCP deployment platform
  • LiteMCP for the MCP development package

相关推荐

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

  • https://suefel.com
  • Latest advice and best practices for custom GPT development.

  • Bora Yalcin
  • Evaluator for marketplace product descriptions, checks for relevancy and keyword stuffing.

  • Yusuf Emre Yeşilyurt
  • I find academic articles and books for research and literature reviews.

  • https://maiplestudio.com
  • Find Exhibitors, Speakers and more

  • Carlos Ferrin
  • Encuentra películas y series en plataformas de streaming.

  • Joshua Armstrong
  • Confidential guide on numerology and astrology, based of GG33 Public information

  • Contraband Interactive
  • Emulating Dr. Jordan B. Peterson's style in providing life advice and insights.

  • rustassistant.com
  • 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.

  • Elijah Ng Shi Yi
  • Advanced software engineer GPT that excels through nailing the basics.

  • Emmet Halm
  • Converts Figma frames into front-end code for various mobile frameworks.

  • apappascs
  • 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.

  • ShrimpingIt
  • Micropython I2C-based manipulation of the MCP series GPIO expander, derived from Adafruit_MCP230xx

  • modelcontextprotocol
  • Model Context Protocol Servers

  • Mintplex-Labs
  • The all-in-one Desktop & Docker AI application with built-in RAG, AI agents, No-code agent builder, MCP compatibility, and more.

  • huahuayu
  • A unified API gateway for integrating multiple etherscan-like blockchain explorer APIs with Model Context Protocol (MCP) support for AI assistants.

    Reviews

    1 (1)
    Avatar
    user_G0fkHBOh
    2025-04-15

    I've been using test-mcp-server for a while now, and it has significantly improved my workflow! The server is incredibly reliable and fast, making it perfect for my needs. The creator, dudeinthemirror, has done a fantastic job with this product. I highly recommend checking it out at https://mcp.so/server/test-mcp-server/dudeinthemirror.