dbt Semantic Layer MCP Server

@TommyBez

代码仓库

基本信息

分类

记忆与知识

许可证

MIT

传输方式

stdio

作者

TommyBez

关于 dbt Semantic Layer MCP Server

MCP Server for querying DBT Semantic Layer

#dbt #semantic-layer #mcp-server

dbt Semantic Layer MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "dbt-semantic-layer-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli",
        "install",
        "@TommyBez/dbt-semantic-layer-mcp",
        "--client",
        "claude"
      ]
    }
  }
}

dbt Semantic Layer MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

What is dbt Semantic Layer MCP Server?

The dbt Semantic Layer MCP Server is a Model Context Protocol server that enables querying the dbt Semantic Layer through AI assistants like Claude Desktop. It acts as a bridge to explore, query, and visualize dbt metrics using natural language, providing a single source of truth for business metrics.

How to use dbt Semantic Layer MCP Server?

Install via Smithery (recommended) using the command npx -y @smithery/cli install @TommyBez/dbt-semantic-layer-mcp --client claude. You need a dbt Cloud account with Semantic Layer enabled and API access, plus Node.js v14 or later. After configuration, ask natural language questions about metrics from Claude Desktop.

Key features of dbt Semantic Layer MCP Server

Browse and search available metrics in your dbt Semantic Layer
Generate and execute semantic queries through natural language
Filter, group, and order metrics for deeper analysis
Display query results in an easy-to-understand format
Work with any compatible AI assistant interface

Use cases of dbt Semantic Layer MCP Server

Ask "What metrics are available in my dbt Semantic Layer?" to discover metrics
Query monthly revenue for the last quarter grouped by product category
Analyze week-over-week growth in user signups with natural language
Explore metric definitions with dimensional breakdowns and filters

常见问题

What prerequisites are needed to use this server?

You need a dbt Cloud account with Semantic Layer enabled, API access to your dbt Cloud instance, and Node.js v14 or later.

How do I install the dbt Semantic Layer MCP Server?

The recommended installation method is via Smithery using the command `npx -y @smithery/cli install @TommyBez/dbt-semantic-layer-mcp --client claude`.

How can I troubleshoot issues with queries?

Verify that your API credentials are correct, ensure your dbt Cloud project has Semantic Layer enabled, and check that your metrics are properly defined in your dbt project.

Can I use this server with AI assistants other than Claude Desktop?

Yes, the server is described as compatible with Claude Desktop and other compatible AI assistants.

What types of queries can I make with natural language?

You can ask about available metrics, query specific metrics with filters and groupings (e.g., time periods, product categories), and analyze trends like week-over-week growth.