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.

dbt Cloud logodbt 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
Try asking
TOOLS

Supported Tools

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

Admin API Delete

Delete dbt Cloud administrative resources or configuration using one predeclared v2 or v3 Admin API operation identified by provider operation ID.

Admin API Read

Perform one predeclared dbt Cloud Admin read selected by provider operation ID, using its path and optional query parameters.

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

List dimensions, entities, group-bys, or queryable time granularities in the Semantic Layer.

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

1

Install Composio

typescript
npm install @composio/core ai @ai-sdk/mcp @ai-sdk/openai
Install the Composio SDK and your agent framework
2

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
3

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

1

Install Composio

typescript
npm install @composio/core @composio/openai openai
Install the Composio SDK, the OpenAI provider, and the OpenAI SDK
2

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
3

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

Rolling this out across your team?

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

EXPLORE MCP GATEWAY
FAQ

Frequently asked questions

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