- BigQuery — Google’s managed server at
https://bigquery.googleapis.com/mcp - Cloud Logging — Google’s managed server at
https://logging.googleapis.com/mcp
Google’s managed servers use OAuth 2.0 bearer tokens checked against IAM.
There is no interactive consent screen for a service account — the IAM
permissions on the service account are the authorization.
Prerequisites
- A connected BigQuery integration. The Google MCP servers reuse its service account and custom role, which include every permission the BigQuery MCP server needs.
If you created the Sidecar custom role before
mcp.tools.call was added to
the BigQuery integration
instructions, edit the role and add
that permission in each project.The Cloud Logging server needs log read access that the custom role does not
include. If you use that server, also grant
roles/logging.viewer to the
service account in each project — or roles/logging.privateLogViewer to read
data-access audit logs.Confirm the connection
- In Sidecar, select Integrations → MCP Servers.
- Find the BigQuery and Cloud Logging rows.
- After the IAM grants propagate, the status shows Connected.
gcloud commands to fix them. Sidecar rechecks the
connection hourly.
Continue by granting the server to an agent and selecting it for
jobs.
Available tools
The BigQuery server exposes read-oriented tools includinglist_dataset_ids,
list_table_ids, get_dataset_info, get_table_info, and
execute_sql_readonly. The Cloud Logging server exposes read-only tools for
searching log entries and listing logs, buckets, and views. See Google’s
BigQuery MCP reference
and Cloud Logging MCP reference.
Queries run as the Sidecar service account, the same identity as the rest of
your Sidecar BigQuery integration.
Alternative: self-hosted BigQuery MCP
If you need tools Google’s managed server does not provide, you can still host the open source MCP Toolbox for Databases behind an HTTPS endpoint that accepts a stable bearer token, and register it through the custom connector. Expose a read-only toolset for Agent Console jobs and do not publish an unauthenticated endpoint.Troubleshooting
The server shows Auth error
The server shows Auth error
One or more IAM permissions are missing, or a grant has not propagated yet.
Open the server’s status detail for the exact missing permissions and
commands. IAM changes can take a few minutes to take effect.
Queries are denied for a specific project
Queries are denied for a specific project
The Sidecar custom role must be granted in every project agents query, not
only the service account’s home project. Check the project named in the
error.
Agents see datasets they should not
Agents see datasets they should not
Limit the service account’s read access with dataset-level access controls
that cover only the datasets agents may read.