dbt-mcp

dbt-mcp

3.6

If you are the rightful owner of dbt-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.

The dbt MCP Server provides tools to interact with dbt, enabling users to manage and execute dbt projects through a Model Context Protocol server.

The dbt MCP Server is a robust tool designed to facilitate interaction with dbt projects through a Model Context Protocol (MCP) server. It allows users to execute dbt commands, manage dbt projects, and interact with dbt's Semantic Layer and Discovery API. The server is highly configurable, supporting various environment variables to tailor its functionality to specific needs. It integrates seamlessly with different platforms, including Claude Desktop, Cursor, and VS Code, providing a versatile solution for developers working with dbt. The server supports a range of dbt CLI commands, enabling users to build, compile, and test dbt models, as well as generate documentation and execute SQL queries. Additionally, it offers tools for interacting with dbt's Semantic Layer and Discovery API, allowing users to retrieve metrics, dimensions, and model details. The server is designed to be secure and efficient, with options to enable or disable specific tools and features based on user requirements.

Features

  • Supports a wide range of dbt CLI commands for project management and execution.
  • Integrates with dbt's Semantic Layer and Discovery API for advanced data interactions.
  • Configurable environment variables for tailored server functionality.
  • Compatible with multiple platforms including Claude Desktop, Cursor, and VS Code.
  • Secure execution of SQL queries with support for Semantic Layer SQL syntax.