LucasHild/mcp-server-bigquery
MITAPI key required🐍 ☁️ - BigQuery database integration with schema inspection and query capabilities
Install
npx -y -y @smithery/cliRequired environment variables
BIGQUERY_KEYSet in your MCP configclaude_desktop_config.json
{
"mcpServers": {
"lucashild-mcp-server-bigquery": {
"command": "npx",
"args": [
"-y",
"-y",
"@smithery/cli"
],
"env": {
"BIGQUERY_KEY": "<YOUR_BIGQUERY_KEY>"
}
}
}
}Add this to your Claude Desktop config file. Find it at ~/Library/Application Support/Claude/claude_desktop_config.json on macOS.
What this does
LucasHild/mcp-server-bigquery exposes a set of tools to Claude over the Model Context Protocol. After you add it to claude_desktop_config.json (snippet above) and restart Claude Desktop, those tools become callable inside any conversation. That makes it useful when you want Claude to reach into your databases without copy-pasting context every turn.
Requirements
This server needs the following environment variables to be set before it can run:
BIGQUERY_KEY
Set these via the env object in your MCP config (see claude_desktop_config.json snippet above).
Common use cases
- •Query structured data without writing SQL by hand
- •Let Claude read table schemas before answering data questions
- •Run read-only operational reports or sanity checks during incidents
More Python MCP servers
microsoft/markitdown
🎖️ 🐍 🏠 - MCP tool access to MarkItDown -- a library that converts many file formats (local or remote) to Markdown for LLM consumption.
mindsdb/mindsdb
Connect and unify data across various platforms and databases with .
FastMCP
🐍 - A high-level framework for building MCP servers in Python
oraios/serena
🐍 🏠 - A fully-featured coding agent that relies on symbolic code operations by using language servers.