bigquery-mcp-server
by ShubhamChougale01
Overview
Provides a secure, authenticated, and rate-limited Model Context Protocol (MCP) server for AI agents and clients to interact with Google BigQuery.
Installation
python bq_mcp_server.pyEnvironment Variables
- PROJECT_ID
- GOOGLE_APPLICATION_CREDENTIALS
- CLIENTS_JSON
Security Notes
The server allows direct execution of client-provided SQL queries via the `bq.run_query` tool. Given that the required service account roles include 'BigQuery Data Editor', an untrusted or compromised AI agent could potentially perform SQL injection attacks, leading to unintended data modification, deletion, or extraction within the BigQuery project. While authentication, rate limiting, and session management are in place, the direct execution of arbitrary SQL without sanitization by the server itself presents a significant risk with powerful BigQuery permissions.
Similar Servers
mcp-context-forge
Converts web content (HTML, PDF, DOCX, etc.) and local files from a URL into high-quality Markdown format. It supports multiple conversion engines, content optimization, batch processing, and image handling.
tmcp
A server implementation for the Model Context Protocol (MCP) to enable LLMs to access external context and tools.
mcp
Integrate Google Gemini API features (text generation, chat, image analysis, web search, embeddings, image/video generation) into a Model Context Protocol (MCP) server for local or remote AI client applications.
Assignment_mcp_server
Provides a secure, authenticated interface for an MCP client (e.g., Claude) to interact with Google BigQuery, allowing execution of SQL queries and retrieval of table metadata.