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, and visualize results within their AI assistant interface.
Last updated: N/A
What is dbt Semantic Layer MCP Server?
A Model-Connector-Presenter (MCP) server that allows you to seamlessly query the dbt Semantic Layer through Claude Desktop and other compatible AI assistants.
How to use dbt Semantic Layer MCP Server?
Install the server via Smithery or manually. Once installed and configured, interact with the dbt Semantic Layer directly from Claude Desktop by asking about available metrics, querying specific metrics, and analyzing trends using natural language.
Key features of dbt Semantic Layer MCP Server
Metric Discovery: Browse and search available metrics in your dbt Semantic Layer
Query Creation: Generate and execute semantic queries through natural language
Data Analysis: Filter, group, and order metrics for deeper insights
Result Visualization: Display query results in an easy-to-understand format
Use cases of dbt Semantic Layer MCP Server
Querying dbt metrics using natural language in Claude
Exploring available metrics and their definitions through an AI assistant
Analyzing data with dimensional breakdowns and filters in Claude
Visualizing query results within an AI assistant interface
FAQ from dbt Semantic Layer MCP Server
What is the dbt Semantic Layer?
What is the dbt Semantic Layer?
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?
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 this server?
How do I install this server?
The easiest way to install is via Smithery using the provided command.
What kind of questions can I ask Claude once the server is set up?
What kind of questions can I ask Claude once the server is set up?
You can ask about available metrics, query specific metrics, and analyze trends.
What should I do if I encounter issues?
What should I do if I encounter issues?
Verify your API credentials, ensure your dbt Cloud project has Semantic Layer enabled, and check that your metrics are properly defined in your dbt project.