The dbt Semantic Layer MCP Server is an MCP (Model-Context-Presenter) server. It lets you query your dbt Semantic Layer directly through AI assistants such as Claude Desktop using natural language.
To use it, install the server via Smithery with the command npx -y @smithery/cli install @TommyBez/dbt-semantic-layer-mcp --client claude. You must configure it with your dbt Cloud account, which needs to have the Semantic Layer and API access enabled.
Its key features include browsing available metrics, creating and running semantic queries through natural language, performing analysis with filters and groupings, and visualizing the query results clearly.
Common use cases are querying business metrics in plain English, analyzing data trends with dimensional breakdowns, and viewing results inside your AI assistant interface to support decision-making.
You can ask the server about the metrics you have available, request specific metric queries, and ask for trend analysis, all using natural language prompts.