ActiveMCP Bigquery Server
A Model Context Protocol (MCP) server that provides secure, read-only access to BigQuery datasets. Enables Large Language Models (LLMs) to safely query and analyze data through a standardized interface.
Quick Answer
- 1. MCP Bigquery Server gives AI agents databases capabilities with 145 GitHub stars and a quality score of 71/99.
- 2. Install: Run
npx -y mcp-bigquery-serveror add the config to your MCP client. - 3. Runtime: npm — no authentication required.
- 4. Health: Actively maintained — last checked 7/29/2026.
Overview
Category: Databases
Runtime: npm
Install: npx -y mcp-bigquery-server
Auth: No auth required
Source: community
Stars: 145
Setup time: ~30 sec
What You Can Build
With the MCP Bigquery Server MCP server, your AI assistant can:
- Access databases functionality through natural language
- Use the server immediately with no API key setup
- Combine with other MCP servers for cross-tool automation workflows
- Run with npm for reliable, consistent deployments
Health Status
ActiveLast commit: 7/11/2026
Checked: 7/29/2026
Page updated: June 13, 2026
One-Click Install
Copy the snippet for your MCP client and paste it in.
Claude Desktop
Add to claude_desktop_config.json
{
"mcpServers": {
"mcp-bigquery-server": {
"command": "npx",
"args": [
"-y",
"mcp-bigquery-server"
],
"env": {}
}
}
}Cursor
Settings → MCP Servers → Add
{
"mcpServers": {
"mcp-bigquery-server": {
"command": "npx -y mcp-bigquery-server"
}
}
}Saves as .cursor/mcp.json in the download. Move it to your project root.
VS Code
Use with MCP extension
{
"mcpServers": {
"mcp-bigquery-server": {
"command": "npx -y mcp-bigquery-server"
}
}
}SDK & Code Integration Examples
Connect to MCP Bigquery Server programmatically using TypeScript or Python MCP SDKs.
import { Client } from "@modelcontextprotocol/sdk/client/index.js";
import { StdioClientTransport } from "@modelcontextprotocol/sdk/client/stdio.js";
// Initialize MCP Bigquery Server MCP client transport
const transport = new StdioClientTransport({
command: "npx",
args: ["-y","mcp-bigquery-server"],
});
const client = new Client(
{ name: "mcp-app-client", version: "1.0.0" },
{ capabilities: { tools: {} } }
);
async function connectAndRun() {
await client.connect(transport);
const tools = await client.listTools();
console.log("Connected to MCP Bigquery Server. Available tools:", tools);
}
connectAndRun().catch(console.error);MCP Server Configuration
Add this to your claude_desktop_config.json
{
"mcpServers": {
"mcp-bigquery-server": {
"command": "npx",
"args": ["-y","mcp-bigquery-server"],
"env": {}
}
}
}Topics
Error Resolution & Troubleshooting Matrix
Common JSON-RPC protocol error codes and environment troubleshooting for MCP Bigquery Server.
-32600 (Invalid Request)Cause: Malformed JSON-RPC payload sent to server
Resolution: Verify MCP client payload adheres to JSON-RPC 2.0 specs.
-32601 (Method Not Found)Cause: Requested tool or resource method does not exist
Resolution: Call list_tools() to inspect supported tool names.
-32602 (Invalid Params)Cause: Missing or invalid tool arguments
Resolution: Check argument schema types against tool definition.
-32603 (Internal Error)Cause: Unhandled execution exception inside server process
Resolution: Inspect process stderr logs or check API key credentials.
AUTH_KEY_MISSINGCause: Required environment variable not set in MCP config
Resolution: Define required API key under 'env' object in claude_desktop_config.json.
STDIO_PIPE_CLOSEDCause: Server process crashed on startup
Resolution: Run install command manually in terminal to inspect error output.
Quality Score
Automated quality ranking of maintaining source repository.
Own this server?
Claim your listing to update description, links, and category — and get a verified badge.
Claim this listing →Similar MCP Servers
Other servers in the Databases category.
PostgreSQL MCP Server
MCP server for PostgreSQL databases — query tables, inspect schemas, run migrations via AI.
SQLite MCP Server
MCP server for SQLite databases — query, analyze, and manage SQLite databases through AI.
Supabase MCP Server
MCP server for Supabase — manage databases, auth, storage, and edge functions.
Redis MCP Server
MCP server for Redis — manage caches, queues, and key-value stores through AI.