How to connect Dbt Cloud to ChatGPT

  • ChatGPT gets 23 Dbt Cloud tools through one Metorial MCP URL.
  • Setup is 4 steps; teammates then sign in with SSO.
  • You need a ChatGPT plan or workspace that allows custom MCP servers.

What ChatGPT can do with Dbt Cloud

Ask your agent in plain language. Each of these maps to a real tool on the server.

  • Ask ChatGPT to use the list environments tool in Dbt Cloud
  • Ask ChatGPT to use the get run artifact tool in Dbt Cloud
  • Ask ChatGPT to use the cancel run tool in Dbt Cloud
  • Ask ChatGPT to use the list jobs tool in Dbt Cloud
  • Ask ChatGPT to use the get job tool in Dbt Cloud

Add the Dbt Cloud MCP server to ChatGPT

Run these once. Afterwards, everyone you give access to signs in the same way.

  1. 1. Enable Dbt Cloud in Metorial

    In your Metorial portal, enable the Dbt Cloud MCP server and sign in with the account that owns the data. Access stays governed by your team policies.

  2. 2. Add a custom MCP server

    On ChatGPT web, open Plugins, select +, then Add custom MCP server.

  3. 3. Paste your Metorial MCP URL

    Name it Metorial, paste your Magic MCP URL (<your-magic-mcp-url>), choose OAuth and accept the risk notice.

  4. 4. Create and install the plugin

    Select Create as a plugin, install it and sign in to load Dbt Cloud tools.

Give your team Dbt Cloud in ChatGPT

Once Dbt Cloud is enabled in Metorial, teammates sign in with SSO and get the same connection in ChatGPT, with only the tools their role allows.

One link covers every app you approve. See how the MCP gateway handles access, roles and audit logs for the whole company.

Dbt Cloud tools available in ChatGPT

Full descriptions and inputs are on the Dbt Cloud MCP server page.

  • Get Account: Retrieve details about the configured dbt Cloud account.
  • List Runs: List dbt Cloud job runs with optional filters for job, project, environment, or status.
  • List Projects: List all projects in the dbt Cloud account.
  • List Users: List all users in the dbt Cloud account.
  • Manage Webhook: Create, update, or delete a dbt Cloud webhook subscription.
  • List Environments: List all environments for a given dbt Cloud project.
  • Get Run Artifact: Fetch an artifact file from a completed dbt Cloud run as a Slate attachment.
  • Cancel Run: Cancel a currently queued or in-progress dbt Cloud job run.
  • List Jobs: List dbt Cloud jobs, optionally filtered by project or environment.
  • Get Job: Retrieve detailed information about a specific dbt Cloud job, including its schedule, execution steps, settings, and run history metadata.
  • Get Run: Retrieve detailed information about a specific dbt Cloud job run.
  • Trigger Job Run: Trigger a new run for a dbt Cloud job.
  • List Webhooks: List dbt Cloud webhook subscriptions configured for the account.
  • Get Run Failure Details: Retrieve retry-related failure details for a failed dbt Cloud run, including the failed step and skipped steps when available.
  • Get Webhook: Retrieve a dbt Cloud webhook subscription by ID, including subscribed events, target URL, active state, and scoped job IDs when available.
  • And 8 more on the Dbt Cloud MCP server page.

Using Dbt Cloud tools in ChatGPT

What to expect once Dbt Cloud is connected.

  • Type @ and pick the plugin. The selection applies to that message only, so @mention it again when a follow-up needs fresh Dbt Cloud data.
  • For write actions, ChatGPT may ask you to confirm first, depending on the app permissions and the action.
  • Once published for a workspace, ChatGPT keeps a snapshot of the tool list. When your team adds Dbt Cloud tools in Metorial, an admin refreshes the actions in Workspace settings before they appear.
  • You can use several apps in one prompt, for example read Dbt Cloud data and then create a ticket in another app.

Troubleshooting ChatGPT

Add custom MCP server is missing
Workspace policy controls it. On Enterprise and Edu, an admin grants the permission to create plugins with MCPs; ask them to enable it for you.
The plugin exists but no tools appear
Creating the plugin is not enough: install it from your plugins, then start a new conversation so ChatGPT loads its tools.
ChatGPT answers without using the tools
Pick the plugin with @ in the composer and name the action you want, for example "use Metorial to look up the latest ticket".

Based on the ChatGPT MCP documentation.

Frequently asked questions

Common questions about connecting Dbt Cloud to AI agents with Metorial.

  1. Does ChatGPT support the Dbt Cloud MCP server?
    Yes. ChatGPT connects to the Dbt Cloud MCP server through its connector settings, pointed at your Metorial URL. You need a ChatGPT plan or workspace that allows custom MCP servers.
  2. No. You sign in to Dbt Cloud once through Metorial, and ChatGPT uses that connection. No API keys go into ChatGPT's settings.
  3. All 23 Dbt Cloud tools your team allows, such as Get Account, List Runs, List Projects. Admins can narrow that list per team.
  4. Yes. Role-based access control decides who can use Dbt Cloud and which of its tools appear in ChatGPT, and every call is logged with the person's identity.
  5. Workspace policy controls it. On Enterprise and Edu, an admin grants the permission to create plugins with MCPs; ask them to enable it for you.

Connect Dbt Cloud to other AI clients

Connect other apps to ChatGPT