SIGN UPLOG IN
X (Twitter)LinkedInGitHubDiscordYouTube

How to integrate dbt Cloud MCP with Atomic Agent

Connect Atomic Agent 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

Atomic Agent is an open-source AI agent that runs on your machine and supports local models through llama.cpp. Connect it to 1,500+ apps through Composio, including dbt Cloud.

This guide uses Atomic Agent's built-in Composio integration. You need Atomic Agent v0.5.6 or later, your own Composio API key, and a dbt Cloud account. See the Atomic Agent documentation for installation instructions.

Also integrate dbt Cloud with

ChatGPTClaude CoworkHermes

How Atomic Agent connects to dbt Cloud

Atomic Agent connects to Composio's Tool Router over Streamable HTTP MCP. It discovers the tools needed for your request, and Composio handles account authentication.

Execution and account-connection tools follow Atomic Agent's configured approval policy. Review any approval prompt before allowing an action on your connected account.

Connect dbt Cloud to Atomic Agent

  1. Sign up or sign in to the Composio dashboard. Copy your API key.
  2. In Atomic Agent, open the Integrations tab and select Composio. Select API key, press e, paste the key, and press Enter. The tools become available immediately, without a restart.
  3. Ask Atomic Agent to do something in dbt Cloud. It searches Composio for the right tool.
  4. On first use, open the sign-in link returned in the chat. Connect your dbt Cloud account, then return to Atomic Agent to continue.

Headless setup

Add the following line to ~/.atomic-agent/.env, replacing YOUR_COMPOSIO_API_KEY with your key. Start Atomic Agent after saving the file.

bash
COMPOSIO_API_KEY=YOUR_COMPOSIO_API_KEY

What is the dbt Cloud MCP server, 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.

Use dbt Cloud from Atomic Agent

With your account connected, ask Atomic Agent to work with dbt Cloud in natural language. You can connect more apps through the same Composio integration as you need them.

Visit the Atomic Agent website or inspect the Atomic Agent source code.

Troubleshooting

Why is my API key rejected?

Copy the key directly from the Composio dashboard. Atomic Agent requires ASCII characters because it sends the key in an HTTP header. Remove any extra characters introduced when copying.

Why are Composio tools unavailable after saving a key?

Check that you use Atomic Agent v0.5.6 or later and that Composio is enabled in your configuration. A "composio": { "enabled": false } setting disables the integration while keeping the saved key on disk.

Does Composio have a free plan?

The Hobby plan includes 100,000 tool calls per month. Composio-managed OAuth apps have a lower included allowance. See Composio pricing for the current limits that apply to your connection.

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

Claude Cowork logo

Claude Cowork

Use dbt Cloud MCP with Claude Cowork

Hermes logo

Hermes

Use dbt Cloud MCP with Hermes

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. Atomic Agent 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