dbt Semantic Layer MCP Server
by TommyBez
This MCP server bridges AI assistants like Claude with the dbt Semantic Layer, enabling natural language querying of metrics. It allows users to explore metrics, analyze data with breakdowns, and visualize results within their AI assistant interface.
Last updated: N/A
What is dbt Semantic Layer MCP Server?
This is a Model-Connector-Presenter (MCP) server designed to allow AI assistants like Claude to query the dbt Semantic Layer. It acts as an intermediary, translating natural language queries into requests to the dbt Semantic Layer and presenting the results in a user-friendly format within the AI assistant.
How to use dbt Semantic Layer MCP Server?
Install the server via Smithery using the provided command. Once installed and configured with your dbt Cloud API credentials, you can interact with the dbt Semantic Layer directly from Claude Desktop by asking questions about available metrics, querying specific metrics, and analyzing trends.
Key features of dbt Semantic Layer MCP Server
Metric Discovery
Query Creation
Data Analysis
Result Visualization
Use cases of dbt Semantic Layer MCP Server
Querying dbt metrics using natural language
Exploring available metrics and their definitions
Analyzing data with dimensional breakdowns and filters
Visualizing query results within an AI assistant
Creating consistent metric definitions across data tools
FAQ from dbt Semantic Layer MCP Server
What is the dbt Semantic Layer?
What is the dbt Semantic Layer?
The dbt Semantic Layer is a feature that allows you to define metrics once in your dbt project and reuse them consistently across your entire data stack.
What are the prerequisites for using this server?
What are the prerequisites for using this server?
You need 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 this server?
How do I install this server?
The recommended way is to install it via Smithery using the provided npx command.
What kind of questions can I ask Claude after installing this server?
What kind of questions can I ask Claude after installing this server?
You can ask about available metrics, query specific metrics with filters and groupings, and analyze trends over time.
What do I do if I encounter issues?
What do I do if I encounter issues?
Verify your API credentials, ensure the Semantic Layer is enabled in your dbt Cloud project, and check that your metrics are properly defined in your dbt project.