DBT MCP connector
Updated
DBT is the modern standard for data transformation, giving teams a consistent way to build and manage analytics workflows. The DBT MCP connector allows AI agents to create new projects, establishing the foundation for organizing and running transformation work. It also supports broader project management tasks as part of a data transformation workflow within a Boomi tenant.
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:
- Kickstart new data transformation projects in DBT instantly
- Standardize project setup across analytics teams
- Accelerate onboarding for new data initiatives
- Reduce manual setup time when launching data pipelines
- Enforce consistent project structure across workflows
- Launch analytics projects without switching tools
- Automate repetitive project creation tasks in DBT
- Streamline collaboration between data engineers and analysts
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 called Sales Analytics.Set up a fresh DBT project for our marketing team.Start a new data transformation project in DBT for Q3 reporting.Spin up a DBT project named Customer Insights.I need a new DBT project for the finance data pipeline.Create a DBT project to organize our warehouse transformations.Set up a new project in DBT for the product analytics team.Begin a new DBT project for tracking supply chain metrics.Create a DBT project titled Revenue Forecasting.Can you start a new DBT project for our inventory 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.
| Tool | Description |
|---|---|
| dbt_dbtcreateproject_invoke | Create a new project in DBT |
