MCP Gateway · ChatGPT
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.
Set up
Add dbt Cloud to ChatGPT in 4 steps
- 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.
- 02
Choose who can use dbt Cloud
Give teams the
mcp:connectscope 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. - 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.
- 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.
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.
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.
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.
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?
Which ChatGPT plans can import the dbt Cloud plugin?
How do ChatGPT users get dbt Cloud?
Are dbt Cloud calls from ChatGPT logged?
Connect more