BigQuery
Run SQL queries and interact with Google BigQuery datasets.
BigQuery
Run SQL queries and interact with Google BigQuery datasets. With Lunar.dev MCPX, the MCP Gateway for secure and governed tool access, you connect the BigQuery MCP server to Claude, ChatGPT, Cursor, and any MCP client through one gateway that routes, authenticates, and governs every BigQuery tool call against your policies.
Why MCPX
MCPX is Lunar.dev's MCP Gateway. It sits between your AI agents and your MCP servers as a single gateway for every tool call, routing, authenticating, and governing traffic against your policies. Connect BigQuery once and govern it everywhere: role-based access per agent with on-behalf-of attribution, real-time visibility, and an immutable audit trail of who did what, all deployable inside your own VPC.
Tools content
- list_dataset_ids · Read-only
List BigQuery dataset IDs in a Google Cloud project. - get_dataset_info · Read-only
Get metadata information about a BigQuery dataset. - list_table_ids · Read-only
List table ids in a BigQuery dataset. - get_table_info · Read-only
Get metadata information about a BigQuery table. - execute_sql_readonly · Read-only
Run a read-only SQL query in the project and return the result. - execute_sql · Read-only
Run a SQL query in the project and return the result.
Frequently asked questions
What is the BigQuery MCP server?
Run SQL queries and interact with Google BigQuery datasets. Through Lunar.dev MCPX, BigQuery connects to any MCP-compatible AI client behind a single governed gateway.
How do I connect BigQuery to MCPX?
Add the BigQuery server in the MCPX control plane or your app.yaml, then point your AI client at your MCPX gateway. MCPX handles OAuth and routes every BigQuery call through the gateway.
Is the BigQuery MCP server official?
Yes. BigQuery is an official, vendor-published MCP server, and MCPX governs it like any other server in your catalog.
What authentication does BigQuery use with MCPX?
BigQuery uses OAuth. MCPX enforces authentication at the gateway with token-based auth, OAuth, and role-based profiles, so you control which agents can invoke it.
How many tools does BigQuery expose in MCPX?
BigQuery exposes 5 tools. In MCPX you can enable or disable each tool per agent for least-privilege access.
