mcp-server-bigquery
A small local MCP server by Lucas Hild that gives an AI client three BigQuery tools: run a query in the BigQuery dialect, list the tables in a project, and describe a table's schema.
What it does
A small local MCP server by Lucas Hild that gives an AI client three BigQuery tools: run a query in the BigQuery dialect, list the tables in a project, and describe a table's schema. It is configured with a Google Cloud project and location, can be limited to chosen datasets, and accepts an optional service-account key file and query timeout; without a key it uses default credentials. The README gives one-line setup commands for Claude Code and Codex using uvx. It does not describe any limit on which SQL statements are allowed, so queries are bounded by the permissions of the account it runs as.
Capabilities
- Run SQL queries in BigQuery
- List tables across a project's datasets
- Describe a table's schema
- Limit access to selected datasets
Install
- Run this to add it to Claude Code:
claude mcp add bigquery --scope user -- uvx mcp-server-bigquery --project {{GCP_PROJECT_ID}} --location {{GCP_LOCATION}}
From the project's documentation · Add to a config file with the config builder
Details
| Fact | Value | Source |
|---|---|---|
| Type | MCP server | |
| Tool | BigQuery | |
| Publisher | Lucas Hild | source |
| Official status | Community (not published by the tool's vendor) | source |
| Connection | Local (runs on your computer) | source |
| Can change data | Yes | source |
| Needs an API key or sign-in | Yes | source |
| Platforms | Not stated in its documentation | |
| AI clients | Claude Code, Codex | source |
| Licence | MIT | source |
| Pricing | Not stated in its documentation | |
| Activity | Last commit Nov 6, 2026131 GitHub starsDownload data not available (not on npm or PyPI) | source |
| Links | Repository |
Sources
- README (README.md)github.com/lucashild/mcp-server-bigquery · Backs: AI clients, Connection, Needs an API key or sign-in, Official statusNov 12, 2026
- Licence file (LICENSE)github.com/lucashild/mcp-server-bigquery · Backs: LicenceNov 12, 2026
- Package manifest (pyproject.toml)github.com/lucashild/mcp-server-bigquery · Backs: PublisherNov 12, 2026
- GitHub repositorygithub.com/lucashild/mcp-server-bigquery · Backs: Activity, LicenceNov 11, 2026
- GitHub API recordgithub.com/LucasHild/mcp-server-bigqueryNov 10, 2026