gotalab_bigquery-analysis-mcp-server
If you are the rightful owner of gotalab_bigquery-analysis-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
This server is an MCP server designed for executing SQL queries against Google BigQuery, ensuring safe and efficient data handling.
The BigQuery Analysis MCP Server is a specialized server that facilitates the execution of SQL queries on Google BigQuery. It is designed to ensure the safety and efficiency of data handling by providing features such as query validation and safe execution. The server performs a dry run of queries to validate their correctness and estimate processing size, ensuring that only queries under 1TB are executed. This prevents any unintended data modifications or excessive data processing. The server returns results in a structured JSON format, making it easy to integrate with other systems and applications. It is built using Node.js and requires Google Cloud authentication, either through the gcloud CLI or a service account. The server is compatible with Claude Desktop and can be configured for use on both MacOS and Windows platforms. Debugging is facilitated through the MCP Inspector, which provides a user-friendly interface for monitoring server communications.
Features
- Query validation through dry runs to ensure correctness and estimate processing size.
- Safe execution of SELECT queries under 1TB to prevent data modifications.
- JSON-formatted results for easy integration with other systems.
- Node.js-based development with auto-rebuild capabilities for efficient development.
- Compatibility with Claude Desktop for seamless integration.
Tools
dry_run_query
Perform a dry run of a BigQuery query to validate and estimate processing size.
run_query_with_validation
Run a BigQuery query with validation, rejecting DML statements and queries over 1TB.