mcp-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.

GitHub Stars

120

User Rating

Not Rated

Favorites

0

Views

63

Forks

28

Issues

7

Installation
Difficulty
Beginner
Estimated Time
5-10 minutes

Installation

Installation

Prerequisites

Please specify required software and versions:
Node.js: 14 or higher
Google Cloud project: BigQuery enabled
Google Cloud CLI or service account key
Claude Desktop: Currently the only supported LLM interface

Installation Steps

1. Quick Install via Smithery (Recommended)

Run the following command in your terminal:
bash
npx @smithery/cli install @ergut/mcp-bigquery-server --client claude

2. Manual Setup

1Authenticate with Google Cloud (choose one method):
- Using Google Cloud CLI (great for development):
bash
gcloud auth application-default login
- Using a service account (recommended for production):
bash

Save your service account key file and use --key-file parameter

2Add to your Claude Desktop config
Edit claude_desktop_config.json to add:
json
{
  "mcpServers": {
    "mcp-bigquery-server": {
      "command": "node",
      "args": ["path/to/server.js"]
    }
  }
}

3. Start Server

bash
npm start

Troubleshooting

Common Issues

Issue: Server won't start Solution: Check Node.js version and reinstall dependencies. Issue: Not recognized by Claude Desktop Solution: Verify configuration file path and syntax.

Additional Resources