dbt Cloud MCP server for AI agents and assistants

Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with dbt Cloud MCP or direct API to inspect projects, discover metadata, monitor job runs, and query governed data through natural language.

Get started for free Get a demo

dbt Cloud

Bearer TokenOauth2

dbt Cloud is a platform for managing analytics projects and governed data products. It provides administrative APIs, metadata discovery, and Semantic Layer access.

20 Tools

Try dbt Cloud now

Type what you want done — sign in and watch it run live in the Tool Router playground.

TOOL ROUTER PLAYGROUND

dbt Cloud

Enter ↵

Try asking

TOOLS

Supported Tools

Every dbt Cloud action and event your agent gets out of the box.

Admin API Delete

Irreversibly delete one selected dbt Cloud administrative resource using a fixed documented Admin API operation from the official v2 or v3 OpenAPI specification.

Admin API Read

Perform one documented dbt Cloud Admin read selected by operation, using its documented path and optional query parameters from the official v2 and v3 OpenAPI specifications.

Admin API Write

Execute one predeclared dbt Cloud Administrative API POST, PATCH, or PUT operation.

Cancel Run

Irreversibly request cancellation of a queued, starting, or running dbt Cloud run.

Download Run Artifact

Download one artifact file from a completed dbt Cloud run using a path returned by List Run Artifacts.

Find Semantic Saved Queries

List or search saved Semantic Layer queries, or return one exact saved query by name.

Get Job

Return one dbt Cloud job definition and optionally selected related execution context.

Get Run

Return one dbt Cloud run with optional job, environment, step, retry, audit, or log context.

Get Run Failure Details

Return dbt Cloud status and step logs for a failed run.

List Environments

Return one page of environments for a dbt Cloud project, with optional deployment and name filters.

List Jobs

Return one page of dbt Cloud jobs, optionally filtered by project, environment, name, schedule, or state.

List Projects

Return one page of dbt Cloud projects, optionally filtered by name, IDs, or deletion state.

List Run Artifacts

Return artifact paths available for a completed dbt Cloud run.

List Runs

Return one page of dbt Cloud runs, optionally filtered by job, project, environment, status, creation time, finish time, or deletion state.

List Semantic Attributes

Return one page of dimensions, entities, group-bys, or queryable time granularities available for selected metrics.

List Semantic Metrics

Return one page of governed Semantic Layer metrics, optionally searched or grouped.

Query Discovery Metadata

List dbt metadata resources in an environment or job-run context, retrieve one node by case-sensitive unique ID, or inspect model health in an environment.

Query Semantic Metrics

Submit an ad-hoc dbt Semantic Layer query using metrics and/or group-bys, or execute a saved query; poll it to a documented terminal state and return one decoded JSON result page.

Retry Run

Start a new retry from a failed dbt Cloud run and return the newly enqueued run record.

Trigger Job Run

Start a new run for a dbt Cloud job, optionally overriding its revision, target, commands, docs generation, threads, or timeout.

SETUP GUIDE

Connect dbt Cloud MCP Tool with your Agent

Install Composio

typescript

npm install @composio/core ai @ai-sdk/mcp @ai-sdk/openai

Install the Composio SDK and your agent framework

Create a session with MCP enabled

typescript

import { Composio } from "@composio/core";

const composio = new Composio();
const { mcp } = await composio.create("your-user-id", {
  toolkits: ["dbt_cloud"],
  mcp: true,
});

Create a session scoped to dbt Cloud and read its MCP URL and headers

Connect your agent to the MCP server

typescript

import { createMCPClient } from "@ai-sdk/mcp";
import { openai } from "@ai-sdk/openai";
import { generateText, stepCountIs } from "ai";

const client = await createMCPClient({
  transport: { type: "http", url: mcp.url, headers: mcp.headers },
});

const { text } = await generateText({
  model: openai("gpt-5.6-sol"),
  tools: await client.tools(),
  prompt: "List my dbt Cloud projects and their environments",
  stopWhen: stepCountIs(10),
});

console.log(text);
await client.close();

Pass the session's MCP URL and headers to your agent and run a dbt Cloud request

SETUP GUIDE

Connect dbt Cloud API Tool with your Agent

Install Composio

typescript

npm install @composio/core @composio/openai openai

Install the Composio SDK, the OpenAI provider, and the OpenAI SDK

Create a Composio session

typescript

import OpenAI from "openai";
import { Composio } from "@composio/core";
import { OpenAIResponsesProvider } from "@composio/openai";

const composio = new Composio({ provider: new OpenAIResponsesProvider() });
const client = new OpenAI();

const session = await composio.create("your-user-id", { toolkits: ["dbt_cloud"] });
const tools = await session.tools();

Initialize Composio with the OpenAI Responses provider and create a session scoped to dbt Cloud

Run dbt Cloud tools with your agent

typescript

let response = await client.responses.create({
  model: "gpt-5.6-sol",
  tools,
  input: [{ role: "user", content: "List my dbt Cloud projects and their environments" }],
});

while (response.output.some((o) => o.type === "function_call")) {
  const outputs = await composio.provider.handleToolCalls(session, response.output);
  response = await client.responses.create({
    model: "gpt-5.6-sol",
    tools,
    previous_response_id: response.id,
    input: outputs,
  });
}

console.log(response.output_text);

Send a request, execute the dbt Cloud tool calls through the session, and print the final answer

Why Use Composio?

AI Native dbt Cloud Integration

Supports both dbt Cloud MCP and direct API based integrations
Structured, LLM-friendly schemas for reliable tool execution
Rich coverage for reading, writing, and querying your dbt Cloud data

Managed Auth

