bigquery-analysis-mcp-server

bigquery-analysis-mcp-server

3.2

If you are the rightful owner of 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 for executing SQL queries against Google BigQuery.

The BigQuery Analysis MCP Server is designed to facilitate the execution of SQL queries on Google BigQuery. It offers features such as query validation through dry runs, safe execution of SELECT queries under 1TB, and returns results in JSON format. The server ensures that only valid queries are executed, preventing data modifications and excessive data processing. It is built with Node.js and requires Google Cloud authentication for operation.

Features

  • Query validation (dry run): Verifies if a query is valid and estimates its processing size.
  • Safe query execution: Only runs SELECT queries under 1TB to prevent data modifications.
  • JSON-formatted results: Returns query results in structured JSON format.

Tools

  1. dry_run_query

    Perform a dry run of a BigQuery query to validate and estimate processing size.

  2. run_query_with_validation

    Run a BigQuery query with validation, rejecting DML statements and large data processing.