Can VS Code & GitHub Copilot Use BigQuery? MCP Setup (2026)

Q: Can VS Code & GitHub Copilot use BigQuery?

Yes. Add a remote URL in VS Code’s mcp.json ("type": "http"). Google Cloud runs an official remote MCP server (bigquery.googleapis.com). Checked live on 2026-10-27.

Updated October 27, 2026 · from live checks of 50,180 MCP servers · Methodology

Built a third-party BigQuery MCP server? Get the Verified vendor label so buyers can tell yours from the other 15 ($49/mo) Get Verified →

Remote BigQuery servers

Server	Publisher	Status	Sign-in	Tools	Trust
Google Cloud hosted MCP server `bigquery.googleapis.com`	Official · Google Cloud-hosted	Listed from vendor docs	OAuth (official)	—	—
BigQuery MCP by InsightfulPipe Yours? Claim it	Registry domain	Live · sign-in	OAuth sign-in	—	B
GCP Billing Yours? Claim it	Community	Live	No auth	9	B
Camber - Remote Agentic Data Science Yours? Claim it	Registry domain	Live · sign-in	OAuth sign-in	—	B
SaturnSQL Yours? Claim it	Registry domain	Live · sign-in	OAuth sign-in	—	C
Quanti Yours? Claim it	Registry domain	Live · sign-in	OAuth sign-in	—	C

Local BigQuery servers

Server	Publisher	Status	Sign-in	Tools	Trust
Patent MCP Server Yours? Claim it	Community	Local install	No auth	—	C
BigQuery Data Platform Yours? Claim it	Community	Local install	No auth	—	C
Cost Guard MCP Yours? Claim it	Community	Local install	API key	—	C
Sqlfmt MCP Yours? Claim it	Community	Local install	No auth	—	C
Patents MCP Yours? Claim it	Community	Local install	Unknown	—	C
Bigquery MCP Yours? Claim it	Community	Local install	No auth	—	C
Dbt Yours? Claim it	Community	Local install	API key	—	C
Warehouse MCP Yours? Claim it	Community	Local install	API key	—	C

How to add BigQuery to VS Code & GitHub Copilot

Open the Command Palette and run MCP: Add Server. Choose HTTP for a server URL or Command (stdio) for a local install command.
Or edit .vscode/mcp.json in your workspace: VS Code’s format puts servers under a top-level "servers" object (remote: "type": "http" + "url"; local: "type": "stdio" + "command"). Portable Copilot files (.mcp.json, ~/.copilot/mcp-config.json) use "mcpServers" instead, so don’t copy between them unchecked.
Sign in if the server asks, then use its tools in Copilot agent chat.

Example for Patent MCP Server (local, from the table above), in .vscode/mcp.json:

{
  "servers": {
    "bigquery": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "deeparchi-patent-mcp"
      ]
    }
  }
}

Menus change, so check the VS Code MCP configuration reference. Every server page has a copy-paste config for VS Code & GitHub Copilot.

Is it safe to connect BigQuery to VS Code & GitHub Copilot?

Use the official server run by Google Cloud. Anything a tool returns is sent to the AI vendor, so use a business plan that doesn't train on your data.

Can ChatGPT or Claude connect to BigQuery?

See https://canmyaiuse.pages.dev/can/chatgpt/bigquery/ and https://canmyaiuse.pages.dev/can/claude/bigquery/

Does BigQuery have an official MCP server?

Yes. Google Cloud hosts one at bigquery.googleapis.com. It isn't listed in the official MCP Registry; we found it on Google Cloud's own domain. Checked 2026-10-26. Full list: https://canmyaiuse.pages.dev/apps/bigquery/

Can VS Code & GitHub Copilot use BigQuery?

Official BigQuery route