探索
Tommybez Dbt Semantic Layer MCP Server

Tommybez Dbt Semantic Layer MCP Server

该项目是一个dbt语义层的MCP服务器,作为AI助手与dbt语义层之间的桥梁,支持通过自然语言查询指标、探索数据分析和可视化结果。
2分
0
2025-04-29 03:13:34
概述
内容详情
替代品

What is the dbt Semantic Layer MCP Server?

This server acts as a translator between AI assistants and your dbt Semantic Layer, allowing you to ask business questions in plain English and get accurate metric responses.

How does it work?

The server connects to your dbt Cloud account, understands your metric definitions, and converts natural language questions into proper semantic layer queries.

When should I use it?

Perfect for business users who want to access company metrics without writing SQL, or analysts who need quick answers during meetings.

Key Features

Metric ExplorerBrowse and search all available metrics in your dbt project with their business definitions
Natural Language QueriesAsk business questions in everyday language instead of technical syntax
Smart BreakdownsAutomatically applies appropriate dimensional filters and groupings

Pros and Cons

Benefits
No SQL knowledge required to access complex metrics
Consistent metric definitions across all queries
Real-time answers during business discussions
Limitations
Requires dbt Cloud with Semantic Layer enabled
Limited to metrics defined in your dbt project
Initial setup requires API configuration

Getting Started

Install via SmitheryRun the installation command to set up the server
Configure ConnectionProvide your dbt Cloud API credentials and project details
Start QueryingBegin asking questions through your connected AI assistant

Example Queries

Revenue AnalysisCompare revenue performance across time periods
User SegmentationAnalyze user behavior by different segments

Frequently Asked Questions

1
Do I need special permissions in dbt Cloud?Yes, you need API access and Semantic Layer permissions in your dbt Cloud account.
2
Can I use this with other AI tools besides Claude?Yes, the server follows the MCP protocol which works with any compatible AI assistant.
3
How often is the data refreshed?Data freshness depends on your dbt project schedules - the server shows whatever your semantic layer currently contains.

Learn More

dbt Semantic Layer DocumentationOfficial documentation about the dbt Semantic Layer
MCP Protocol OverviewTechnical details about the Model-Connector-Presenter architecture
Smithery PlatformDeployment platform for MCP servers
精选MCP服务推荐
Firecrawl MCP Server
Firecrawl MCP Server是一个集成Firecrawl网页抓取能力的模型上下文协议服务器,提供丰富的网页抓取、搜索和内容提取功能。
TypeScript
2,956
5分
Duckduckgo MCP Server
已认证
DuckDuckGo搜索MCP服务器,为Claude等LLM提供网页搜索和内容抓取服务
Python
212
4.3分
Figma Context MCP
Framelink Figma MCP Server是一个为AI编程工具(如Cursor)提供Figma设计数据访问的服务器,通过简化Figma API响应,帮助AI更准确地实现设计到代码的一键转换。
TypeScript
6,102
4.5分
Edgeone Pages MCP Server
EdgeOne Pages MCP是一个通过MCP协议快速部署HTML内容到EdgeOne Pages并获取公开URL的服务
TypeScript
88
4.8分
Baidu Map
已认证
百度地图MCP Server是国内首个兼容MCP协议的地图服务,提供地理编码、路线规划等10个标准化API接口,支持Python和Typescript快速接入,赋能智能体实现地图相关功能。
Python
323
4.5分
Exa Web Search
已认证
Exa MCP Server是一个为AI助手(如Claude)提供网络搜索功能的服务器,通过Exa AI搜索API实现实时、安全的网络信息获取。
TypeScript
1,429
5分
Minimax MCP Server
MiniMax Model Context Protocol (MCP) 是一个官方服务器,支持与强大的文本转语音、视频/图像生成API交互,适用于多种客户端工具如Claude Desktop、Cursor等。
Python
364
4.8分
Context7
Context7 MCP是一个为AI编程助手提供实时、版本特定文档和代码示例的服务,通过Model Context Protocol直接集成到提示中,解决LLM使用过时信息的问题。
TypeScript
4,853
4.7分
安装
复制以下命令到你的Client进行配置
注意:您的密钥属于敏感信息,请勿与任何人分享。