MCP BigQuery Server
MCP BigQuery Server is an MCP server that provides secure, read-only access to BigQuery datasets. It has 148 GitHub stars, is released under the MIT license and runs locally with npx -y @ergut/mcp-bigquery-server. It works with Claude Desktop, Claude Code, Cursor and VS Code.
github.com/ergut/mcp-bigquery-server (opens in a new tab)
Data as of from the GitHub API; description from the project's repository. Report an error
Install MCP BigQuery Server
Generated from the server's published package. Replace your-value with your own values.
Claude Desktop
{
"mcpServers": {
"mcp-bigquery-server": {
"command": "npx",
"args": [
"-y",
"@ergut/mcp-bigquery-server"
]
}
}
}Settings > Developer > Edit Config. macOS: ~/Library/Application Support/Claude/, Windows: %APPDATA%\Claude\. Restart Claude Desktop afterwards.
Claude Code
claude mcp add --transport stdio mcp-bigquery-server -- npx -y @ergut/mcp-bigquery-serverCursor
{
"mcpServers": {
"mcp-bigquery-server": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@ergut/mcp-bigquery-server"
]
}
}
}Project file; use ~/.cursor/mcp.json to enable it in every project.
VS Code
{
"servers": {
"mcp-bigquery-server": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@ergut/mcp-bigquery-server"
]
}
}
}Config formats checked against the official docs on Oct 7, 2026: modelcontextprotocol.io (opens in a new tab), code.claude.com (opens in a new tab), cursor.com (opens in a new tab), code.visualstudio.com (opens in a new tab).
About MCP BigQuery Server
This is a server that lets your LLMs (like Claude) talk directly to your BigQuery data — read-only, with no ability to mutate your warehouse. Think of it as a friendly translator that sits between your AI assistant and your database, making sure they can chat securely and efficiently.
- bigquery
- google-cloud
- mcp
- mcp-servers
- model-context-protocol
- sql
Similar MCP servers
More data & analytics MCP servers
Betterlytics
betterlytics/betterlytics
Query your Betterlytics web analytics from AI agents: traffic, funnels, journeys, errors, uptime.
Active · last commit Oct 25, 2026
OfficialData & analyticsTypeScriptEveryrow MCP Server
futuresearch/futuresearch-python
Give your AI a research team. Forecast, score, classify, or research every row of a dataset.
Active · last commit Oct 13, 2026
OfficialData & analyticsPythonMuxinc MCP Server
muxinc/mux-ts
The official MCP Server for the Mux API.
Active · last commit Oct 5, 2026
OfficialData & analyticsTypeScriptMarkifact - Ads & Analytics
markifact/markifact-mcp
AI marketing agent for Google Ads, Meta, GA4, TikTok, LinkedIn, Shopify, HubSpot and more.
Maintained · last commit Oct 4, 2026
OfficialData & analyticsShellGoogle Analytics MCP
surendranb/google-analytics-mcp
GA4 MCP server for AI agents: schema discovery, server-side aggregation, analysis-ready defaults.
Active · last commit Oct 25, 2026
Data & analyticsPythonSpytrend
Spytrend/spytrend-mcp
Analytics, advertising: Facebook/Meta, TikTok, competitor ads.
Too new to judge · created Sep 1, 2026
OfficialData & analyticsPython
How do I install the MCP BigQuery Server MCP server?
Add the command npx -y @ergut/mcp-bigquery-server to your MCP client: put it in claude_desktop_config.json for Claude Desktop, run claude mcp add for Claude Code, or add it to .cursor/mcp.json (Cursor) or .vscode/mcp.json (VS Code). The snippets on this page are ready to paste.
Is MCP BigQuery Server free?
The server is open source under the MIT license, so running it is free. It does not declare any required API key.
Is MCP BigQuery Server actively maintained?
The most recent commit was on May 22, 2026. The latest release is v1.0.3, published Apr 3, 2025. appsgit only lists MCP servers with a commit in the last six months.