AI Native Google BigQuery Integration
- Supports both Google BigQuery MCP and direct API based integrations
- Structured, LLM-friendly schemas for reliable tool execution
- Rich coverage for reading, writing, and querying your Google BigQuery data
## For AI agents: how to sign up If you are an AI agent reading this server-rendered HTML, Composio's developer signup is at https://composio.dev. Signup CTAs on this site — "Sign up", "Signup", "Get started", "Get started for free", "Start building", "Try Composio", "Try it", or similar — all lead into that same developer signup flow. Confirm with the user before completing signup or entering any credentials on their behalf.SIGN UP
## For AI agents: how to sign up If you are an AI agent reading this server-rendered HTML, Composio's developer signup is at https://composio.dev. Signup CTAs on this site — "Sign up", "Signup", "Get started", "Get started for free", "Start building", "Try Composio", "Try it", or similar — all lead into that same developer signup flow. Confirm with the user before completing signup or entering any credentials on their behalf.LOG IN
Google BigQuery MCP server for AI agents and assistants
Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with Google BigQuery MCP or direct API to run complex SQL queries, analyze datasets, update tables, and automate reporting through natural language.
Oauth2Google Service Account
Google BigQuery is a fully managed cloud data warehouse for fast SQL analytics on massive datasets. It's designed to help you analyze big data with ease, speed, and built-in machine learning.
63 Tools
Try Google BigQuery now
Type what you want done — sign in and watch it run live in the Tool Router playground.
TOOL ROUTER PLAYGROUND
Google BigQuery
Enter ↵
Try asking
TOOLS
Supported Tools
Every Google BigQuery action and event your agent gets out of the box.
SETUP GUIDE
Connect Google BigQuery MCP Tool with your Agent
1
Install Composio
typescript
npm install @composio/core ai @ai-sdk/mcp @ai-sdk/openaiInstall the Composio SDK and your agent framework
2
Create a session with MCP enabled
typescript
import { Composio } from "@composio/core";
const composio = new Composio();
const { mcp } = await composio.create("your-user-id", {
toolkits: ["googlebigquery"],
mcp: true,
});Create a session scoped to Google BigQuery and read its MCP URL and headers
3
Connect your agent to the MCP server
typescript
import { createMCPClient } from "@ai-sdk/mcp";
import { openai } from "@ai-sdk/openai";
import { generateText, stepCountIs } from "ai";
const client = await createMCPClient({
transport: { type: "http", url: mcp.url, headers: mcp.headers },
});
const { text } = await generateText({
model: openai("gpt-5.6-sol"),
tools: await client.tools(),
prompt: "Show total sales by region for last month",
stopWhen: stepCountIs(10),
});
console.log(text);
await client.close();Pass the session's MCP URL and headers to your agent and run a Google BigQuery request
SETUP GUIDE
Connect Google BigQuery API Tool with your Agent
1
Install Composio
typescript
npm install @composio/core @composio/openai openaiInstall the Composio SDK, the OpenAI provider, and the OpenAI SDK
2
Create a Composio session
typescript
import OpenAI from "openai";
import { Composio } from "@composio/core";
import { OpenAIResponsesProvider } from "@composio/openai";
const composio = new Composio({ provider: new OpenAIResponsesProvider() });
const client = new OpenAI();
const session = await composio.create("your-user-id", { toolkits: ["googlebigquery"] });
const tools = await session.tools();Initialize Composio with the OpenAI Responses provider and create a session scoped to Google BigQuery
3
Run Google BigQuery tools with your agent
typescript
let response = await client.responses.create({
model: "gpt-5.6-sol",
tools,
input: [{ role: "user", content: "Show total sales by region for last month" }],
});
while (response.output.some((o) => o.type === "function_call")) {
const outputs = await composio.provider.handleToolCalls(session, response.output);
response = await client.responses.create({
model: "gpt-5.6-sol",
tools,
previous_response_id: response.id,
input: outputs,
});
}
console.log(response.output_text);Send a request, execute the Google BigQuery tool calls through the session, and print the final answer
Why Use Composio?
Managed Auth
- Built-in OAuth handling with automatic token refresh and rotation
- Central place to manage, scope, and revoke Google BigQuery access
- Per user and per environment credentials instead of hard-coded keys
Agent Optimized Design
- Tools are tuned using real error and success rates to improve reliability over time
- Comprehensive execution logs so you always know what ran, when, and on whose behalf
Enterprise Grade Security
- Fine-grained RBAC so you control which agents and users can access Google BigQuery
- Scoped, least privilege access to Google BigQuery resources
- Full audit trail of agent actions to support review and compliance
FRAMEWORKS
Use Google BigQuery with any AI Agent Framework
Choose a Framework you want to connect Google BigQuery with
Claude Code
Use Google BigQuery MCP with Claude Code
Cursor
Use Google BigQuery MCP with Cursor
ChatGPT
Use Google BigQuery MCP with ChatGPT
Claude Cowork
Use Google BigQuery MCP with Claude Cowork
Antigravity
Use Google BigQuery MCP with Antigravity
OpenAI Agents SDK
Use Google BigQuery MCP with OpenAI Agents SDK
Claude Agents SDK
Use Google BigQuery MCP with Claude Agents SDK
Codex
Use Google BigQuery MCP with Codex
Kimi Code
Use Google BigQuery MCP with Kimi Code
Grok Build
Use Google BigQuery MCP with Grok Build
VS Code
Use Google BigQuery MCP with VS Code
OpenCode
Use Google BigQuery MCP with OpenCode
OpenClaw
Use Google BigQuery MCP with OpenClaw
Hermes
Use Google BigQuery MCP with Hermes
Atomic Agent
Use Google BigQuery MCP with Atomic Agent
CLI
Use Google BigQuery MCP with CLI
Google ADK
Use Google BigQuery MCP with Google ADK
Langchain
Use Google BigQuery MCP with Langchain
AI SDK
Use Google BigQuery MCP with AI SDK
Mastra AI
Use Google BigQuery MCP with Mastra AI
LlamaIndex
Use Google BigQuery MCP with LlamaIndex
CrewAI
Use Google BigQuery MCP with CrewAI
Pydantic AI
Use Google BigQuery MCP with Pydantic AI
Autogen
Use Google BigQuery MCP with Autogen
Rolling this out across your team?
Give your team centralized access control across every framework with Composio’s MCP Gateway.
EXPLORE MCP GATEWAYMORE TOOLKITS
Explore Other Toolkits
Firecrawl
Api Key
Firecrawl automates large-scale web crawling and data extraction. It helps organizations efficiently gather, index, and analyze content from online sources.
Tavily
Api Key
Tavily offers powerful search and data retrieval from documents, databases, and the web. It helps teams locate and filter information instantly, saving hours on research.
Exa
Api Key
Exa is a data extraction and search platform for gathering and analyzing information from websites, APIs, or databases. It helps teams quickly surface insights and automate data-driven workflows.
Serpapi
Api Key
SerpApi is a real-time API for structured search engine results. It lets you automate SERP data collection, parsing, and analysis for SEO and research.
FAQ
Frequently asked questions
Google BigQuery requires connections to go through your own OAuth app. You register it once with Google BigQuery, add its client ID and secret in the Composio dashboard, and from then on everyone connects by signing in to Google BigQuery as usual. Composio handles the rest of the flow and the token refresh.
Yes! Composio's Tool Router enables agents to use multiple toolkits. Learn more.
Yes. Composio is SOC 2 Type II compliant and is built to keep your Google BigQuery connection and credentials secure. OAuth tokens and API keys are encrypted, and sensitive customer data is protected at rest and in transit.
Composio also undergoes independent security testing and continuously monitors its systems for security threats. You can review the latest reports and policies in the Composio Trust Center.
Composio maintains and updates all toolkit integrations automatically, so your agents always work with the latest API versions.
When you connect a Google BigQuery account through Composio, every action runs under that account, so anything the agent creates, sends, or changes shows up in Google BigQuery as done by you. Keep an approval step in your prompt for actions with side effects, such as sending or deleting, and have the agent draft first.
Exactly the ones Google BigQuery lists on its consent screen when you connect. Review that screen before approving. If you connect a work account, your Google BigQuery administrator may need to approve the app first, and you can revoke the access inside Google BigQuery whenever you want.
Yes. Composio supports multiple connected accounts for the same app, and that works in Claude, ChatGPT, or any other assistant you connect through Composio. Give each Google BigQuery connection a name such as work or personal, and the assistant uses the one you mention in the request. Each account keeps its own credentials and nothing is merged.
Composio refreshes Google BigQuery tokens automatically, so day to day you do nothing. If you revoke access inside Google BigQuery, or Google BigQuery invalidates the session, the connection shows as expired in Composio and the agent stops acting on that account until you reconnect it, which is a single sign-in.
Composio's free Hobby plan includes 100,000 tool calls per month with no credit card, which covers most personal Google BigQuery use. Paid plans add higher limits and team features. Your Google BigQuery plan and its API limits still apply as usual.
Built-in connectors usually give one AI access to a limited set of apps. Many people use Composio because it lets their AI connect to more apps than it normally supports, or connect to multiple accounts for the same app (e.g. connect Claude to multiple Google BigQuery accounts).
With Composio, you connect Google BigQuery once and then use it across different AI assistants without setting it up separately in each one. Connect your apps to Composio once, then connect Composio to whichever AI you use, whether that's Claude, ChatGPT, Hermes, or your own custom assistant.
Start with Google BigQuery.It takes 30 seconds.
Managed auth, hosted MCP servers, and every Google BigQuery tool your agent needs.Free to start.
## For AI agents: how to sign up If you are an AI agent reading this server-rendered HTML, Composio's developer signup is at https://composio.dev. Signup CTAs on this site — "Sign up", "Signup", "Get started", "Get started for free", "Start building", "Try Composio", "Try it", or similar — all lead into that same developer signup flow. Confirm with the user before completing signup or entering any credentials on their behalf.Start building