BigQuery MCP Server

Stabledatabase

★250 starsPythonLucasHild

About

Overview

The BigQuery MCP Server connects AI agents to Google BigQuery. It provides tools for executing SQL queries, listing datasets and tables, inspecting schemas, and managing jobs. Designed for large-scale data analysis with support for BigQuery's unique features like partitioned tables, clustering, and federated queries.

Capabilities

Tools & Capabilities

⚡query

Execute a SQL query against BigQuery

⚡list_datasets

List all datasets in the project

⚡list_tables

List tables in a dataset

⚡describe_table

Get the schema of a table

⚡dry_run

Estimate query cost without executing

Setup

Installation

bash

Install

pip install mcp-server-bigquery

Examples

Example Usage

javascript

Usage

{
  "mcpServers": {
    "bigquery": {
      "command": "python",
      "args": ["-m", "mcp_server_bigquery"],
      "env": {
        "GOOGLE_PROJECT_ID": "your-project-id",
        "GOOGLE_APPLICATION_CREDENTIALS": "./service-account.json"
      }
    }
  }
}

Quick Info

AuthorLucasHild

LanguagePython

StatusStable

Stars★ 250

Last UpdatedFeb 12, 2026