mcp-bigquery-server
This MCP server provides secure, read-only access to BigQuery datasets for Large Language Models.
The BigQuery MCP Server acts as a translator between AI assistants and BigQuery databases, allowing users to interact with their data in plain English without needing to write SQL queries. It enables LLMs like Claude to query and analyze data securely and efficiently, ensuring that sensitive information remains protected with read-only access. With this server, users can run SQL queries by simply asking questions, explore dataset schemas, and analyze data within safe limits. It is designed to work seamlessly with Claude Desktop, making it easy for developers to integrate AI capabilities into their data workflows.
Compatible with
Install
Claude Desktop
Add to your claude_desktop_config.json:
{
"mcpServers": {
"mcp-bigquery-server": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-mcp-bigquery-server"
]
}
}
}Config File Location
Mac: ~/Library/Application Support/Claude/claude_desktop_config.json
Windows: %APPDATA%\Claude\claude_desktop_config.json
Linux: ~/.config/claude/claude_desktop_config.json
Some servers require additional setup - check the GitHub README for specific instructions.
Permissions