BigQuery MCP server

Install the predefined BigQuery MCP server behind the P0 AI Gateway, giving agents policy-scoped, credential-free access to the Google Cloud BigQuery API.

The BigQuery MCP server is a predefined GCP MCP server that exposes the Google Cloud BigQuery API to agents, so they can work with datasets, tables, and query jobs. It runs P0's Google Cloud MCP image behind the P0 AI Gateway and bridges to Google's hosted BigQuery MCP endpoint.

Agents can request BigQuery access two ways, and they never hold Google Cloud credentials: the gateway obtains a short-lived, policy-scoped token for each session using Workload Identity Federation.

• Resource-scoped access to a single dataset or table, with a role such as bigquery.dataViewer. Prefer this, since it grants the least access.

• Project-wide access across every resource in the project, with a role such as bigquery.dataEditor. Use this only when the calling tools must span multiple resources.

The BigQuery MCP server is a preview feature. Contact P0 to enable it for your organization.

Before you start, complete the GCP MCP server prerequisites.

Configure the BigQuery MCP server

1. Follow the shared steps in Add an MCP server to name the server, choose its gateway, and set its path. On the configuration screen, set the following fields, then click Finish:

   • Credential source: choose GCP WIF federation, then select the Federation provider: the GCP Workload Identity Federation identity you installed. The gateway uses this identity's audience when it federates to Google Cloud, and the provider's trust configuration authorizes it.

   • Definition: choose P0, then select Google Cloud BigQuery as the predefined server identifier.

2. The server now appears with the state Installed.

Once saved, P0 pushes the server definition to the gateway on its next sync, and the BigQuery MCP server becomes available to agents through the gateway URL. Access is granted per session and governed by your P0 policy; no long-lived Google Cloud credentials are issued.

Next steps

• Define the MCP roles and policies that determine which agents and users may call the BigQuery MCP server, and what they may do in BigQuery.