BigQuery MCP by InsightfulPipe

com.insightfulpipePublished by insightfulpipe.comv1.0.0Updated Nov 4, 2026

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

VerifiedStreamable HTTPWeb executableDatabases Data & Analytics

Server details

Identifier: com.insightfulpipe/bigquery
Transport: Streamable HTTP
Runtime: Web executable
Trust: Verified
Published: Oct 21, 2026

Security note

MCP servers receive tool arguments from a conversation and may perform external actions. Review what a server can do before you enable it, and give it only the access it needs.

The registry verified that this server's namespace belongs to insightfulpipe.com, but the endpoint is not on that domain, so the publisher may not run this server.

SourceWeft's checks cover whether the listing is complete and the endpoint answered; they do not review the server's code or what its tools do.

Add a badge to your README

Show readers this MCP server is listed on SourceWeft. The badge links to this page.

[![Listed on SourceWeft](https://sourceweft.com/badge/mcp/com.insightfulpipe%2Fbigquery.svg)](https://sourceweft.com/mcp/com.insightfulpipe%2Fbigquery?utm_source=readme&utm_medium=badge)

Overview

AI-generated overview

Hosted BigQuery MCP server that lets an AI assistant list datasets and tables, inspect schemas, and run SQL against connected Google Cloud projects.

What you can do: List datasets in the connected Google Cloud project and tables and views inside a dataset
Inspect table or view schemas and full metadata such as row count, size, partitioning and expiration
Run Standard SQL queries and return the resulting rows
Scope each connected account to read-only or read & write, with individual actions switched on or off
When to use it: Useful when you want an assistant to explore BigQuery data and answer questions with SQL without building your own connector, especially if you want per-account control over which actions agents can call.
Requirements: A remote MCP endpoint added to Claude, ChatGPT (Developer mode), Claude Code or Cursor. OAuth sign-in to InsightfulPipe is required, and a Google Cloud project with a service account whose roles determine read-only or read & write access. A paid InsightfulPipe plan is needed after a 7-day trial.

Before you install

The run_query action executes SQL, so writes are possible when the connection is read & write and the service account has write roles; destructive actions are off by default but can be enabled by an admin. Query results and schema data pass through the hosted InsightfulPipe service. Access is billed through a subscription starting at $29.99/month.

Installation

In SourceWeft

Open BigQuery MCP by InsightfulPipe in the dashboard and add it to a workspace.
Connect the required credentials. They are stored privately and never shown on public pages.
Enable the server for the chats that should use its tools.

Web executable via Streamable HTTP. Remote servers run from the web runtime once configured in a workspace.

Use with an agent

Paste this prompt into Claude Code, Codex, Cursor or another agent — or into SourceWeft chat. The agent reads this server's install guide, shows you its publisher, endpoint and sign-in, and adds it to your client once you agree. Keys never go into a command.

Read https://sourceweft.com/mcp/com.insightfulpipe%2Fbigquery/install.md and connect the MCP server it describes to my client. Before changing any config, show me its publisher, endpoint and sign-in method and wait for my OK. Never put an API key in a command or in a file I would commit; ask me where it should come from.

Read the install guide the agent follows

Other MCP clients

Add this to your client's mcpServers config. The client completes OAuth sign-in on first connect.

{
  "mcpServers": {
    "bigquery-by-insightfulpipe": {
      "type": "http",
      "url": "https://bigquery.insightfulmcp.com/"
    }
  }
}

README

BigQuery MCP Server by Insightful Pipe

[MCP Compatible] [Insightful Pipe] [License]

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).

[BigQuery MCP Server]

MCP Server URL

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

Cursor

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

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)

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

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 to discover our full collection of MCP servers.

View All MCP Servers →

Resources

Support

Documentation: insightfulpipe.com/docs
All MCP Servers: insightfulpipe.com/mcp-servers
Email: [email protected]

Insightful Pipe — AI-powered marketing analytics through MCP servers. Explore all integrations →

License

MIT License - see LICENSE for details.

Source: README.md at commit 9916324

Tools

This server asks you to sign in, so SourceWeft could not read its tools without an account and has not indexed them. What a connected account sees can depend on that account and its permissions.

Version history

v1.0.0LatestOct 21, 2026

Score

85% of the applicable checks met

How complete this listing is, computed from the registry entry, the endpoint and public sources. Not a rating of the server and not a statement that it is safe or working today: reachability is a dated check, and no installs or reviews go into the score.

Reached in the last 30 daysRequired25 pts
Auth declaredRequired10 pts
Tools listed15 pts
Answer tools/list without a credential, or ship a package that starts in a sandbox without one.
DescriptionRequired15 pts
Logo10 pts
Documentation15 pts
License10 pts