dbt Semantic Layer MCP ServerServer

TommyBez
GitHub
data analyticsAI integrationdbt

Loading subscription status...

💡 Description

An MCP server that seamlessly queries the dbt semantic layer through Claude Desktop and other compatible AI assistants, allowing users to discover metrics, create queries, analyze data, and visualize results.

📝 JSON Entries

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

🛠️ Tools

Claude DesktopSmithery

Features

  • Metric discovery
  • Semantic query generation
  • Data analysis with dimensional breakdowns
  • Result visualization

💬 Example Queries

  • What metrics are available in my dbt semantic layer?
  • Show me the monthly revenue for the last quarter grouped by product category.
  • What is the weekly growth in user sign-ups?