Mousten/mcp-bigquery-server

3.2

If you are the rightful owner of mcp-bigquery-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 dayong@mcphub.com.

MCP BigQuery Server is a FastMCP server designed for secure access to BigQuery datasets, featuring intelligent caching, schema evolution tracking, and query analytics through Supabase integration.

Tools

Functions exposed to the LLM to take actions

execute_bigquery_sql

Execute a read-only SQL query with intelligent caching.

get_datasets

Get list of datasets with metadata.

get_tables

Get tables in a dataset with column documentation.

get_table_schema

Get comprehensive table schema details.

get_query_suggestions

Get AI-powered query recommendations.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources

Author

Mousten

Claim Ownership

Verify you have write access to the repository

Repository

https://github.com/Mousten/mcp-bigquery-server

Last publish date

2025-05-27

Last update date

2025-10-23

Server configs

in claude desktop on linux

{
  "mcpServers": {
    "mcp-bigquery": {
      "command": "/path/to/your/project/.venv/bin/mcp-bigquery",
      "args": ["--transport", "stdio"],
      "env": {
        "PROJECT_ID": "your-project-id",
        "LOCATION": "US",
        "KEY_FILE": "/path/to/your/service-account-key.json",
        "SUPABASE_URL": "https://your-project.supabase.co",
        "SUPABASE_SERVICE_KEY": "your-service-role-key",
        "DEFAULT_USER_ID": "your-user-id"
      }
    }
  }
}

in claude desktop on windows

{
  "mcpServers": {
    "mcp-bigquery": {
      "command": "C:\\path\\to\\your\\project\\.venv\\Scripts\\mcp-bigquery.exe",
      "args": ["--transport", "stdio"],
      "env": {
        "PROJECT_ID": "your-project-id",
        "LOCATION": "US",
        "KEY_FILE": "C:\\path\\to\\your\\service-account-key.json",
        "SUPABASE_URL": "https://your-project.supabase.co",
        "SUPABASE_SERVICE_KEY": "your-service-role-key",
        "DEFAULT_USER_ID": "your-user-id"
      }
    }
  }
}