dbt-cli-mcp

dbt-cli-mcp

12
developer_toolsdatabases

The DBT CLI MCP Server is a Model Context Protocol server that facilitates interaction with dbt projects through standardized MCP tools. It allows AI coding agents to execute dbt commands and supports major dbt operations with command-line interface access.

DBT CLI MCP Server

A Model Context Protocol (MCP) server that wraps the dbt CLI tool, enabling AI coding agents to interact with dbt projects through standardized MCP tools.

Features

  • Execute dbt commands through MCP tools
  • Support for all major dbt operations (run, test, compile, etc.)
  • Command-line interface for direct interaction
  • Environment variable management for dbt projects
  • Configurable dbt executable path
  • Flexible profiles.yml location configuration

Installation

  • Requires Python 3.10 or higher and uv tool
  • Requires dbt CLI installed

Usage

Available commands include running dbt models, running tests, listing resources, and more. Absolute project paths are required for operation.

Available Tools

  • dbt_run: Run dbt models
  • dbt_test: Run dbt tests
  • dbt_ls: List dbt resources
  • dbt_compile: Compile dbt models
  • dbt_debug: Debug dbt project setup
  • dbt_deps: Install dbt package dependencies
  • dbt_seed: Load CSV files as seed data
  • dbt_show: Preview model results

Development

Integration tests verify functionality against a real dbt project included as a Git submodule.

License

MIT