SIGN UPLOG IN
X (Twitter)LinkedInGitHubDiscordYouTube

How to integrate dbt Cloud MCP with Hermes

Connect Hermes 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

Hermes is a 24/7 autonomous agent that lives on your computer or server — it remembers what it learns and evolves as your usage grows.

This guide explains the easiest and most robust way to connect your dbt Cloud account to Hermes. You can do this through either Composio Connect CLI or Composio Connect MCP. For personal use we recommend the CLI, but you won't go wrong with MCP either.

Also integrate dbt Cloud with

ChatGPTClaude CoworkAtomic Agent

What is Composio Connect?

Composio Connect is a consumer offering that lets anyone plug 1,500+ applications directly into their agent harness — including Hermes. It can:

  • Search and load tools from relevant toolkits on-demand, reducing context usage.
  • Chain multiple tools to accomplish complex workflows via a remote workbench, without excessive back-and-forth with the LLM.
  • Manage app authentication end-to-end with zero manual overhead.

Integrating dbt Cloud with Hermes

Using Composio Connect CLI

1. Install the Composio CLI

Run the install script directly, or paste https://composio.dev/hermes into your Hermes chat box to have it installed for you.

bash
curl -fsSL https://composio.dev/install | bash
Hermes authenticating with Composio

2. Authenticate

Once the CLI is installed, ask Hermes to authenticate with Composio.

3. Connect to dbt Cloud

Ask your agent to connect to dbt Cloud, or simply request any dbt Cloud-related task. Hermes will prompt you to authenticate and authorize access.

4. Done. You're all set with a new dbt Cloud connection.

Using Composio Connect MCP

1. Get your MCP URL and API Key

Go to dashboard.composio.dev and copy your Connect MCP URL and API key.

Copy MCP URL and API key from Composio dashboard

2. Open the Hermes config file

bash
nano ~/.hermes/config.yaml

3. Add the Composio Connect MCP server

bash
mcp_servers:
  composio:
    url: "https://connect.composio.dev/mcp"
    headers:
      x-consumer-api-key: "YOUR_COMPOSIO_API_KEY"
    connect_timeout: 60
    timeout: 180

Save with Ctrl + O, Enter, then exit with Ctrl + X.

4. Restart your Hermes agent

Once restarted, ask your agent to connect to dbt Cloud or request any dbt Cloud-related task. It will prompt you to authenticate and authorize access.

5. Done!

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.

Way Forward

With dbt Cloud connected, Hermes can now act on your behalf whenever it detects a relevant task or you ask it to.

From here, you can extend Hermes further:

  • Connect more apps: Calendar, Slack, Notion, Linear, and hundreds of others are available through the same Composio Connect setup. Each new integration compounds what Hermes can do for you.
  • Build workflows across tools: Once multiple apps are connected, Hermes can chain actions together — turn an email into a calendar invite, a Slack message into a Linear ticket, or a meeting note into a follow-up draft.
  • Let it learn your patterns: The more you use Hermes, the better it gets at anticipating how you'd handle recurring tasks. Give it feedback on drafts and decisions, and it will adapt.

If you run into trouble or want to share what you've built, join the community or check out the Docs for deeper configuration options.

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

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. Hermes 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