BigQuery MCP server: connect BigQuery to Claude, ChatGPT, Cursor and Claude Code. Hosted remote MCP for datasets, schemas and SQL on Google Cloud.
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add --transport http bigquery-by-insightfulpipe https://bigquery.insightfulmcp.com/~/.codex/config.toml
[mcp_servers.bigquery-by-insightfulpipe]
url = "https://bigquery.insightfulmcp.com/"
# codex mcp add bigquery-by-insightfulpipe --url https://bigquery.insightfulmcp.com/~/.cursor/mcp.json
{
"mcpServers": {
"bigquery-by-insightfulpipe": {
"url": "https://bigquery.insightfulmcp.com/"
}
}
}.vscode/mcp.json
{
"servers": {
"bigquery-by-insightfulpipe": {
"type": "http",
"url": "https://bigquery.insightfulmcp.com/"
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"bigquery-by-insightfulpipe": {
"httpUrl": "https://bigquery.insightfulmcp.com/"
}
}
}claude_desktop_config.json · Customize › Connectors › Add custom connector
{
"mcpServers": {
"bigquery-by-insightfulpipe": {
"command": "npx",
"args": [
"-y",
"mcp-remote",
"https://bigquery.insightfulmcp.com/"
]
}
}
}.trae/mcp.json
{
"mcpServers": {
"bigquery-by-insightfulpipe": {
"url": "https://bigquery.insightfulmcp.com/"
}
}
}