BigQuery MCP Server
@MCP-Mirror
About BigQuery MCP Server
Mirror of
Basic information
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"ergut_mcp-bigquery-server": {
"command": "npx",
"args": [
"@smithery/cli",
"install",
"@ergut/mcp-bigquery-server",
"--client",
"claude"
]
}
}
}Tools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
What is BigQuery MCP Server?
It is a server that connects LLMs like Claude to BigQuery via the Model Context Protocol, allowing natural language queries to databases. It acts as a secure translator between AI assistants and BigQuery data.
How to use BigQuery MCP Server?
Install via Smithery by running npx @smithery/cli install @ergut/mcp-bigquery-server --client claude or manually by adding a configuration to Claude Desktop's claude_desktop_config.json. Provide your Google Cloud project ID, location (defaults to us-central1), and optionally a service account key file. Then start asking questions in Claude Desktop.
Key features of BigQuery MCP Server
- Translate natural language questions into SQL queries.
- Access both tables and materialized views in datasets.
- Explore dataset schemas with labeled resource types.
- Enforce a 1GB query limit for safe analysis.
- Read-only access ensures data security.
- Integrates with MCP, available in Claude Desktop.
Use cases of BigQuery MCP Server
- Ask business questions like "top 10 customers last month" without writing SQL.
- Explore database schema and tables through natural language.
- Generate ad-hoc reports by chatting with your data.
- Enable non-technical users to query BigQuery.
FAQ from BigQuery MCP Server
What LLMs does this server work with?
Currently only Claude Desktop in developer preview.
What are the prerequisites?
Node.js 14+, a Google Cloud project with BigQuery enabled, and either Google Cloud CLI or a service account key.
How does authentication work?
You can use Google Cloud CLI (gcloud auth application-default login) for development or supply a service account key file with --key-file for production.
Is the data accessed read-only?
Yes, queries are read-only with a default 1GB processing limit
More Databases MCP servers
PostgreSQL Model Context Protocol (PG-MCP) Server
stuzero
mcp-server-qdrant: A Qdrant MCP server
qdrantAn official Qdrant Model Context Protocol (MCP) server implementation
MySQL MCP Server
designcomputerA Model Context Protocol (MCP) server that enables secure interaction with MySQL databases
Elasticsearch MCP Server
elastic
mcp_mysql_server
wenb1n-devModel Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展
Comments