# MCP Toolbox for Databases (BigQuery): an MCP server we run in production

Canonical: https://scalably.io/mcp/mcp-toolbox-bigquery
Source: https://github.com/googleapis/mcp-toolbox
Registry: not published to the MCP registry
Provenance: third-party server, pinned at 1.8.0, verified 2026-09-09. Verification note: install uses --config (the v1.8.0 README flag; --tools-file still works but warns); env var BIGQUERY_PROJECT and the tool names come from the pinned prebuilt bigquery.yaml
Integrity: no independent hash is published for this third-party listing; the raw endpoint at https://scalably.io/mcp/mcp-toolbox-bigquery.md mirrors this representation byte for byte
This is the machine-readable representation of the page at the canonical URL. Same facts, denser format.

## Direct answer
BigQuery datasets, tables and SQL for reporting agents, through a tools.yaml config.

## Install
- Claude Code: `curl -L -o toolbox https://storage.googleapis.com/mcp-toolbox-for-databases/v1.8.0/darwin/arm64/toolbox && chmod +x toolbox && ./toolbox --config tools.yaml --stdio`
- Codex: not available for this server.
- Claude Desktop: not available for this server.

## Environment
| Variable | Required | Secret | Purpose |
|---|---|---|---|
| `GOOGLE_APPLICATION_CREDENTIALS` | yes | no | service-account key path |
| `BIGQUERY_PROJECT` | yes | no | default project |

## Tools
| Tool | Description |
|---|---|
| `analyze_contribution` | Not documented for this listing. |
| `ask_data_insights` | Not documented for this listing. |
| `execute_sql` | Not documented for this listing. |
| `forecast` | Not documented for this listing. |
| `get_dataset_info` | Not documented for this listing. |
| `get_table_info` | Not documented for this listing. |
| `list_dataset_ids` | Not documented for this listing. |
| `list_table_ids` | Not documented for this listing. |
| `search_catalog` | Not documented for this listing. |

## Setup
Set the following before first use:
- `GOOGLE_APPLICATION_CREDENTIALS`: service-account key path
- `BIGQUERY_PROJECT`: default project

## Limits
Not documented by Google. See the vendor's own documentation: https://github.com/googleapis/mcp-toolbox

## Reliability
- CI: not applicable, this is a third-party project we do not control.
- Pinned at 1.8.0
- Verified 2026-09-09
- We run this server in production, pinned at the exact version, with the install command derived mechanically from that pin so it can be re-verified against the published package. install uses --config (the v1.8.0 README flag; --tools-file still works but warns); env var BIGQUERY_PROJECT and the tool names come from the pinned prebuilt bigquery.yaml

## Related
- Read more: [Claude Code MCP: how to add an MCP server](https://scalably.io/blog/claude-code-mcp), [What is an MCP server? A clear explainer for developers](https://scalably.io/blog/what-is-an-mcp-server)