DBT CLI MCP Server

Example Use Cases

• 1

  Run dbt commands (run, test, compile) within a specific dbt project programmatically via MCP tools.

• 2

  List and inspect dbt resources (models, seeds, sources) and retrieve results or metadata in JSON-friendly formats.

• 3

  Manage dbt environment configuration, profiles directory, and dependencies when orchestrating CI or data workflows.

Description

This project exposes the dbt CLI through a Model Context Protocol (MCP) server so agents can execute dbt operations (run, test, compile, ls, etc.) programmatically. It provides a set of MCP tools, a CLI for direct use, environment variable management, and configuration options for dbt executable and profiles location. The server enforces absolute project paths and helps ensure dbt locates the correct profiles.yml, simplifying automation for AI-driven workflows. Integration tests and an included test project submodule (jaffle_shop_duckdb) help validate functionality against real dbt projects.