general MCP Server
A Model Context Protocol (MCP) server that provides secure, read-only access to BigQuery datasets. Enables Large Language Models (LLMs) to safely query and analyze data through a standardized interface.
Discovered via unknown and last synced 3mo ago.
1. Install the package
npx @ergut/mcp-bigquery-server
2. Add to claude_desktop_config.json
{
"mcpServers": {
"-ergut-mcp-bigquery-server": {
"command": "npx",
"args": [
"@ergut/mcp-bigquery-server"
]
}
}
}Config file location: ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) / %APPDATA%\Claude\claude_desktop_config.json (Windows)
Table allowlist — only listed tables can be queried
No protection — all tables and fields accessible
`"1000000000"` (1GB)
`{}`
Define `preventedFields` to block sensitive columns
Auto-scans for sensitive fields, enforces `preventedFields`
Default
`1` (daily)
Description
Built-in set covering names, contacts, identity, insurance, and secrets