dbt-cli-mcp

dbt-cli-mcp

3.4

If you are the rightful owner of dbt-cli-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

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.

The DBT CLI MCP Server is a specialized server that integrates the dbt Command Line Interface (CLI) with the Model Context Protocol (MCP). This server allows AI coding agents to execute dbt commands and manage dbt projects efficiently. It supports all major dbt operations such as running models, testing, compiling, and more. The server is designed to facilitate seamless interaction with dbt projects by providing a command-line interface and environment variable management. It also allows for configurable paths to the dbt executable and profiles.yml location, ensuring flexibility and ease of use. The server is particularly useful for developers and AI agents who need to automate and streamline dbt workflows in a standardized manner.

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

Tools

  1. dbt_run

    Run the dbt model

  2. dbt_test

    Run dbt test

  3. dbt_ls

    List dbt resources

  4. dbt_compile

    Compile the dbt model

  5. dbt_debug

    Debugging dbt project settings

  6. dbt_deps

    Install dbt package dependencies

  7. dbt_seed

    Loading CSV files as seed data

  8. dbt_show

    Preview model results