F
licenseNot graded
qualityC
maintenanceEnables reading BigQuery data from ChatGPT using read-only SQL queries, with OAuth authentication and project-level access control.
-
BigQuery MCP Server
by amenke-lang
Provides tools for executing SQL queries, listing datasets and tables, getting table schemas, previewing table data, and retrieving table metadata in Google BigQuery.
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
BigQuery MCP Server
A custom MCP server for Google BigQuery with service account authentication.
Setup
Install dependencies:
pip install -r requirements.txtSet environment variables:
export BQ_SERVICE_ACCOUNT_KEY="/path/to/your-service-account-key.json" export BQ_PROJECT_ID="your-default-project-id"Run the server:
python bigquery_mcp.py
Related MCP server: BigQuery MCP Server
Configuration for Claude Desktop / Cowork
Add this to your MCP settings (e.g. claude_desktop_config.json):
{
"mcpServers": {
"bigquery": {
"command": "python",
"args": ["/path/to/bigquery_mcp.py"],
"env": {
"BQ_SERVICE_ACCOUNT_KEY": "/path/to/your-service-account-key.json",
"BQ_PROJECT_ID": "looplink-drt"
}
}
}
}Available Tools
Tool | Description |
| Run a read-only SQL query |
| List all datasets in a project |
| List tables in a dataset |
| Get column definitions for a table |
| Preview first N rows (free, no query cost) |
| Get table metadata (rows, size, partitioning) |
Notes
Only SELECT queries are allowed (safety enforced)
10 GB billing cap per query
Supports both
looplink-drtanddandelion-tf-productionprojects viaproject_idparameter
This server cannot be deployed
Maintenance
ActivityInactive
ResponsivenessNo issues
Related MCP Connectors
Read-only Google Search Console and Google Analytics for AI agents.
Provides read access to your GKE and Kubernetes resources.
Query your org's data in natural language — read-only MCP access to SQL, NoSQL, files & warehouses.
The BigQuery remote MCP server is a fully managed service that uses the Model Context Protocol to connect AI applications and LLMs to BigQuery data sources. It provides secure, standardized tools for AI agents to list datasets and tables, retrieve schemas, generate and execute SQL queries through natural language, and analyze data—enabling direct access to enterprise analytics data without requiring manual SQL coding.
Related MCP Servers
- AlicenseNot gradedqualityCmaintenanceEnables LLMs to explore BigQuery datasets and tables, run safe read-only queries, and optionally perform vector search using BigQuery embeddings.10MIT
- FlicenseNot gradedqualityCmaintenanceEnables secure read-only interaction with Google BigQuery through natural language, including listing datasets, listing tables, retrieving metadata, and executing queries with cost controls.-
- AlicenseNot gradedqualityCmaintenanceEnables read-only access to Google BigQuery, allowing users to list tables, inspect metadata, and run SELECT queries with enforced row and byte limits.Apache 2.0