dbt Semantic Layer MCP Server

@MCP-Mirror

About dbt Semantic Layer MCP Server

Mirror of

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"
      ]
    }
  }
}

Tools

No tools detected

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

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.

Frequently asked questions

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.

Comments

Basic information

More Memory & Knowledge MCP servers

Ultimate Google Docs & Drive MCP Server

a-bonus

The Ultimate Google Docs, Sheets, Drive, Gmail, & Google Calendar MCP Server. This MCP (primarily for use in Claude Desktop) gains full access to your google suite and lets claude do its thing.

605

Context Portal MCP (ConPort)

GreatScottyMac

Context Portal (ConPort): A memory bank MCP server building a project-specific knowledge graph to supercharge AI assistants. Enables powerful Retrieval Augmented Generation (RAG) for context-aware development in your IDE.

763

Agimem

Persistent memory for AI agents. Hosted MCP server with capsule-scoped key/value storage, tags, TTL expiration, bulk ops, and RBAC.

MCP server for Obsidian

MarkusPfundstein

MCP server that interacts with Obsidian via the Obsidian rest API community plugin

4.0K

RAG Documentation MCP Server

hannesrudolph

An MCP server implementation that provides tools for retrieving and processing documentation through vector search, enabling AI assistants to augment their responses with relevant documentation context.

267