MCP Bigquery Server

🚀 BigQuery MCP Server

This is a server that enables your large language models (such as Claude) to directly communicate with your BigQuery data! It acts like a friendly translator between the AI assistant and the database, ensuring secure and efficient communication.

🚀 Quick Start

This server allows your large language model (e.g., Claude) to directly interact with your BigQuery data! It's like a friendly translator sitting between the AI assistant and the database, ensuring they can communicate securely and efficiently.

Quick Example

You: "Who were the top 10 customers last month?"
Claude: *Queries your BigQuery database and gives you the answer in plain English*

No more manual SQL query writing - just talk to the model!

📦 Installation

1. Clone the Repository

git clone https://github.com/ergut/mcp-bigquery-server
cd mcp-bigquery-server
npm install

2. Build the Project

npm run build

🔧 Configuration

Add the following content to the claudius.json configuration file:

{
  "experimental": {
    "mcpServers": [
      {
        "id": "bigquery",
        "name": "BigQuery MCP Server",
        "description": "MCP server connecting to Google BigQuery",
        "enabled": true,
        "config": {
          "projectId": "your-gcp-project-id",
          "location": "asia-east1",
          "keyFile": "/path/to/service-account-key.json"
        }
      }
    ]
  }
}

💻 Usage Examples

Basic Usage

To use this server in Claude:

claudius shell --mcp bigquery

✨ Features

• Supports connecting to BigQuery via the MCP protocol.
• Provides powerful query capabilities, including data extraction and analysis.
• Integrates Google's BigQuery client library.
• Is compatible with Claude's experimental MCP interface.

⚠️ Important Note

⚠️ Important Note

• Currently, it only supports Claude Desktop (Developer Preview).
• The connection is limited to the locally running MCP server.
• Queries have a 1GB processing limit and are read - only.

🛠️ Project Background

Sponsored by OREDATA, aiming to promote the integrated innovation of big data and AI.

📄 License

MIT License - For detailed information, please refer to the LICENSE file.

✍️ Author

Salih Ergüt