BigQuery Analysis MCP ServerServer

gotalab
GitHub
BigQuerySQLMCP

Loading subscription status...

💡 Description

This server is an MCP server for executing SQL queries against Google BigQuery, providing features like query validation, safe execution of SELECT queries, and JSON-formatted results.

📝 JSON Entries

{
  "mcpServers": [
    {
      "bigquery-analysis-server": {
        "command": "/path/to/bigquery-analysis-server/build/index.js"
      }
    }
  ]
}

🛠️ Tools

dry_run_queryrun_query_with_validation

Features

  • Query validation (dry run)
  • Safe query execution
  • JSON-formatted results

💬 Example Queries

  • Dry run a query: dry_run_query("SELECT * FROM `bigquery-public-data.samples.shakespeare` LIMIT 10")
  • Run a query with validation: run_query_with_validation("SELECT word, word_count FROM `bigquery-public-data.samples.shakespeare` WHERE corpus='hamlet' LIMIT 10")