# Integrate Gemini Enterprise with dbt MCP

dbt platform

Gemini Enterprise can call external MCP servers as tools. This guide walks you through connecting it to the remote dbt MCP server, so you can explore your projects, jobs, lineage, and metrics in plain English from a Gemini Enterprise web app.

The connection uses OAuth. You register an app integration in the dbt platform, then add it to Gemini Enterprise as a custom MCP server. Each person authorizes with their own dbt platform account, so Gemini’s scope is limited to the data each user already has access to.

info

Remote MCP OAuth is available in public beta for Starter, Enterprise, and Enterprise+ accounts.

## Prerequisites

* A dbt platform account with an active deployed production environment. Remote MCP reads your production metadata, so with no models or jobs, you get very little back. Refer to [Set up the remote MCP server](./setup-remote-mcp.md).
* A dbt platform plan that includes the tools you need. The remote MCP server works on all [plans](https://www.getdbt.com/pricing), but its tools rely on [dbt APIs](../dbt-apis/overview.md) (like the Discovery API and Semantic Layer APIs) that vary by plan. An Enterprise or Enterprise+ plan gives you every tool.
* Permission to manage app integrations. You have it with the Account Admin, Security Admin, or Project creator permission set, or an IT license. Refer to [Enterprise permissions](../platform/manage-access/enterprise-permissions.md) and [Connect apps with OAuth](../platform/manage-access/connect-apps-oauth.md).
* A Google Cloud account with access to Gemini Enterprise, where you can create data stores and apps. You can get started by contacting Google Cloud sales, or try [Gemini Enterprise Plus edition at no cost for 30 days](https://console.cloud.google.com/freetrial?redirectPath=gemini-enterprise) without sales assistance.

## Register the app in dbt platform

Add your Gemini app integration in dbt platform by following these steps:

1. In dbt platform, go to **Account settings** → **Integrations** → **App integrations**.
2. Copy your **MCP Endpoint URL** and note your host, for example `abc123.us1.dbt.com`. You use both in the next section.
3. Select **+ Add integration**.

   [![The App integrations page with the MCP Endpoint URL and the Add integration button](/img/mcp/gemini-enterprise/dbt-mcp-endpoint-and-add-integration.png?v=2 "The App integrations page with the MCP Endpoint URL and the Add integration button")](#)The App integrations page with the MCP Endpoint URL and the Add integration button
4. Enter an integration name, such as `Gemini Enterprise connector`.
5. Set the **Redirect URI** to `https://vertexaisearch.cloud.google.com/oauth-redirect`, then select **Create integration**.
6. Copy the **Client ID**. The integration uses PKCE, so there's no client secret.

[![The registered integration with its Client ID and the PKCE only note](/img/mcp/gemini-enterprise/dbt-integration-client-id.png?v=2 "The registered integration with its Client ID and the PKCE only note")](#)The registered integration with its Client ID and the PKCE only note

## Add dbt MCP as a data store

In Gemini Enterprise, the MCP server lives in a data store.

1. In the Google Cloud console, go to **Gemini Enterprise** → **Data stores**, then select **Create data store**.

2. Under **MCP servers**, find **Custom MCP Server** and select **Add MCP server**.

   [![The Custom MCP Server card on the 'Create data store' page](/img/mcp/gemini-enterprise/gemini-add-custom-mcp-server.png?v=2 "The Custom MCP Server card on the 'Create data store' page")](#)The Custom MCP Server card on the 'Create data store' page

3. Select **OAuth 2.0**, then fill in the fields. Replace `YOUR_DBT_HOST_URL` with your host, for example `abc123.us1.dbt.com`. The table already adds `https://`.

   | Field                         | Value                                               |
   | ----------------------------- | --------------------------------------------------- |
   | MCP Server URL                | Your **MCP Endpoint URL** from the previous section |
   | Authorization URL             | `https://YOUR_DBT_HOST_URL/oauth/authorize`         |
   | Token URL                     | `https://YOUR_DBT_HOST_URL/oauth/token`             |
   | Client ID                     | The **Client ID** you copied                        |
   | Client Secret                 | Leave empty                                         |
   | Scopes                        | `user_access`                                       |
   | Enable PKCE Support           | Select the checkbox                                 |
   | Use HTTP Basic Authentication | Leave the checkbox cleared                          |

   [![The MCP Server Configuration form filled in for dbt](/img/mcp/gemini-enterprise/gemini-mcp-server-config.png?v=2 "The MCP Server Configuration form filled in for dbt")](#)The MCP Server Configuration form filled in for dbt

4. Once you click **Authorize**, it will open a separate window for you to allow Gemini access to dbt platform to perform the tasks and skills needed when communicating to the MCP. Select **Allow access**.

   [![The dbt platform window asking you to authorize the Gemini Enterprise connector](/img/mcp/gemini-enterprise/gemini-authorize-dbt-window.png?v=2 "The dbt platform window asking you to authorize the Gemini Enterprise connector")](#)The dbt platform window asking you to authorize the Gemini Enterprise connector

5. When you see **Successfully logged in**, select **Continue**.

6. Click **Allow access** then **Continue**.

7. Under **Advanced options**, add a description for the server. Gemini Enterprise uses it to decide when to call the server. Select **Continue**.

8. On the next page, choose a `region` and `name` the connector, then select **Create**.

   [![The data connector configuration with the region and connector name](/img/mcp/gemini-enterprise/gemini-configure-data-connector.png?v=2 "The data connector configuration with the region and connector name")](#)The data connector configuration with the region and connector name

Once the connector is created, **Connector state** shows **Active**.

## Enable the dbt actions

Your Gemini connectors actions remain disabled until you manually enable them:

1. In Gemini Enterprise, go to the connector and then the **Actions** tab.
2. Select **Reload custom actions**, which will prompt an authorization request.

   [![The Actions tab with the Reload custom actions button](/img/mcp/gemini-enterprise/gemini-reload-custom-actions.png?v=2 "The Actions tab with the Reload custom actions button")](#)The Actions tab with the Reload custom actions button
3. A dbt platform window will open. Select **Allow access**. The dbt MCP tools will then load with the status set as **Disabled**.
4. Select the actions you want, then select **Enable actions**. Once enabled, your MCP connector is ready to be used within a Gemini App.

[![Selecting dbt MCP actions and enabling them](/img/mcp/gemini-enterprise/gemini-enable-actions.png?v=2 "Selecting dbt MCP actions and enabling them")](#)Selecting dbt MCP actions and enabling them

Gemini Enterprise calls MCP tools *actions*. Refer to [Google's docs on enabling actions](https://docs.cloud.google.com/gemini/enterprise/docs/connectors/custom-mcp-server/set-up-custom-mcp-server#enable-actions). For what each tool does, refer to [Available MCP tools](./mcp-available-tools.md).

## Create a Gemini Enterprise app

Create Gemini Enterprise app by following these steps:

1. In Gemini Enterprise, go to **Apps** and select **Create app**.

2. Enter an app name, choose a location (**global** works if you have no preference), and enter your company's external name (optional). Select **Create**.

   [![The 'Create app' form with the app name, location, and company name](/img/mcp/gemini-enterprise/gemini-create-app.png?v=2 "The 'Create app' form with the app name, location, and company name")](#)The 'Create app' form with the app name, location, and company name

3. On the **Overview** page, bookmark or save the web app URL. You use it each time you chat with Gemini.

   [![The app Overview page with the web app URL](/img/mcp/gemini-enterprise/gemini-app-overview.png?v=2 "The app Overview page with the web app URL")](#)The app Overview page with the web app URL

4. Go to **Connected data stores** and select **Add existing data stores**.

   [![The 'Connected data stores' page with the Add existing data stores button](/img/mcp/gemini-enterprise/gemini-add-existing-data-stores.png?v=2 "The 'Connected data stores' page with the Add existing data stores button")](#)The 'Connected data stores' page with the Add existing data stores button

5. Select the dbt MCP connector, then select **Connect**.

   [![Selecting the dbt MCP connector in the 'Connect an existing data store' dialog](/img/mcp/gemini-enterprise/gemini-connect-existing-data-store.png?v=2 "Selecting the dbt MCP connector in the 'Connect an existing data store' dialog")](#)Selecting the dbt MCP connector in the 'Connect an existing data store' dialog

## Use dbt MCP from Gemini

Connect the dbt MCP server in your Gemini app by following these steps:

1. Open your web app URL.
2. Select the connectors icon, then select **Authorize** next to the dbt connector and **Allow access** in the dbt platform window. Each user needs to do this only once.
3. Ask a question, such as *"List all of the dbt projects"*.

[![Authorizing the dbt connector from the connectors menu in Gemini Enterprise](/img/mcp/gemini-enterprise/gemini-authorize-connector.png?v=2 "Authorizing the dbt connector from the connectors menu in Gemini Enterprise")](#)Authorizing the dbt connector from the connectors menu in Gemini Enterprise

Gemini calls the dbt MCP tools and returns your projects and environments, with follow-up questions to try next.

[![Gemini Enterprise listing dbt projects and environments through the dbt MCP connector](/img/mcp/gemini-enterprise/gemini-list-projects-result.png?v=2 "Gemini Enterprise listing dbt projects and environments through the dbt MCP connector")](#)Gemini Enterprise listing dbt projects and environments through the dbt MCP connector

You can now use [42+ different tools](./about-mcp.md#supported-tools-by-mcp-server-type) supported by dbt through this Gemini app, depending on your plan.

## Related docs

* [Set up the remote MCP server](./setup-remote-mcp.md)
* [Available MCP tools](./mcp-available-tools.md)
* [Connect apps with OAuth](../platform/manage-access/connect-apps-oauth.md)