BigQuery
About
Inspect database schemas and execute queries on Google BigQuery.
Details
- Author
- codearranger
- Categories
- Database, Other
Jump to
Setup
Install BigQuery in your MCP client (Claude Desktop, Cursor, Windsurf, and others).
Repository: https://github.com/codearranger/mcp-server-bigquery
Follow the installation instructions in the repository README, then restart your MCP client.
A Model Context Protocol server that provides access to BigQuery. This server enables LLMs to inspect database schemas and execute queries.
- execute-query: Executes a SQL query using BigQuery dialect
- list-tables: Lists all tables in the BigQuery database
- describe-table: Describes the schema of a specific table
The server can be configured with the following arguments:
- --project(required): The GCP project ID.
- --location(required): The GCP location (e.g.europe-west9).
- --dataset(optional): Only take specific BigQuery datasets into consideration. Several datasets can be specified by repeating the argument (e.g.--dataset my_dataset_1 --dataset my_dataset_2). If not provided, all datasets in the project will be considered.
- --key-file(optional): Path to a service account key file for BigQuery. If not provided, the server will use the default credentials.
To install BigQuery Server for Claude Desktop automatically viaSmithery:
npx -y @smithery/cli install mcp-server-bigquery --client claude
On MacOS:~/Library/Application\ Support/Claude/claude_desktop_config.jsonOn Windows:%APPDATA%/Claude/claude_desktop_config.json
"mcpServers": { "bigquery": { "command": "uv", "args": [ "--directory", "{{PATH_TO_REPO}}", "run", "mcp-server-bigquery", "--project", "{{GCP_PROJECT_ID}}", "--location", "{{GCP_LOCATION}}" ] } }
"mcpServers": { "bigquery": { "command": "uvx", "args": [ "mcp-server-bigquery", "--project", "{{GCP_PROJECT_ID}}", "--location", "{{GCP_LOCATION}}" ] } }
Replace{{PATH_TO_REPO}},{{GCP_PROJECT_ID}}, and{{GCP_LOCATION}}with the appropriate values.
To prepare the package for distribution:
This will create source and wheel distributions in thedist/directory.
Note: You'll need to set PyPI credentials via environment variables or command flags:
- Token:--tokenorUV_PUBLISH_TOKEN
- Or username/password:--username/UV_PUBLISH_USERNAMEand--password/UV_PUBLISH_PASSWORD
Since MCP servers run over stdio, debugging can be challenging. For the best debugging experience, we strongly recommend using theMCP Inspector.
You can launch the MCP Inspector vianpmwith this command:
npx @modelcontextprotocol/inspector uv --directory {{PATH_TO_REPO}} run mcp-server-bigquery
Upon launching, the Inspector will display a URL that you can access in your browser to begin debugging.
Access Google BigQuery to understand dataset structures and execute SQL queries.
A secure, self-hosted Model Context Protocol (MCP) server for Google BigQuery. Hard table allowlists, per-query scan ceilings, built-in rate limiting, and predictable costs on Cloud Run. Works with Claude, ChatGPT, Cursor, Gemini, and any MCP-compatible AI agent.
Connect to Google BigQuery databases using CData's MCP Server. Requires a separate CData JDBC Driver license.
Interact with Google BigQuery databases using natural language queries and schema exploration.
Open source MCP server specializing in easy, fast, and secure tools for Databases.
A read-only MCP server for AlloyDB, enabling LLMs to query live data directly from AlloyDB databases.
Securely access BigQuery datasets with intelligent caching, schema tracking, and query analytics via Supabase integration.
Official MCP server for dbt (data build tool) providing integration with dbt Core/Cloud CLI, project metadata discovery, model information, and semantic layer querying capabilities.
Query and analyze data with MotherDuck and local DuckDB
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
