dbt Semantic Layer MCP Server
dbt语义层MCP服务器
模型连接器演示器 (MCP) 服务器,用于通过 Claude Desktop 和其他兼容的 AI 助手无缝查询 dbt 语义层。
什么是 dbt 语义层?
dbt 语义层是一项强大的功能,它允许您在 dbt 项目中定义一次指标,并在整个数据堆栈中一致地重复使用它们。它提供:
业务指标的单一事实来源
所有数据工具的指标定义一致
简化所有团队成员对复杂指标的访问
Related MCP server: MCP Iceberg Catalog
关于此项目
该 MCP 服务器充当 AI 助手(如 Claude)和 dbt 语义层之间的桥梁,使您能够:
通过自然语言对话直接查询指标
探索可用的指标及其定义
使用维度细分和过滤器分析数据
在您的 AI 助手界面中可视化结果
特征
🔍指标发现:浏览并搜索 dbt 语义层中的可用指标
📊查询创建:通过自然语言生成并执行语义查询
🧮数据分析:过滤、分组和排序指标以获得更深入的洞察
📈结果可视化:以易于理解的格式显示查询结果
先决条件
启用语义层的 dbt Cloud 帐户
通过 API 访问您的 dbt Cloud 实例
Node.js(v14 或更高版本)
安装
通过 Smithery(推荐)
最简单的安装方法是通过Smithery :
npx -y @smithery/cli install @TommyBez/dbt-semantic-layer-mcp --client claude用法
安装并配置完成后,您可以直接从 Claude Desktop 与 dbt 语义层进行交互:
询问可用指标:“我的 dbt 语义层中有哪些可用指标?”
查询特定指标:“显示按产品类别分组的上一季度月收入”
分析趋势:“用户注册量每周增长多少?”
故障排除
如果您遇到问题:
验证您的 API 凭证是否正确
确保您的 dbt Cloud 项目已启用语义层
检查您的 dbt 项目中的指标是否正确定义
贡献
欢迎贡献代码!欢迎提交 Pull 请求。
执照
该项目根据 MIT 许可证获得许可 - 有关详细信息,请参阅 LICENSE 文件。
致谢
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections. Dates show when Glama detected each change.
No tool schema history has been recorded yet.
This server cannot be installed
Maintenance
Related MCP Connectors
Ask data questions in natural language. Get SQL, insights, and charts from your databases.
The Ramp MCP server enables users to securely connect Ramp with AI assistants like ChatGPT and Claude to query financial data and take actions using natural language. It transforms Ramp's developer API into a SQL interface that LLMs can query, allowing admins to analyze spend trends, identify cost savings, and run complex SQL analyses on comprehensive datasets (transactions, purchase orders, vendors, users), while all users can manage cards, view transactions, request reimbursements, and get expense policy answers.
The grounded data layer for any LLM: governed SQL, metrics, lineage and catalog over your data.
Query your warehouse or a CSV with Claude/ChatGPT over MCP, governed by table-level ACL + audit.
Related MCP Servers
- FlicenseNot gradedqualityCmaintenanceA server that enables interaction with PostgreSQL, MySQL, MariaDB, or SQLite databases through Claude Desktop using natural language queries.1-
- FlicenseBqualityDmaintenanceA Model Context Protocol server that provides a SQL interface for querying and managing Apache Iceberg tables through Claude desktop, allowing natural language interaction with Iceberg data lakes.18-
- AlicenseBqualityDmaintenanceA server that enables LLMs like Claude to query AWS DynamoDB databases through natural language requests, supporting table management, data querying, and schema analysis.7152MIT
- AlicenseNot gradedqualityDmaintenanceA server that integrates Confluence with Claude Desktop and other AI assistants, enabling natural language interactions with your Confluence documentation.4684MIT
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/TommyBez/dbt-semantic-layer-mcp-server'
If you have feedback or need assistance with the MCP directory API, please join our Discord server