MCP Servers / database / MCP BigQuery Server

MCP BigQuery Server

stdiononedatabase

Securely access BigQuery datasets with intelligent caching, schema tracking, and query analytics via Supabase integration.

Install

How to run this server

[ { "cmd": "pip install -e", "imports": [] } ]

server path: mcp-bigquery-server

Tools

What this server exposes

execute_bigquery_sql

Execute read-only SQL queries with caching

get_datasets

Get list of datasets with metadata

get_tables

Get tables in a dataset with documentation

get_table_schema

Get table schema with business context

get_query_suggestions

Get AI-powered query recommendations

explain_table

Get comprehensive table documentation

analyze_query_performance

Analyze query performance patterns

get_schema_changes

Track schema evolution over time

manage_cache

Cache management operations

health_check

System health check

Configuration

Environment & auth

authnone

envPROJECT_ID

envDEFAULT_USER_ID

envSUPABASE_URL

envSUPABASE_SERVICE_KEY

envSUPABASE_ANON_KEY

envOPENAI_API_KEY

Resources