Loading subscription status...
💡 Description
This server enables interaction with Google BigQuery to execute read-only SQL queries, list datasets and tables, inspect table schemas, retrieve sample data, and estimate query costs, allowing AI agents to analyze data stored in BigQuery.
📝 JSON Entries
{
"mcpServers": [
{
"BigQuery": {
"env": {
"GOOGLE_APPLICATION_CREDENTIALS": "/path/to/service-account-key.json"
},
"args": [
"--project-id",
"your-project-id",
"--location",
"asia-northeast1",
"--max-results",
"1000",
"--max-bytes-billed",
"500000000000"
],
"command": "/path/to/dist/bigquery-mcp-server"
}
}
]
}🛠️ Tools
Execute read-only (SELECT) BigQuery SQL queriesList all datasetsList all tables in a datasetGet table schema and sample dataDry run query to check validity and estimate costs
⚡ Features
- Authentication and connection management
- Read-only access to BigQuery
- Cost estimation for queries
💬 Example Queries
- SELECT * FROM `project.dataset.table` LIMIT 10
- List all datasets in the project
- Get information for table 'your_table' in dataset 'your_dataset'