dbt Semantic Layer MCP Server

What is dbt Semantic Layer MCP Server?

An MCP (Model Context Protocol) server that bridges AI assistants like Claude Desktop with the dbt Semantic Layer. It allows users to query business metrics defined in dbt using natural language, enabling metric discovery, data analysis, and result visualization.

How to use dbt Semantic Layer MCP Server?

Install via Smithery (npx -y @smithery/cli install @TommyBez/dbt-semantic-layer-mcp --client claude), then configure it with your dbt Cloud API credentials. Once set up, ask natural language questions about metrics directly 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 insights
• Display query results in an easy-to-understand format

Use cases of dbt Semantic Layer MCP Server

• Ask "What metrics are available in my dbt Semantic Layer?" to discover defined metrics
• Query specific metrics like "Show me monthly revenue for the last quarter grouped by product category"
• Analyze trends with questions such as "What's the week-over-week growth in user signups?"

FAQ from dbt Semantic Layer MCP Server

What do I need to use this server?

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

How do I install the server?

The recommended method is via Smithery: npx -y @smithery/cli install @TommyBez/dbt-semantic-layer-mcp --client claude.

What can I do if queries fail?

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