MCP Directory

How to add MCP Toolbox for Databases (BigQuery) to Cursor

Google's official MCP server with prebuilt BigQuery tools, querying datasets via Application Default Credentials. Paste the config into ~/.cursor/mcp.json and restart Cursor.

Last updated June 15, 2026 · 16k★ · stdio · oauth · official

Cursor config for MCP Toolbox for Databases (BigQuery)

brew install mcp-toolbox && toolbox --prebuilt bigquery --stdio
{
  "mcpServers": {
    "mcp-toolbox-for-databases-bigquery": {
      "command": "/absolute/path/to/toolbox",
      "args": [
        "--prebuilt",
        "bigquery",
        "--stdio"
      ],
      "env": {
        "BIGQUERY_PROJECT": "<your-gcp-project-id>"
      }
    }
  }
}

Setup steps

  1. 1Open Cursor → Settings → MCP → Add new MCP server (or edit ~/.cursor/mcp.json directly).
  2. 2Paste the MCP Toolbox for Databases (BigQuery) config below into the "mcpServers" object.
  3. 3Fill in placeholder secrets, then save.
  4. 4Cursor reloads MCP servers automatically — check Settings → MCP for a green status dot.
  5. 5Ask Cursor to use one of MCP Toolbox for Databases (BigQuery)'s tools to confirm it's connected.

Before you start

  • The toolbox binary (download from GitHub releases and `chmod +x`), or run via container/source; MCP Toolbox v0.7.0 or later for the full BigQuery toolset
  • A Google Cloud project with the BigQuery API enabled
  • Application Default Credentials configured locally (e.g. `gcloud auth application-default login`) or a service account key
  • IAM roles on the project/dataset such as BigQuery User and BigQuery Data Viewer (read), plus Job User to run queries
  • An MCP-capable client (Claude Desktop, Cursor, Gemini/ADK, etc.)

What MCP Toolbox for Databases (BigQuery) can do in Cursor

bigquery-execute-sql

Run an arbitrary SQL statement against BigQuery and return results

bigquery-sql

Run a parameterized/templated SQL query defined as a tool

bigquery-list-dataset-ids

List dataset IDs available in a project

bigquery-get-dataset-info

Get metadata for a given BigQuery dataset

bigquery-list-table-ids

Return the table IDs in a given dataset

bigquery-get-table-info

Get schema and metadata for a given table

bigquery-search-catalog

Find tables using a natural-language search over the data catalog

bigquery-forecast

Forecast time-series data using BigQuery ML forecasting

Security

Authentication relies on your local gcloud Application Default Credentials, so the server inherits whatever BigQuery permissions that identity has; use a least-privilege account. The command path must point at the toolbox binary you installed, so verify its absolute path.

MCP Toolbox for Databases (BigQuery) + Cursor FAQ

Where is the Cursor config file?

Cursor reads MCP servers from ~/.cursor/mcp.json. Paste the MCP Toolbox for Databases (BigQuery) config there under the "mcpServers" key and restart the client.

Is MCP Toolbox for Databases (BigQuery) safe to use with Cursor?

Authentication relies on your local gcloud Application Default Credentials, so the server inherits whatever BigQuery permissions that identity has; use a least-privilege account. The command path must point at the toolbox binary you installed, so verify its absolute path.

How does authentication work?

It uses Google Application Default Credentials (ADC). Run `gcloud auth application-default login` for local dev, or attach a service account with the right BigQuery IAM roles.

Can I make it read-only?

Yes. Scope the credential's IAM to read roles (e.g. BigQuery Data Viewer / Job User) and expose only the read/metadata tools in your tools.yaml to enforce a read-only production pattern.

Is this the same as 'GenAI Toolbox'?

Yes. MCP Toolbox for Databases is the renamed GenAI Toolbox, maintained by Google under the googleapis org, and works with Google's ADK as well as standard MCP clients.

View repo Full MCP Toolbox for Databases (BigQuery) page