Skip to main content
Back to the dbt Cloud MCP server

MCP Gateway · ChatGPT

dbt Cloud icon

Connect dbt Cloud to ChatGPT

Finance and operations teams can pull governed numbers into ChatGPT instead of exporting spreadsheets. With dbt Cloud behind the Speakeasy MCP Gateway, ChatGPT reads metrics, dimensions and exposures from the dbt Semantic Layer and project. A workspace admin imports Speakeasy's plugin marketplace and sets which roles get the dbt Cloud plugin.

Category
Data & analytics
Tools
24
Authentication
API key
ChatGPT
Web, desktop and mobile

Behind the MCP Gateway

Run dbt Cloud MCP behind the MCP Gateway

One URL for every agent, sign-in through your IdP, RBAC down to the tool, and every dbt Cloud call inspected and logged.

Deploy on MCP Gateway

Set up

Add dbt Cloud to ChatGPT in 4 steps

  1. 01

    Add dbt Cloud from the catalog

    An admin finds dbt Cloud in the MCP Catalog (MCP Gateway > MCP > Catalog) and clicks Add. Speakeasy registers the vendor's server as a remote MCP server and proxies sessions to it. Nothing is copied or re-hosted.

    dbt Cloud authenticates with an API key. Enter it under Upstream headers in the install dialog, or later on the server's Settings tab. The key is stored on the server, sent with every upstream request, and never reaches anyone's client configuration.

    Where MCP-scoped policies are enabled, the install offers a recommended risk policy for the new server that detects secrets and PII and inspects tool requests and responses.

  2. 02

    Choose who can use dbt Cloud

    Give teams the mcp:connect scope on the dbt Cloud server through team access or a role. ChatGPT connects to the dbt Cloud server's own URL, and the server's authorization decides who can connect and which tools they can call.

  3. 03

    Connect ChatGPT

    Import the organization's plugin marketplace into the ChatGPT workspace and set who gets each plugin.

    New MCP servers join the project's default plugin automatically. Each server's overview page shows which plugin it is published to, with Publish or Update to change it.

    Give the importing workspace admin collaborator access to the marketplace repository, and connect their GitHub account in ChatGPT under Plugins > GitHub > Manage.

    In ChatGPT, open Admin > Plugins > Add > Import marketplace.

    Set each plugin's installation policy, Installed or Available, per role.

    Enable the MCP servers the plugin connects to.

  4. 04

    Sign in and use dbt Cloud from ChatGPT

    The first time ChatGPT connects, it opens a browser so the person can sign in to Speakeasy through your identity provider.

    From then on, dbt Cloud's tools appear in ChatGPT, limited to what the person's access allows, and every call lands in the gateway's tool logs.

The marketplace syncs from GitHub once a day. Use Sync now to pick up a change straight away.

Use cases

What ChatGPT users do with dbt Cloud

Start from the data team's saved queries

Ask ChatGPT which saved queries the data team keeps in the dbt Semantic Layer, then query the matching metrics for this month's report.

list_saved_queriesquery_metrics

Break a metric down for a board slide

Get a metric split by one of its dimensions and have ChatGPT write the commentary that goes on the slide next to it.

get_dimensionsquery_metrics

Find out if a change affects your dashboard

When the data team announces a model change, ask ChatGPT which exposures, such as dashboards or analyses, depend on dbt and whether yours is listed.

get_exposuresget_exposure_details

Tools

24 tools

Each dbt Cloud tool can be allowed or denied per team and role at the MCP Gateway before ChatGPT sees it.

get_mart_models

Get the name and description of all mart models in the environment. A mart model is part of the presentation layer of the dbt project. It's where cleaned, transformed data is organized for consumption by end-users, like analysts, dashboards, or business tools.

get_all_models

Get the name and description of all dbt models in the environment.

get_model_details

Retrieves information about a specific dbt model, including compiled SQL, description, database, schema, alias, and column details.

get_model_parents

Retrieves the parent models of a specific dbt model. These are the models that the specified model depends on.

get_model_children

Retrieves the child models (downstream dependencies) of a specific dbt model. These are the models that depend on the specified model.

get_model_health

Retrieves information about the health of a dbt model, including the last time it ran, the last test execution status, and whether the upstream data for the model is fresh.

See all 24 tools

Control

What Speakeasy can see and stop in ChatGPT

The gateway covers every client the same way. The rest depends on what ChatGPT exposes to Speakeasy.

Tool logs

Gateway

Every dbt Cloud call is logged with the person and the client that made it.

Access by role

Gateway

People reach only the dbt Cloud tools their team or role allows.

Request and response blocking

Gateway

A risk policy scoped to dbt Cloud can reject a tool request before it reaches the server, or withhold a result from ChatGPT. MCP-scoped policies are enabled per organization.

Conversation import

ChatGPT

ChatGPT activity can be imported through OpenAI's Compliance API for review after the fact. It can't block in real time.

  • The workspace import needs a ChatGPT Business, Enterprise or Edu admin.

Questions

Frequently asked questions

Can Speakeasy block a ChatGPT request to dbt Cloud as it happens?
No. ChatGPT activity can be imported through OpenAI's Compliance API for review after the fact, but it can't block in real time. Tool access is still set per role at the MCP Gateway.
Which ChatGPT plans can import the dbt Cloud plugin?
The workspace import needs a ChatGPT Business, Enterprise or Edu admin.
How do ChatGPT users get dbt Cloud?
An admin adds dbt Cloud from the Speakeasy MCP Catalog and grants access by team or role. Import the organization's plugin marketplace into the ChatGPT workspace and set who gets each plugin. Each person then sees only the dbt Cloud tools their access allows.
Are dbt Cloud calls from ChatGPT logged?
Yes. dbt Cloud calls go through the MCP Gateway, which logs each tool call and attributes it to the person and the client that made it.

Connect more

dbt Cloud in other clients

AI everywhere.

Control here.