MCP.so
Sign In

dbt Semantic Layer MCP Server

@MCP-Mirror

Basic information

Category

Memory & Knowledge

License

MIT license

Transports

stdio

Author

MCP-Mirror

About dbt Semantic Layer MCP Server

Mirror of

dbt Semantic Layer MCP Server config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "TommyBez_dbt-semantic-layer-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli",
        "install",
        "@TommyBez/dbt-semantic-layer-mcp",
        "--client",
        "claude"
      ]
    }
  }
}

dbt Semantic Layer MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

Fetch the live tool list by running this server in a temporary sandbox using the button above.

Overview

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?"

Frequently asked questions

1

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.

2

How do I install the server?

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

3

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.

Comments

More Memory & Knowledge MCP servers