# How to connect dbt Cloud with ChatGPT

```json
{
  "title": "How to connect dbt Cloud with ChatGPT",
  "toolkit": "dbt Cloud",
  "toolkit_slug": "dbt_cloud",
  "framework": "ChatGPT",
  "framework_slug": "chatgpt",
  "url": "https://composio.dev/toolkits/dbt_cloud/framework/chatgpt",
  "markdown_url": "https://composio.dev/toolkits/dbt_cloud/framework/chatgpt.md",
  "updated_at": "2026-10-19T05:31:12.083Z"
}
```

## Introduction

### How to connect dbt Cloud MCP with ChatGPT
[ChatGPT](https://chatgpt.com/) can take action across your apps and files, stay with a project for hours, and turn a goal into finished materials like sheets, slides, and docs, not just answers.
In this guide, I will explain the easiest and most secure way to connect your dbt Cloud account to ChatGPT via Composio Connect, so it can list projects, inspect metadata, monitor job runs, query governed data, and manage environments through natural language commands without ever putting your account credentials at risk.

## Also integrate dbt Cloud with

- [Claude Cowork](https://composio.dev/toolkits/dbt_cloud/framework/claude-cowork)
- [Hermes](https://composio.dev/toolkits/dbt_cloud/framework/hermes-agent)
- [Atomic Agent](https://composio.dev/toolkits/dbt_cloud/framework/atomic-agent)

## TL;DR

### Why use Composio over default connectors?
- Apps with read and write access. Default connectors mostly can read your data. Composio's dbt Cloud integration lets ChatGPT take actions like creating drafts, sending updates, labeling records, and more.
- 1,500+ SaaS toolkits out of the box. Composio gives you instant access to a vast catalog of pre-built connectors, from Gmail and Slack to Notion, Linear, and Salesforce.
- One MCP server for every app. Connect any of your applications on demand through a single endpoint, rather than juggling a separate server for each app.
- Smart, context-aware tool loading. Unlike traditional MCP servers that dump every available tool into the LLM context window, Composio searches for and loads only the tools relevant to the task at hand.
- Cross-app automation. Chain actions across multiple apps in a single run - fetch a thread, summarize it in Notion, and post highlights to Slack without leaving the conversation.

## Connect dbt Cloud to ChatGPT

### Prerequisites
- A ChatGPT account. We will use the [ChatGPT desktop app](https://openai.com/chatgpt/download/), and the steps are the same on the web.
- Access to the dbt Cloud workspace you want to connect.
- [Composio plugin](https://dashboard.composio.dev/login?utm_source=toolkits&utm_medium=framework_template&utm_campaign=chatgpt&utm_content=composio_connect&next=%2F~%2Forg%2Fconnect%2Fclients%2Fchatgpt).
Note: Composio connects through OAuth. You will be asked to sign in and approve specific permissions. Review the permission screen carefully if you are using a work account.
### Step-by-step: Connect dbt Cloud to ChatGPT
### 1. Install the Composio plugin
Click the button. ChatGPT opens the Composio plugin page. Click Install plugin.
[Install in ChatGPT](https://chatgpt.com/plugins/plugin_asdk_app_6a58503580c08191b78cc5bdaf4eba6e)
You can also find it inside ChatGPT: go to Settings, open Plugins, search the marketplace for Composio, and click Install plugin.
### 2. Authenticate
After you install, ChatGPT asks you to authenticate with Composio. Log in and click Allow access to authorize ChatGPT to use your Composio account.
### 3. Start using Composio
That is it. Composio tools are now available in ChatGPT. Type @Composio followed by your request, for example @Composio find unread dbt Cloud messages and summarize them, and it will run the actions you authorize. On first use it asks you to authorize dbt Cloud.
### Option 2: Add Composio as an MCP server
If you cannot use the plugin marketplace, add Composio as a custom MCP server instead.
### 1. Open the MCP settings
In ChatGPT, go to Settings and open the Plugins section. Inside the Plugins page, click the MCP tab.
### 2. Add the server
Click Add server. In the Name field enter Composio, for Type select Streamable HTTP, and in the URL field paste the Composio MCP server URL:

```bash
https://connect.composio.dev/mcp
```

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

## Supported Tools

| Tool slug | Name | Description |
|---|---|---|
| `DBT_CLOUD_ADMIN_API_DELETE` | 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. Operation values are provider operation IDs. Deleted resources and configuration cannot be recovered by this action. |
| `DBT_CLOUD_ADMIN_API_READ` | 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. Operation values are provider operation IDs. This broad read is Bearer-token only because the mapped set includes operations with no official OAuth scope. |
| `DBT_CLOUD_ADMIN_API_WRITE` | Admin API Write | Execute one predeclared dbt Cloud Administrative API POST, PATCH, or PUT operation. Selected operations may create or mutate administrative resources; review the matching provider OpenAPI operation, path parameters, query, and body before execution. Operation values are provider operation IDs. This action is bearer-token only because the operation set includes routes outside dbt Cloud's officially documented OAuth scopes. |
| `DBT_CLOUD_CANCEL_RUN` | Cancel Run | Irreversibly request cancellation of a queued, starting, or running dbt Cloud run. This mutates the selected run's execution state and does not delete its run record. The response is the run record returned after the cancellation request. |
| `DBT_CLOUD_DOWNLOAD_RUN_ARTIFACT` | Download Run Artifact | Download one artifact file from a completed dbt Cloud run using a path returned by List Run Artifacts. |
| `DBT_CLOUD_FIND_SEMANTIC_SAVED_QUERIES` | Find Semantic Saved Queries | List or search saved Semantic Layer queries, or return one exact saved query by name. |
| `DBT_CLOUD_GET_JOB` | Get Job | Return one dbt Cloud job definition and optionally selected related execution context. |
| `DBT_CLOUD_GET_RUN` | Get Run | Return one dbt Cloud run with optional job, environment, step, retry, audit, or log context. |
| `DBT_CLOUD_GET_RUN_FAILURE_DETAILS` | Get Run Failure Details | Return dbt Cloud status and step logs for a failed run. This action only reads the run record and never starts or enqueues a retry. |
| `DBT_CLOUD_LIST_ENVIRONMENTS` | List Environments | Return one page of environments for a dbt Cloud project, with optional deployment and name filters. |
| `DBT_CLOUD_LIST_JOBS` | List Jobs | Return one page of dbt Cloud jobs, optionally filtered by project, environment, name, schedule, or state. |
| `DBT_CLOUD_LIST_PROJECTS` | List Projects | Return one page of dbt Cloud projects, optionally filtered by name, IDs, or deletion state. |
| `DBT_CLOUD_LIST_RUN_ARTIFACTS` | List Run Artifacts | Return artifact paths available for a completed dbt Cloud run. |
| `DBT_CLOUD_LIST_RUNS` | List Runs | Return one page of dbt Cloud runs, optionally filtered by job, project, environment, status, creation time, finish time, or deletion state. |
| `DBT_CLOUD_LIST_SEMANTIC_ATTRIBUTES` | List Semantic Attributes | Return one page of dimensions, entities, group-bys, or queryable time granularities available for selected metrics. |
| `DBT_CLOUD_LIST_SEMANTIC_METRICS` | List Semantic Metrics | Return one page of governed Semantic Layer metrics, optionally searched or grouped. |
| `DBT_CLOUD_QUERY_DISCOVERY_METADATA` | 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. |
| `DBT_CLOUD_QUERY_SEMANTIC_METRICS` | 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. Pass next_cursor to retrieve another page without creating a new query. |
| `DBT_CLOUD_RETRY_RUN` | Retry Run | Start a new retry from a failed dbt Cloud run and return the newly enqueued run record. |
| `DBT_CLOUD_TRIGGER_JOB_RUN` | Trigger Job Run | Start a new run for a dbt Cloud job, optionally overriding its revision, target, commands, docs generation, threads, or timeout. Each successful call enqueues a new run. |

## Supported Triggers

None listed.

## Creating MCP Server - Stand-alone vs Composio SDK

Once connected, ChatGPT can access the dbt Cloud MCP server via Composio to run actions that you authorize, directly in your workspace.

## Complete Code

None listed.

## How to build dbt Cloud MCP Agent with another framework

- [Claude Cowork](https://composio.dev/toolkits/dbt_cloud/framework/claude-cowork)
- [Hermes](https://composio.dev/toolkits/dbt_cloud/framework/hermes-agent)
- [Atomic Agent](https://composio.dev/toolkits/dbt_cloud/framework/atomic-agent)

## Related Toolkits

- [Firecrawl](https://composio.dev/toolkits/firecrawl) - Firecrawl automates large-scale web crawling and data extraction. It helps organizations efficiently gather, index, and analyze content from online sources.
- [Tavily](https://composio.dev/toolkits/tavily) - 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](https://composio.dev/toolkits/exa) - 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](https://composio.dev/toolkits/serpapi) - 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.
- [Peopledatalabs](https://composio.dev/toolkits/peopledatalabs) - Peopledatalabs delivers B2B data enrichment and identity resolution APIs. Supercharge your apps with accurate, up-to-date business and contact data.
- [Snowflake](https://composio.dev/toolkits/snowflake) - Snowflake is a cloud data warehouse built for elastic scaling, secure data sharing, and fast SQL analytics across major clouds.
- [Posthog](https://composio.dev/toolkits/posthog) - PostHog is an open-source analytics platform for tracking user interactions and product metrics. It helps teams refine features, analyze funnels, and reduce churn with actionable insights.
- [Ahrefs MCP](https://composio.dev/toolkits/ahrefs_mcp) - Ahrefs MCP is Ahrefs' hosted MCP server for SEO data and insights. Use it to access backlinks, organic metrics, keyword research, and competitor analysis.
- [Akta](https://composio.dev/toolkits/akta) - Akta is a company intelligence platform providing enrichment, news, and alternative business signals. It helps teams build targeted company lists and enrich data-driven workflows.
- [Amplitude](https://composio.dev/toolkits/amplitude) - Amplitude is a digital analytics platform for product and behavioral data insights. It helps teams analyze user journeys and make data-driven decisions quickly.
- [Amplitude MCP](https://composio.dev/toolkits/amplitude_mcp) - Amplitude MCP is Amplitude's product analytics service for tracking user behavior and product metrics. Use it to centralize product data and manage charts, dashboards, cohorts, experiments, and taxonomy.
- [Audioscrape MCP](https://composio.dev/toolkits/audioscrape_mcp) - Audioscrape MCP lets agents search and retrieve speaker-attributed audio, transcripts, entities, and citations from public and workspace content. Use it to surface searchable, speaker-labeled audio and rich metadata for research, meetings, and content discovery.
- [Baremetrics](https://composio.dev/toolkits/baremetrics) - Baremetrics is a subscription analytics platform for recurring-revenue businesses. It helps teams track MRR, churn, customers, and revenue trends in one place.
- [Bing Webmaster Tools](https://composio.dev/toolkits/bing_webmaster_tools) - Bing Webmaster Tools is Microsoft's search console for site performance, crawling, indexing, URL submission, and verified site management. It helps site owners understand Bing Search visibility and fix issues that affect organic traffic.
- [Bread & Butter](https://composio.dev/toolkits/bread_butter) - Bread & Butter is a lead-intelligence and identity platform for website visitor tracking, user profiles, attribution, authentication, and conversion workflows. It helps teams understand who is visiting, where leads come from, and how users convert.
- [Bright Data MCP](https://composio.dev/toolkits/brightdata_mcp) - Bright Data MCP is an AI-powered web scraping and data collection platform. Instantly access public web data in real time with advanced scraping tools.
- [Browseai](https://composio.dev/toolkits/browseai) - Browseai is a web automation and data extraction platform that turns any website into an API. It's perfect for monitoring websites and retrieving structured data without manual scraping.
- [BSC Designer](https://composio.dev/toolkits/bsc_designer) - BSC Designer is a strategy execution platform for balanced scorecards, KPIs, dashboards, and strategy maps. It helps teams turn goals into measurable performance plans they can track over time.
- [Chameleon](https://composio.dev/toolkits/chameleon) - Chameleon is a product adoption platform for building in-app experiences, managing customer data, and analyzing user engagement. It helps teams improve onboarding, feature discovery, and product adoption with targeted user experiences.
- [Chartly](https://composio.dev/toolkits/chartly) - Chartly renders Chart.js configurations as PNG or SVG images and creates permanent chart URLs for sharing and embedding. Share and embed charts easily with stable image URLs and downloadable vector graphics.

## Frequently Asked Questions

### What are the differences in Tool Router MCP and dbt Cloud MCP?

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.

### Can I use Tool Router MCP with ChatGPT?

Yes, you can. ChatGPT 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.

### Can I manage the permissions and scopes for dbt Cloud while using Tool Router?

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.

### How safe is my data with Composio Tool Router?

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.

---
[See all toolkits](https://composio.dev/toolkits) · [Composio docs](https://docs.composio.dev/llms.txt)