bigquery-mcp-server-demo
Verified Safeby DhunganaKB
Overview
Implements a Model Context Protocol (MCP) server for BigQuery, enabling conversational analytics and schema inspection of specified datasets and tables.
Installation
uvicorn main:app --reloadEnvironment Variables
- GOOGLE_API_KEY
Security Notes
The system relies on the Google ADK Framework and an external 'toolbox' binary (Gen AI Toolbox for Databases) to interact with BigQuery. The `execute_sql` tool, exposed to the LLM agent, is powerful and could potentially execute arbitrary SQL if the agent is compromised or misconfigured. While the ADK framework and agent instructions aim to guide safe tool usage, the underlying 'toolbox' binary is a black box without its source code for auditing. The FastAPI endpoint lacks built-in authentication/authorization and is intended for local access; exposing it externally without additional security layers would pose a significant risk. No 'eval' or obvious obfuscation found.
Similar Servers
tmcp
A server implementation for the Model Context Protocol (MCP) to enable LLMs to access external context and tools.
fastify-mcp-server
A Fastify plugin providing a streamable HTTP transport for the Model Context Protocol (MCP), enabling AI assistants to interact with services.
polybrain-mcp
Connects AI agents to multiple LLM models, providing conversation history management and model switching capabilities.
bigquery-mcp-server
Provides a secure, authenticated, and rate-limited Model Context Protocol (MCP) server for AI agents and clients to interact with Google BigQuery.