MCP BigQuery Server
JSON →Securely access BigQuery datasets with intelligent caching, schema tracking, and query analytics via Supabase integration.
Install
pip install -e Tools · 10
- 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
Environment variables
PROJECT_IDDEFAULT_USER_IDSUPABASE_URLSUPABASE_SERVICE_KEYSUPABASE_ANON_KEYOPENAI_API_KEY