BigQuery MCP by InsightfulPipe

Name: BigQuery MCP by InsightfulPipe
Author: Insightful-Pipe

by Insightful-Pipeversion 1.0.0i★ 0iRuns in the cloud

Registry namecom.insightfulpipe/bigquery

How to install

What it does

Hosted BigQuery MCP server for Claude, ChatGPT and Cursor, with each action switched per account.

Connects Runs in the cloud
Account or key Sign in to the service when you connect (OAuth)
Category Databases & datasets

Install

Pick the AI app you use, then copy the settings.

Passed 5/5 checks · What you ask goes through the maker’s server (bigquery.insightfulmcp.com) · ✓ Commands checked Nov 13, 2026

First: which AI do you use?

ClaudeWeb · app · phoneChatGPTWebClaude CodeTerminalCursorCode editorVS CodeCode editorOtherOther apps

Pick your app and the steps appear below.

Works with Claude · about 2 min

No key, nothing to install · Set it up once on claude.ai or the desktop app, then use it in chat · free accounts can add 1 · on Team/Enterprise an Owner adds it

Open Claude’s Connectors page
CustomizeConnectors
Done
Click “Add” → “Custom” → “Web” and fill in these 2 fields
Copy each value into the field with the same name in Claude, then click Continue
Name · NameBigQuery MCP by InsightfulPipe
Remote MCP server URL · Addresshttps://bigquery.insightfulmcp.com/
Click Continue past the sign-in settings Claude detected · under Authentication choose what the maker says (Sign in now, Sign in when needed or No sign in), then click Add
Done
Turn it on in a chat
+ConnectorsBigQuery MCP by InsightfulPipe
Done
Try it
Use BigQuery MCP by InsightfulPipe and tell me what you can do for me, then show me one thing
✓ If Claude says it is using BigQuery MCP by InsightfulPipe or shows a BigQuery MCP by InsightfulPipe tool in the answer, you are connected

Menu names checked against Anthropic’s help page on Nov 11, 2026 · your screen may differ slightly by app version

Works with ChatGPT, depending on your plan

Full MCP: ChatGPT Business, Enterprise or Edu on the web · Pro: connects with read/fetch permissions, so tools that change data may not work · Plus: not confirmed in OpenAI’s docs; if you see an add-custom-MCP option on the Plugins page you can try these steps · web only

Open ChatGPT’s add-MCP page on the web
Plugins+Add custom MCP server
Done
Fill in the name and address
Enter a name, paste the address under Connection, tick the risk warning and click Create as a plugin
Name · NameBigQuery MCP by InsightfulPipe
Connection · Addresshttps://bigquery.insightfulmcp.com/
Done
Pick BigQuery MCP by InsightfulPipe in a chat
Start a new chat and pick BigQuery MCP by InsightfulPipe from your plugins before typing
Done
Try it
Use BigQuery MCP by InsightfulPipe and tell me what you can do for me, then show me one thing
✓ If ChatGPT says it is using BigQuery MCP by InsightfulPipe or shows a BigQuery MCP by InsightfulPipe tool in the answer, you are connected

Menu names checked against OpenAI’s help page on Nov 11, 2026 · your screen may differ slightly by app version

Works with Claude Code · about 2 min

No key, nothing to install

Open Terminal
Mac: press Command+Space and type Terminal · Windows: open PowerShell
Done

Paste this command and press Enter

claude mcp add --transport http --scope user bigquery https://bigquery.insightfulmcp.com/

Done

Type /mcp in Claude Code
You should see BigQuery MCP by InsightfulPipe listed as connected
Done
Try it
Use BigQuery MCP by InsightfulPipe and tell me what you can do for me, then show me one thing
✓ If Claude Code says it is using BigQuery MCP by InsightfulPipe or shows a BigQuery MCP by InsightfulPipe tool in the answer, you are connected

Menu names checked against Anthropic’s help page on Nov 11, 2026 · your screen may differ slightly by app version

Works with Cursor · about 2 min

No key, nothing to install

Click this button to open Cursor
Open in Cursor
Cursor asks you to confirm; click Install
Done
Open the AI chat in Cursor in Agent mode
Done
Try it
Use BigQuery MCP by InsightfulPipe and tell me what you can do for me, then show me one thing
✓ If Cursor says it is using BigQuery MCP by InsightfulPipe or shows a BigQuery MCP by InsightfulPipe tool in the answer, you are connected

Menu names checked against Cursor’s help page on Nov 11, 2026 · your screen may differ slightly by app version

Works with VS Code · about 2 min

No key, nothing to install

Click this button to open VS Code
Open in VS Code
VS Code asks you to confirm; click Install
Done
Open the AI chat in VS Code in Agent mode
Done
Try it
Use BigQuery MCP by InsightfulPipe and tell me what you can do for me, then show me one thing
✓ If VS Code says it is using BigQuery MCP by InsightfulPipe or shows a BigQuery MCP by InsightfulPipe tool in the answer, you are connected

Menu names checked against VS Code’s help page on Nov 11, 2026 · your screen may differ slightly by app version

