Skip to main content
Feedback

DBT MCP connector

DBT is a transformation workflow tool that enables analytics engineers to version control, test, and document data models in SQL. The DBT MCP connector allows AI agents to create new projects, manage data transformation workflows, and configure model dependencies. It also supports running transformations, reviewing test results, and collaborating on analytics code across your data warehouse environment.

Authentication type

  • API Key - Requires a static API key to be configured before the agent can connect to the service.

Uses

Use the DBT MCP connector to perform the following actions:

  • Build automated data transformation pipelines that execute on schedule without manual intervention
  • Document data lineage and dependencies to understand how metrics flow through your warehouse
  • Validate data quality rules before loading transformed results into production systems
  • Accelerate analytics by organizing raw data into clean, modeled tables ready for reporting
  • Standardize business logic across teams so all departments use consistent customer and product definitions
  • Test data transformations in development before deploying to production warehouses
  • Monitor transformation job performance and identify bottlenecks in your data pipeline

Example prompts

Use the following example prompts to invoke DBT MCP connector tools from your AI assistant or Boomi Connect workflow:

  • Create a new DBT project for our customer analytics team.
  • Set up a DBT project to transform our raw sales data into reporting tables.
  • Start a DBT project for modeling our product inventory data.
  • Create a DBT project structure for our financial data transformation.
  • Initialize a new DBT project to consolidate data from multiple sources.
  • Set up a DBT project for our marketing attribution modeling.
  • Create a DBT project to build our data mart for business intelligence.
  • Start a new DBT project for real-time customer event transformations.
  • Set up DBT to transform and validate our subscription billing data.

DBT MCP connector tools

The DBT MCP connector provides the following tools. Each tool maps to a specific action you can invoke from your AI agent or automation.

ToolDescription
dbt_dbtcreateproject_invokeInitializes a new dbt project with default structure and configuration files.
On this Page