BigQuery MCP Server

What it does

BigQuery MCP Server enables LLMs to query and analyze BigQuery data using natural language. It acts as a secure translator between the AI and the database, with a strong focus on data privacy through field-level access restrictions and automated PII discovery.

Tools

• query_bigquery: Executes SQL queries against BigQuery datasets to retrieve analytical results.
• list_datasets: Discovers available datasets within the project.
• get_table_schema: Retrieves the schema of a specific table or view for better query construction.
• scan_sensitive_fields: (Admin) Automatically identifies columns matching sensitive patterns like emails or SSNs.

Installation

Add the following to your claude_desktop_config.json:

{
  "mcpServers": {
    "bigquery": {
      "command": "node",
      "args": [
        "/path/to/mcp-bigquery-server/dist/index.js",
        "--project-id",
        "your-project-id",
        "--location",
        "us-central1"
      ]
    }
  }
}

Supported hosts

• Claude Desktop