SIGN UPLOG IN
X (Twitter)LinkedInGitHubDiscordYouTube

How to connect dbt Cloud to Claude

Connect Claude Web, Desktop and Cowork to dbt Cloud MCP. List dbt cloud projects and environments, query governed data through dbt semantic layer, and more using natural language, with authentication handled for you.

Get started for freeGet a demo
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

Introduction

Claude is Anthropic's AI assistant, available on the web, in the desktop app, and on mobile. Cowork is its agent for knowledge work, and it runs on all of those surfaces too. Connected to your apps, Claude can work with your files and services to accomplish complex tasks on your behalf.

This guide walks you through the easiest and most secure way to connect your dbt Cloud account to Claude via Composio Connect, enabling it to list dbt Cloud projects and environments, query governed data through dbt Semantic Layer, review recent dbt Cloud job runs, and more such actions on your behalf without compromising your account security.

Setup is the same on Claude Web, Desktop, and Cowork, and you only need to do it once. The connector is tied to your account, so it's available in all three.

Also integrate dbt Cloud with

ChatGPTHermesAtomic Agent

Connecting dbt Cloud to Claude Web, Desktop, and Cowork

Two ways to add the Composio connector. Pick whichever you prefer.

1. Add with one click

Click the button. Claude opens with the Composio connector filled in. Click Add, then go to step 2.

Add to Claude

Add manually

In Claude Desktop, click Customize in the left sidebar, then select Connectors and click the + icon at the top.

Claude Desktop connectors screen with Add custom connector selected

Click Add custom connector and paste in the Composio MCP server URL:

bash
https://connect.composio.dev/mcp
Add custom connector dialog with Composio MCP server URL

2. Authorize in your browser

Click Connect. You'll be redirected to a browser window where you can authorize Composio to continue.

Composio authorization screen for Claude Web, Desktop, and Cowork

3. Connect your dbt Cloud account

Back in Claude, ask it to connect to dbt Cloud or give it any dbt Cloud-related task.

For example, ask Claude to:

  • "List dbt Cloud projects and environments"
  • "Query governed data through dbt Semantic Layer"
  • "Review recent dbt Cloud job runs"

It will prompt you to authenticate and authorize access.

That's it. Composio's tools are now available in Claude, and your dbt Cloud account is ready to use.

What is the dbt Cloud Claude Connector, and what's possible with it?

The dbt Cloud MCP server is an implementation of the Model Context Protocol that connects your AI agent and assistants like Claude, Cursor, etc directly to your dbt Cloud account. It provides structured and secure access to your dbt Cloud projects, jobs, runs, environments, metadata, artifacts, and Semantic Layer data, so your agent can monitor analytics work, start or manage runs, investigate failures, and query governed metrics on your behalf.

  • Project and job operations: Have your agent list dbt Cloud projects and environments, inspect job settings, start job runs, cancel active runs, or retry failed runs.
  • Run monitoring and troubleshooting: Let the agent find runs by job, project, environment, status, or time, inspect run details, and retrieve failure information and step logs.
  • Artifact and metadata discovery: Direct your agent to list available run artifacts, download selected artifact files, explore metadata, retrieve specific resources, and inspect model health.
  • Semantic Layer exploration: Instruct your agent to find governed metrics and saved queries, list available dimensions and entities, and query semantic metrics for analysis.
  • Administrative resource management: Have your agent read, create, update, or delete supported dbt Cloud administrative resources through documented operations.

Troubleshooting

1. Why does Claude not use the Composio connector for dbt Cloud?

The connector can show as connected, but Claude must use it in each dbt Cloud conversation.

  • Click + at the lower left of the chat, or type /.
  • Hover Connectors.
  • Turn on Composio.
  • Ask Claude to connect to dbt Cloud again.

2. Why does Claude show an MCP server error before dbt Cloud connects?

Claude can show Couldn't reach the MCP server or Authorization with the MCP server failed when you add the connector for dbt Cloud.

  • Check that the connector URL is https://connect.composio.dev/mcp.
  • Connectors run from Anthropic's cloud, so your device network is usually not the problem.
  • Add the connector again from Customize > Connectors, then ask Claude to connect dbt Cloud.
  • If it fails again, send the error and the ofid_ reference id to support@composio.dev.

3. Why does the dbt Cloud authorization link not work?

The Composio connector is one server. Your dbt Cloud account connects separately when Claude asks for it.

  • If the browser does not open, or the link expires, ask Claude to retry the dbt Cloud connection.
  • Composio creates a fresh dbt Cloud authorization link.
  • Open that link in your browser and finish the dbt Cloud sign-in.

4. Why do dbt Cloud actions fail after they worked before?

The dbt Cloud connection can expire or lose permission.

  • Ask Claude to inspect the dbt Cloud connection.
  • If the connection is unhealthy, disconnect it when Claude prompts you.
  • Reconnect the dbt Cloud account and retry the action.
  • If Claude shows a permission prompt, approve it before Claude changes data in dbt Cloud.
  • If the action still fails with a permission error, check that the connected account has that permission in dbt Cloud itself.

5. How do I switch to a different dbt Cloud account?

Claude can manage the dbt Cloud connection for you.

  • Ask Claude to disconnect or delete the current dbt Cloud account.
  • Ask Claude to connect dbt Cloud again.
  • Open the new Composio authorization link for dbt Cloud.
  • Sign in with the other dbt Cloud account in the browser.
  • After the account connects, ask Claude to retry the dbt Cloud task.

6. Why is my dbt Cloud connection missing in Claude Desktop or on a Team plan?

The connector belongs to your Claude account, so your dbt Cloud connection works in Claude Web, Desktop, and Cowork.

  • In Claude Desktop, open Customize > Connectors.
  • Next to Composio, click ⋮ and click Clear cache.
  • If dbt Cloud tools still do not appear, click ⋮, disconnect, remove the connector, and add it again.
  • On Team or Enterprise, an Owner or Primary Owner must enable the connector before you can connect dbt Cloud.
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.

FRAMEWORKS

How to build dbt Cloud MCP Agent with another framework

ChatGPT logo

ChatGPT

Use dbt Cloud MCP with ChatGPT

Hermes logo

Hermes

Use dbt Cloud MCP with Hermes

Atomic Agent logo

Atomic Agent

Use dbt Cloud MCP with Atomic Agent

FAQ

Frequently asked questions

With a standalone dbt Cloud MCP server, the agents and LLMs can only access a fixed set of dbt Cloud tools tied to that server. However, with the Composio Tool Router, agents can dynamically load tools from dbt Cloud and many other apps based on the task at hand, all through a single MCP endpoint.

Yes, you can. Claude Cowork fully supports MCP integration. You get structured tool calling, message history handling, and model orchestration while Tool Router takes care of discovering and serving the right dbt Cloud tools.

Yes, absolutely. You can configure which dbt Cloud scopes and actions are allowed when connecting your account to Composio. You can also bring your own OAuth credentials or API configuration so you keep full control over what the agent can do.

All sensitive data such as tokens, keys, and configuration is fully encrypted at rest and in transit. Composio is SOC 2 Type 2 compliant and follows strict security practices so your dbt Cloud data and credentials are handled as safely as possible.

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