BigQuery MCP Server - MCP App for ChatGPT, Claude & AI Assistants | MCP App Store

Back to Apps

BigQuery MCP Server

Name: BigQuery MCP Server
Availability: InStock
Author: ergut

Supports UI

by ergut

Secure, read-only access to Google BigQuery datasets for LLMs, featuring automated sensitive data protection.

0 stars

0 views

Works in:claude

Exposes:Tools

View on GitHub Docs

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

Quick install

npx @ergut/mcp-bigquery-server --project-id your-project-id

Information

Pricing: free
Published: 4/11/2026
stars

Related Apps

Choose your AI client and follow the steps below.

Claude Desktop

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