Other apps that use MCP, such as Windsurf, Zed or Gemini CLI, each add servers differently. See how in the app list.

See every app that uses MCP →

Address for apps that connect over the web

Addresshttps://bigquery.insightfulmcp.com/

JSON settings are under “For developers” below

Stuck? Ask people who use BigQuery MCP by InsightfulPipe💬 Discussion →

For developers: Terminal commands and JSON settings

Over the web

Claude Code

claude mcp add --transport http --scope user bigquery https://bigquery.insightfulmcp.com/

Cursor (~/.cursor/mcp.json)

{
  "mcpServers": {
    "bigquery": {
      "url": "https://bigquery.insightfulmcp.com/"
    }
  }
}

VS Code (mcp.json)

{
  "servers": {
    "bigquery": {
      "type": "http",
      "url": "https://bigquery.insightfulmcp.com/"
    }
  }
}

These settings are generated from the maker’s registry entry. If the README says otherwise, follow the README.

At a glance

GitHub stars i: 0
Downloads per weeki: Not on npm/PyPI
Verified domain: ✓ insightfulpipe.com
Licence i: MIT
Connection: Runs in the cloud
Transport: streamable-http
Latest versioni: 1.0.0
Categoryi: Databases & datasets
Published to registryi: Oct 21, 2026
Code last changedi: Oct 10, 2026
Maker: Insightful-Pipe
Repo: Insightful-Pipe/bigquery-mcp-server
Website: insightfulpipe.com
Registry status: Active

Which apps can use it

Based on how this server connects and on each app’s own docs, checked Nov 10, 2026.

Connect over the internet in

Claude ChatGPT Goose LM Studio Msty Studio Cherry Studio Cursor VS Code + GitHub Copilot Visual Studio Windsurf (Devin Desktop)Zed Kiro Cline Continue JetBrains AI Assistant Claude Code Codex CLI Gemini CLI OpenCode nodecode Warp LibreChat Open WebUI Raycast

All apps, with pros and cons →

What it can do

The server asks you to sign in before it lists its tools.

Basic checksi

We check information anyone can see; we have not read the code. Checks that do not apply are left out of the count. · Checked Nov 14, 2026

✓ Pass
Maker matches the repo
The registry name was verified against the domain insightfulpipe.com (the registry checks domain ownership)
✓ Pass
Still maintained
Code last changed 35 days ago
✓ Pass
Has a licence
Uses MIT
✓ Pass
Endpoint responds
Responded in 330 ms (HTTP 401)
✓ Pass
Sign-in with OAuth
Declares OAuth sign-in, so your AI app can take you to log in
… Not checked yet
No hidden instructions in tool descriptions
Not checked yet; we read the tool list when we check the endpoint

Discussion

Ask, share a tip or report that it does not work. Sorted by what people marked helpful.

No posts yet. Be the first to ask or share.

Posts here are written by users, not the PopNx team.

User reviews

No reviews yet

Compared with others in Databases & datasetsi

More stars than 0% of the other 1190 servers in this category
Published to the registry more recently than 65% of the other 1190 servers in this category
Basic checks equal to or better than 100% of the other 1190 servers in this category

Compared with every active server in this category in the registry. Stars count only when the publisher owns the repo.

Common questions

Is BigQuery MCP by InsightfulPipe safe?

It passed 5 of 5 applicable basic checks. We have not read the code. Before adding a key or token, see what access the server asks for and use a key with only the permissions you need.

What keys or codes does it need?

The registry does not list a required key, though some servers ask you to sign in on first use.

Does it run on my computer or in the cloud?

It runs in the maker’s cloud. Connect over the internet with nothing to install, but what you send passes through the maker’s servers.

Is it still maintained?

The GitHub repo last changed 35 days ago, and the latest version (1.0.0) reached the registry 24 days ago.

Which apps can use it?

Apps that support MCP, such as Claude Desktop, Claude Code, Cursor and VS Code. It connects by URL, so apps that accept remote MCP servers work too, such as ChatGPT on the web (full MCP on Business and above; Pro read-only).

What can I use instead?

In the same category: Dbx, MCP Toolbox for Databases, MCP Toolbox for Databases

Others in the same category

Servers in the same category from other makers, sorted by stars.

Reading a card:↓ Downloads per weeki★ GitHub starsiThree pillars: reviews · checks · usageiUpdated = latest version published to the registryi

Dbx

Query databases from AI agents using connections configured in DBX.

by t8y2Widely used↓ 9.4K/wk★ 30.3KUpdated 6 months ago

Runs on your computer

Install

MCP Toolbox for Databases

MCP Toolbox for Databases enables your agent to connect to your database.

by googleapisWidely used★ 16.9KUpdated yesterday

Runs on your computer

Install

MCP Toolbox for Databases

MCP Toolbox for Databases enables your agent to connect to your database.

by googleapisWidely used★ 16.9KUpdated 8 months ago

Runs on your computer

Install

README from the maker

Open the README

