Ctrlk
Log inSign up

BigQuery (Toolbox)

Connect AI assistants to BigQuery via Google's GenAI Toolbox using a service-account key.

Early Access — Reach out to your Natoma representative for access.

Type: Official

Source Type: Repository

Source: GitHub

Description: MCP Toolbox for BigQuery (powered by Google's GenAI Toolbox) provides AI assistants with access to Google BigQuery. It enables listing datasets and tables, inspecting schemas, and running SQL through a service-account key.

Configuration Parameters:

  • BigQuery Project * - GCP project ID (e.g. my-gcp-project).

  • Service Account Key JSON * (sensitive) - Full JSON contents of a service-account key with the BigQuery roles you need.

Setup Steps:

  1. In the Google Cloud Console, select the project that owns the BigQuery data.

  2. Navigate to IAM & Admin → Service Accounts → Create Service Account, then grant roles/bigquery.dataViewer and roles/bigquery.jobUser (or a narrower set).

  3. From the new account's Keys tab, click Add Key → Create new key, choose JSON, and download the file.

  4. When creating the connection in Natoma, paste the JSON contents and the project ID, then save.

Last updated