bigquery
pipStandardThe BigQuery MCP server allows AI agents to query and retrieve data from Google BigQuery. It exposes SQL query execution, table metadata retrieval, and dataset management. It connects directly to BigQuery's REST API. Developers use it to integrate BigQuery data into AI workflows, enabling data analysis, reporting, and insights generation.
123330Updated 1 month ago
Overview
The BigQuery MCP server allows AI agents to query and retrieve data from Google BigQuery. It exposes SQL query execution, table metadata retrieval, and dataset management. It connects directly to BigQuery's REST API. Developers use it to integrate BigQuery data into AI workflows, enabling data analysis, reporting, and insights generation.
Installation
1Install the package
pip
pip install mcp-server-bigquery2Add to Claude
Add this configuration to your claude_desktop_config.json:
claude_desktop_config.json
{
"mcpServers": {
"lucashild-mcp-server-bigquery-github": {
"command": "uvx",
"args": [
"pip install mcp-server-bigquery"
]
}
}
}3Verify installation
Restart Claude Desktop, then ask:
"What tools do you have available from bigquery?"
Prerequisites
- Python 3.10 or higher
- pip or uv package manager
- Claude Desktop or Claude API access
- API key for bigquery
Configuration
API Key Required
This server requires an API key from bigquery. Add it to your environment or config.
| Variable | Required | Description |
|---|---|---|
| BIGQUERY_API_KEY | Yes | Your bigquery API key |
Usage Examples
List Resources
"What resources are available in bigquery?"
Claude will query available resources and return a list of what you can access.
Get Details
"Show me details about [specific item] in bigquery"
Claude will fetch and display detailed information about the requested item.
Create New
"Create a new [item] in bigquery with [details]"
Claude will use the appropriate tool to create the resource and confirm success.
Works with bigquery
Related skills
Browse all skillsNeed help with MCP integration?
We build custom MCP integrations for B2B companies. From simple connections to complex multi-tool setups.