MCP.so
Sign In

🛠️ dbt MCP Server

@kannandreams

Repository

About 🛠️ dbt MCP Server

dbt-mcp-server

Basic information

Category

Data & Analytics

Runtime

python

Transports

stdio

Publisher

kannandreams

Config

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

{
  "mcpServers": {
    "dbt-mcp-server": {
      "command": "docker",
      "args": [
        "build",
        "-t",
        "dbt-mcp-server",
        "."
      ]
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is dbt MCP Server?

The dbt MCP Server is a minimal, extensible MCP (Model Context Protocol) server that provides a unified JSON-based interface for running dbt models, tests, and other dbt operations. It can be triggered via CLI, HTTP API, or an AI interface like Claude, and includes Slack notifications for task completions.

How to use dbt MCP Server?

Run the server locally with uvicorn mcp_dispatcher:app --reload --port 8000 or use Docker with docker build -t dbt-mcp-server . then docker run -p 8000:8000 dbt-mcp-server. Trigger dbt models by executing python mcp_dispatcher.py mcp_request.json with a JSON spec. Integrate with Claude via python claude_client_example.py. Set the SLACK_WEBHOOK_URL environment variable to receive Slack alerts.

Key features of dbt MCP Server

  • Run dbt models using a clean JSON spec
  • Accept CLI or HTTP API calls
  • Slack alerts for model success or failure
  • Compatible with AI tools like Claude
  • Extensible and minimal design
  • Unified interface for triggering dbt operations

Use cases of dbt MCP Server

  • Automate dbt model runs by chatting with Claude
  • Trigger dbt tests and models via a REST API
  • Receive immediate Slack notifications on model completion or errors
  • Integrate dbt into AI-driven data pipelines

FAQ from dbt MCP Server

What does this server do compared to other dbt tools?

It provides a minimal, extensible MCP interface to trigger dbt models and tests using a unified JSON spec, making it easy to integrate with AI assistants like Claude.

What are the runtime requirements?

You need Python with uvicorn to run locally, or Docker for containerized deployment. The server runs on port 8000.

How do I get Slack alerts?

Set the SLACK_WEBHOOK_URL environment variable to your Slack webhook URL. Alerts are sent on model success or failure.

How can I use this with Claude?

Run the provided claude_client_example.py script after starting the server. This allows Claude to trigger dbt operations via the MCP interface.

What license does this server use?

It is licensed under the MIT License, allowing free use, modification, and distribution.

Comments

More Data & Analytics MCP servers

ArXiv MCP Server

blazickjp

A Model Context Protocol server for searching and analyzing arXiv papers

2.9K

Google Analytics MCP Server

surendranb

Google Analytics 4 data to AI agents, agentic workflows, and MCP clients. Give agents analysis-ready access to website traffic, user behavior, and performance data with schema discovery, server-side aggregation, and safe defaults that reduce data wrangling.

225

HubSpot MCP Server

peakmojo

A Model Context Protocol (MCP) server that enables AI assistants to interact with HubSpot CRM data, providing built-in vector storage and caching mechanisms help overcome HubSpot API limitations while improving response times.

128

🎓 Semantic Scholar MCP Server

JackKuo666

🔍 This project implements a Model Context Protocol (MCP) server for interacting with the Semantic Scholar API. It provides tools for searching papers, retrieving paper and author details, and fetching citations and references.

75

dbt MCP Server

dbt-labs

A MCP (Model Context Protocol) server for interacting with dbt.

587