Supports bearer token and OAuth authentication for dbt Cloud
Central place to manage, scope, and revoke dbt Cloud access
Per user and per environment credentials instead of hard-coded keys

Agent Optimized Design

Tools are tuned using real error and success rates to improve reliability over time
Comprehensive execution logs so you always know what ran, when, and on whose behalf

Enterprise Grade Security

Fine-grained RBAC so you control which agents and users can access dbt Cloud
Scoped, least privilege access to dbt Cloud resources
Full audit trail of agent actions to support review and compliance

FRAMEWORKS

Use dbt Cloud with any AI Agent Framework

Choose a Framework you want to connect dbt Cloud with

ChatGPT

Use dbt Cloud MCP with ChatGPT

Claude Cowork

Use dbt Cloud MCP with Claude Cowork

Hermes

Use dbt Cloud MCP with Hermes

Atomic Agent

Use dbt Cloud MCP with Atomic Agent

Rolling this out across your team?

Give your team centralized access control across every framework with Composio’s MCP Gateway.

EXPLORE MCP GATEWAY

MORE TOOLKITS

Explore Other Toolkits

Toolkit marketplace

Firecrawl

Api Key

Firecrawl automates large-scale web crawling and data extraction. It helps organizations efficiently gather, index, and analyze content from online sources.

Tavily

Api Key

Tavily offers powerful search and data retrieval from documents, databases, and the web. It helps teams locate and filter information instantly, saving hours on research.

Exa

Api Key

Exa is a data extraction and search platform for gathering and analyzing information from websites, APIs, or databases. It helps teams quickly surface insights and automate data-driven workflows.

Serpapi

Api Key

SerpApi is a real-time API for structured search engine results. It lets you automate SERP data collection, parsing, and analysis for SEO and research.

FAQ

Frequently asked questions

dbt Cloud requires connections to go through your own OAuth app. You register it once with dbt Cloud, add its client ID and secret in the Composio dashboard, and from then on everyone connects by signing in to dbt Cloud as usual. Composio handles the rest of the flow and the token refresh.

Yes! Composio's Tool Router enables agents to use multiple toolkits. Learn more.

Yes. Composio is SOC 2 Type II compliant and is built to keep your dbt Cloud connection and credentials secure. OAuth tokens and API keys are encrypted, and sensitive customer data is protected at rest and in transit.

Composio also undergoes independent security testing and continuously monitors its systems for security threats. You can review the latest reports and policies in the Composio Trust Center.

Composio maintains and updates all toolkit integrations automatically, so your agents always work with the latest API versions.

When you connect a dbt Cloud account through Composio, every action runs under that account, so anything the agent creates, sends, or changes shows up in dbt Cloud as done by you. Keep an approval step in your prompt for actions with side effects, such as sending or deleting, and have the agent draft first.

Exactly the ones dbt Cloud lists on its consent screen when you connect. Review that screen before approving. If you connect a work account, your dbt Cloud administrator may need to approve the app first, and you can revoke the access inside dbt Cloud whenever you want.

Yes. Composio supports multiple connected accounts for the same app, and that works in Claude, ChatGPT, or any other assistant you connect through Composio. Give each dbt Cloud connection a name such as work or personal, and the assistant uses the one you mention in the request. Each account keeps its own credentials and nothing is merged.

Composio refreshes dbt Cloud tokens automatically, so day to day you do nothing. If you revoke access inside dbt Cloud, or dbt Cloud invalidates the session, the connection shows as expired in Composio and the agent stops acting on that account until you reconnect it, which is a single sign-in.

Composio's free Hobby plan includes 100,000 tool calls per month with no credit card, which covers most personal dbt Cloud use. Paid plans add higher limits and team features. Your dbt Cloud plan and its API limits still apply as usual.

Built-in connectors usually give one AI access to a limited set of apps. Many people use Composio because it lets their AI connect to more apps than it normally supports, or connect to multiple accounts for the same app (e.g. connect Claude to multiple dbt Cloud accounts).

With Composio, you connect dbt Cloud once and then use it across different AI assistants without setting it up separately in each one. Connect your apps to Composio once, then connect Composio to whichever AI you use, whether that's Claude, ChatGPT, Hermes, or your own custom assistant.

Start with dbt Cloud.It takes 30 seconds.

Managed auth, hosted MCP servers, and every dbt Cloud tool your agent needs.Free to start.

Start building

dbt Cloud MCP server for AI agents and assistants

Try dbt Cloud now

Supported Tools

Connect dbt Cloud MCP Tool with your Agent

Install Composio

Create a session with MCP enabled

Connect your agent to the MCP server

Connect dbt Cloud API Tool with your Agent

Install Composio

Create a Composio session

Run dbt Cloud tools with your agent

Why Use Composio?

AI Native dbt Cloud Integration

Managed Auth

Agent Optimized Design

Enterprise Grade Security

Use dbt Cloud with any AI Agent Framework

ChatGPT

Claude Cowork

Hermes

Atomic Agent

Rolling this out across your team?

Explore Other Toolkits

Firecrawl

Tavily

Exa

Serpapi

Frequently asked questions

Do I need my own dbt Cloud developer credentials or OAuth app?+

Can I use multiple toolkits together?+

Is Composio secure with my dbt Cloud account?+

What if the API changes?+

Does the agent act as me inside dbt Cloud?+

Which dbt Cloud permissions does Composio get?+

Can I use multiple dbt Cloud accounts with Claude and ChatGPT?+

What happens when my dbt Cloud access expires or I revoke it?+

Does using dbt Cloud through Composio cost extra?+

How is Composio different from the dbt Cloud connectors already built into Claude and ChatGPT?+

Start with dbt Cloud.It takes 30 seconds.