Copied from the maker’s repo as written. PopNx MCP has not reviewed or endorsed it. HTML, images and scripts are removed. Links lead off this site.

BigQuery MCP Server by Insightful Pipe

Connect BigQuery to AI assistants: datasets, schemas and SQL on Google Cloud.

Part of the Insightful Pipe MCP Server Collection — use BigQuery from Claude, ChatGPT, Cursor, and other AI assistants through the Model Context Protocol (MCP).

MCP Server URL

https://bigquery.insightfulmcp.com/

What is BigQuery MCP?

BigQuery MCP is a remote Model Context Protocol server hosted by InsightfulPipe. Query BigQuery datasets, list tables, inspect schemas, and run SQL on your connected Google Cloud projects. The roles you grant the service account in GCP decide whether the connection is read-only or read & write.

Installation

Claude

Copy the MCP Server URL: https://bigquery.insightfulmcp.com/
Open Claude Connectors Settings
Scroll to the bottom and click Add custom connector
Paste the URL and click Add
Click Connect and sign in to InsightfulPipe if asked. Claude then lists the connector as connected.

ChatGPT

Custom MCP servers are added through ChatGPT's Developer mode. Availability depends on your ChatGPT plan, and workspace admins may need to allow it.

Turn on Developer mode in ChatGPT settings
Create a new app for a remote MCP server and paste the URL: https://bigquery.insightfulmcp.com/
Sign in to InsightfulPipe if asked. The connection finishes as soon as you are signed in.

See OpenAI's guide: Developer mode and MCP apps in ChatGPT

Claude Code

claude mcp add --transport http bigquery https://bigquery.insightfulmcp.com/

Cursor

Add the server to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (one project):

"mcpServers": { "bigquery": { "url": "https://bigquery.insightfulmcp.com/" } } }

When Cursor shows Needs authentication, click Connect and sign in to InsightfulPipe if asked.

Available Actions

5 actions: 4 read, 1 write.

Read Actions (4)

Action	Description
`get_table_metadata`	Get full metadata for a table or view: schema, row count, size, partitioning, expiration
`get_table_schema`	Get the schema (column names + types) for a table or view
`list_datasets`	List all datasets in the connected Google Cloud project
`list_tables`	List all tables and views in a dataset

Write Actions (1)

Action	Description
`run_query`	Execute a Standard SQL query and return rows

Control What Your AI Can Do

You decide what AI agents can do with each connected account:

Turn individual actions on or off for every connected account, so agents only see the actions you allow.
Connect as Read-only or Read & Write. A read-only connection can only enable read actions.
Destructive actions stay off by default. Actions such as deletes are disabled until an admin enables them.
Team access per account. Restricted team members only use the accounts they are granted, with the read actions enabled on them.

Usage Examples

"List the datasets in my project"

"Show the schema of the events table"

"Run a query for daily sessions over the last 30 days"

Pricing

The BigQuery MCP server is included in every InsightfulPipe plan, together with all other MCP servers and the CLI. Plans start at $29.99/month, and you can try it for 7 days. See insightfulpipe.com/pricing for current plans.

Explore More MCP Servers by Insightful Pipe

Visit [insightfulpipe.com/mcp-servers](https://insightfulpipe.com/mcp-servers) to discover our full collection of MCP servers.

[View All MCP Servers →](https://insightfulpipe.com/mcp-servers)

Resources

Support

Documentation: insightfulpipe.com/docs
All MCP Servers: insightfulpipe.com/mcp-servers
Email: support@insightfulpipe.com

[Insightful Pipe](https://insightfulpipe.com) — AI-powered marketing analytics through MCP servers. Explore all integrations →

License

MIT License - see LICENSE for details.

BigQuery MCP by InsightfulPipe

What it does

Install

Open Claude’s Connectors page

Click “Add” → “Custom” → “Web” and fill in these 2 fields

Turn it on in a chat

Try it

Open ChatGPT’s add-MCP page on the web

Fill in the name and address

Pick BigQuery MCP by InsightfulPipe in a chat

Try it

Open Terminal

Paste this command and press Enter

Type /mcp in Claude Code

Try it

Click this button to open Cursor

Open the AI chat in Cursor in Agent mode

Try it

Click this button to open VS Code

Open the AI chat in VS Code in Agent mode

Try it

Over the web

At a glance

Which apps can use it

Related guides

What it can do

Basic checksi

Maker matches the repo

Still maintained

Has a licence

Endpoint responds

Sign-in with OAuth

No hidden instructions in tool descriptions

Discussion

User reviews

Compared with others in Databases & datasetsi

Common questions

Others in the same category

Dbx

MCP Toolbox for Databases

MCP Toolbox for Databases

README from the maker

BigQuery MCP Server by Insightful Pipe

MCP Server URL

What is BigQuery MCP?

Installation

Claude

ChatGPT

Claude Code

Cursor

Available Actions

Read Actions (4)

Write Actions (1)

Control What Your AI Can Do

Usage Examples

Pricing

Explore More MCP Servers by Insightful Pipe

Resources

Support

License