==================
/// MCP ///
/// MCP ///
==================
[server:online]
[protocol:ready]mcp-bigquery-server
by ergut
A Model Context Protocol (MCP) server that provides secure, read-only access to Google BigQuery so LLMs can run natural-language queries against your data.
101
26
Open SourceInstallation
1. Prerequisites
• Node.js ≥ 18
• A Google Cloud project that has BigQuery enabled
• A BigQuery service-account JSON key with at least bigquery.jobs.create and bigquery.tables.getData permissions on the datasets you wish to expose.
2. Acquire credentials
export GOOGLE_APPLICATION_CREDENTIALS=/absolute/path/to/key.json3. Install the server
git clone https://github.com/ergut/mcp-bigquery-server.git
cd mcp-bigquery-server
npm install --production
(or install globally from NPM)
npm install -g mcp-bigquery-server
4. Configure allowed datasets and server options
Create a config file (config.json):
{
"projectId": "your-gcp-project",
"allowedDatasets": ["project.dataset1", "project.dataset2"],
"port": 8080,
"auth": {
"mode": "bearer",
"tokens": ["<YOUR_API_TOKEN>"]
}
}
5. Start the MCP server
npx mcp-bigquery-server --config ./config.json
# or, if installed globally mcp-bigquery-server --config ./config.json
6. Verify
curl http://localhost:8080/health
→ {"status":"ok"}
The server is now ready to service MCP requests from LLM tooling.
Documentation
# Transform Your Data Analysis Workflow with BigQuery MCP Server + Augment Code
Stop switching between your IDE and BigQuery console just to understand your data. The BigQuery MCP server transforms Augment Code into a powerful data analysis companion that lets you query your company's datasets using natural language—all without leaving your coding environment.
## Seamless Data Integration in Your Development Flow
When you connect this MCP server to Augment Code, you're not just adding another tool—you're creating a unified development experience where code and data insights live side by side. Augment can now analyze your BigQuery tables, generate reports, and provide data-driven suggestions directly in your editor. Whether you're building a dashboard, optimizing database queries, or need to understand user behavior patterns, Augment becomes your intelligent data analyst that speaks SQL fluently.
**Real-world example**: Working on a user analytics feature? Simply ask Augment "What were our top 10 user acquisition channels last month?" and it will query your BigQuery data, analyze the results, and even suggest code improvements based on the data patterns it discovers. Need to validate a hypothesis about user behavior? Ask "Show me the average session duration by device type" and get instant insights that inform your next code iteration.
## Setup Your Data-Driven Development Environment
Add this to your Augment Code settings.json to unlock enterprise-grade data analysis capabilities:
```json
{
"mcpServers": {
"bigquery": {
"command": "npx",
"args": [
"-y",
"@ergut/mcp-bigquery-server",
"--project-id", "your-project-id",
"--location", "us-central1",
"--key-file", "/path/to/service-account-key.json"
]
}
}
}
```
Once configured, Augment Code gains the ability to explore your BigQuery schemas, understand your data structure, and run complex analytical queries—all through natural conversation. The server provides secure, read-only access with intelligent query limits, ensuring your data analysis enhances productivity without compromising security.License: MIT License
Updated 7/15/2025