Codex is one of the most popular coding harnesses out there. And MCP makes the experience even better. With Google BigQuery MCP integration, you can draft, triage, summarise emails, and much more, all without leaving the terminal or the app, whichever you prefer.
- UseBuild
- DEVELOPERS
## 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
How to integrate Google BigQuery MCP with Codex
Connect Codex to Google BigQuery MCP. Run yesterday's sales summary query, find top 10 customers by revenue, and more using natural language, with authentication handled for you.
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
Introduction
Also integrate Google BigQuery with
Why use Composio?
Apart from a managed and hosted MCP server, you will get:
- CodeAct: A dedicated workbench that allows GPT to write its code to handle complex tool chaining. Reduces to-and-fro with LLMs for frequent tool calling.
- Large tool responses: Handle them to minimise context rot.
- Dynamic just-in-time access to 20,000 tools across 1500+ other Apps for cross-app workflows. It loads the tools you need, so GPTs aren't overwhelmed by tools you don't need.
How to install Google BigQuery MCP in Codex
Run the setup command
Run this command in your terminal to add the Composio MCP server to Codex.
It will initiate the authentication in a browser window, authorize Codex to access your Composio account.
(Optional) Authenticate with OAuth
To authenticate manually, run the login command to open a browser window and authorize Codex to access your Composio account.
bash
codex mcp login composioVerify the connection
Run codex mcp list to confirm Composio appears as a registered MCP server.
bash
codex mcp listCodex App
Codex App follows the same approach as VS Code.
- Click ⚙️ on the bottom left → MCP Servers → + Add servers → Streamable HTTP:
- Fill the header and Key fields with
{ "x-consumer-api-key" = "ck_*******" }. - The Key is the Composio API key, that you can find on dashboard.composio.dev
- Click on Authenticate and authorize Codex to your Composio account and you're all set.
- Restart and verify if it's there in
.codex/config.toml
bash
[mcp_servers.composio]
url = "https://connect.composio.dev/mcp"
http_headers = { "x-consumer-api-key" = "ck_*******" }What is the Google BigQuery MCP server, and what's possible with it?
The Google BigQuery MCP server is an implementation of the Model Context Protocol that connects your AI agent and assistants like Claude, Cursor, etc directly to your Google BigQuery account. It provides structured and secure access to your projects, datasets, tables, jobs, routines, and machine learning models, so your agent can organize data, inspect schemas, load records, run query jobs, and retrieve results on your behalf.
- Dataset and table management: Have your agent create, inspect, update, list, or delete datasets and tables, and restore deleted datasets within their recovery window.
- Schema and row inspection: Let the agent fetch table schemas, metadata, and stored rows to understand the structure and contents of your data.
- Data loading and ingestion: Direct your agent to stream individual records into tables or start load jobs with uploaded files.
- Query and job operations: Instruct your agent to start query, load, extract, or copy jobs, check their status, list recent jobs, and retrieve query results.
- Routines, models, and data listings: Have your agent create routines and Analytics Hub listings, or list, update, and delete BigQuery ML models.
Conclusion
You've successfully integrated Google BigQuery with Codex using Composio's MCP server. Now you can interact with Google BigQuery directly from your terminal, VS Code, or the Codex App using natural language commands.
Key benefits of this setup:
- Seamless integration across CLI, VS Code, and standalone app
- Natural language commands for Google BigQuery operations
- Managed authentication through Composio
- Access to 20,000+ tools across 1500+ apps for cross-app workflows
- CodeAct workbench for complex tool chaining
Next steps:
- Try asking Codex to perform various Google BigQuery operations
- Explore cross-app workflows by connecting more toolkits
- Build automation scripts that leverage Codex's AI capabilities
TOOLS
Supported Tools
Every Google BigQuery action and event your agent gets out of the box.
FRAMEWORKS
How to build Google BigQuery MCP Agent with another framework
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 Agent SDK
Use Google BigQuery MCP with Claude Agent SDK
Muse
Use Google BigQuery MCP with Muse
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
Vercel AI SDK
Use Google BigQuery MCP with Vercel 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
MORE 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
With a standalone Google BigQuery MCP server, the agents and LLMs can only access a fixed set of Google BigQuery tools tied to that server. However, with the Composio Tool Router, agents can dynamically load tools from Google BigQuery and many other apps based on the task at hand, all through a single MCP endpoint.
Yes, you can. Codex fully supports MCP integration. You get structured tool calling, message history handling, and model orchestration while Tool Router takes care of discovering and serving the right Google BigQuery tools.
Yes, absolutely. You can configure which Google BigQuery scopes and actions are allowed when connecting your account to Composio. You can also bring your own OAuth credentials or API configuration so you keep full control over what the agent can do.
All sensitive data such as tokens, keys, and configuration is fully encrypted at rest and in transit. Composio is SOC 2 Type 2 compliant and follows strict security practices so your Google BigQuery data and credentials are handled as safely as possible.
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