Run SQL queries, list datasets and tables, inspect schemas, and export results from Google BigQuery — AI-native data warehouse access.
Use with AI AssistantsMCP
Connect Claude, Cursor, or any MCP-compatible client — then call tools directly
① Add This MCP Server
Paste into your AI client config — then all its tools are available instantly.
{
"mcpServers": {
"bigquery": {
"url": "https://mcp.aerostack.dev/s/aerostack/mcp-bigquery",
"headers": {
"Authorization": "Bearer YOUR_AEROSTACK_TOKEN"
}
}
}
}Replace YOUR_AEROSTACK_TOKEN with your API token from the dashboard.
② Call a Tool
Ask your AI assistant to call a specific tool, or send raw JSON-RPC:
Natural Language Prompt
“Use the _ping tool to verify bigquery connectivity by listing datasets. used internally by aerostack to validate credentials”
Using a Workspace?
Add this MCP to your Workspace — your team shares one token, secrets are stored securely, and every AI agent in the workspace can call it without per-user setup.
Run SQL queries, list datasets and tables, inspect schemas, and export results from Google BigQuery — AI-native data warehouse access.
Give your AI agents full access to Google BigQuery. Execute standard SQL with CTEs, joins, window functions. Browse datasets and tables, inspect column schemas, estimate query costs with dry runs, and track long-running jobs.
Live endpoint: https://mcp.aerostack.dev/s/aerostack/mcp-bigquery
| Tool | Description |
|---|---|
_ping | Verify BigQuery connectivity by listing datasets |
list_datasets | List all datasets with ID, location, and description |
list_tables | List tables in a dataset with type, row count, and size |
get_table_schema | Get full column schema — names, types, modes, nested fields |
query | Execute SQL query and return results (supports dry_run for cost estimation) |
get_job | Get status and stats of a BigQuery job by ID |
| Variable | Required | Description | How to Get |
|---|---|---|---|
GOOGLE_SERVICE_ACCOUNT_JSON | Yes | Full JSON key file content for a GCP service account with BigQuery access | console.cloud.google.com → IAM & Admin → Service Accounts → Create → Keys → Add Key → JSON |
GOOGLE_PROJECT_ID | Yes | Google Cloud project ID (e.g. "my-project-123") | console.cloud.google.com → Dashboard → Project info → Project ID |
Required roles:
BigQuery Data Viewer+BigQuery Job Userfor read-only. AddBigQuery Data Editorfor write operations.
GOOGLE_SERVICE_ACCOUNT_JSON (paste the full JSON) and GOOGLE_PROJECT_ID under Project → Secrets"List all datasets in my BigQuery project"
"Show me the schema of the events table in the analytics dataset"
"Run: SELECT user_id, COUNT(*) as count FROM analytics.events GROUP BY 1 ORDER BY 2 DESC LIMIT 20"
"How much would it cost to query the full orders table? Do a dry run first."
"Show me yesterday's top 10 products by revenue from the sales dataset"
curl -X POST https://mcp.aerostack.dev/s/aerostack/mcp-bigquery \
-H 'Content-Type: application/json' \
-H 'X-Mcp-Secret-GOOGLE-SERVICE-ACCOUNT-JSON: {"type":"service_account",...}' \
-H 'X-Mcp-Secret-GOOGLE-PROJECT-ID: my-project-123' \
-d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"query","arguments":{"sql":"SELECT 1 AS test"}}}'
MIT
Live Endpoint
https://mcp.aerostack.dev/s/aerostack/mcp-bigquery
Sub-50ms globally · Zero cold start
@aerostack
Pre-built functions for the most common MCP tool patterns. Clone, extend, and deploy.
by @aerostack
Discover and invoke any MCP, Function, or Skill published to the Aerostack marketplace — the universal AI capability hub.
by @aerostack
Search indexes, manage records, browse data, and configure ranking in Algolia — AI-native instant search access.
by @aerostack
Query documents, run AQL, traverse graphs, and manage collections in your ArangoDB database — AI-native multi-model database access.
by @aerostack
Post, schedule, and analyze social media across 13 platforms — Facebook, Instagram, X, LinkedIn, TikTok, Bluesky, Threads, Reddit, Pinterest, YouTube, Telegram, Snapchat, Google Business.
by @aerostack
Manage projects, to-dos, messages, schedules, and campfire chats in Basecamp — AI-native project management.
by @aerostack
Book meetings, check availability, and manage your entire scheduling workflow programmatically via Cal.com.
The Bigquery MCP gives Claude 5 tools covering datasets, tables, table schemas. Claude can read, create, update, and manage Bigquery data directly from a conversation.
Yes. The Bigquery MCP includes tools to list and retrieve datasets from your Bigquery account. Claude can filter, sort, and summarize datasets based on your instructions.
Yes. The Bigquery MCP uses the open Model Context Protocol standard, so it works in Claude, Cursor, Windsurf, and any other MCP-compatible AI tool. All 5 Bigquery tools are available everywhere you connect it — install once on Aerostack.
Yes. Aerostack hosts the Bigquery MCP with encrypted credential storage and per-account authentication. Your Bigquery credentials are never shared with Claude's conversation — they're used server-side only.