ergut_mcp-bigquery-server

ergut_mcp-bigquery-server

0
databasesai_chatbot

The BigQuery MCP Server connects LLMs like Claude with BigQuery datasets, translating natural language queries into secure SQL interactions. It serves as an intermediate communication layer, promoting efficient data interaction without manual SQL query writing.

BigQuery MCP Server

What is this? 🤔

This project is a server that enables LLMs like Claude to interface directly with BigQuery data. It functions as a translator between AI assistants and databases, allowing secure and efficient interactions.

How Does It Work? 🛠️

  • Utilizes the Model Context Protocol (MCP) to facilitate AI-database communication.
  • Developer preview available for Claude Desktop.

What Can It Do? 📊

  • Translates natural language queries into SQL.
  • Accesses both tables and materialized views.
  • Provides secure, read-only data interaction.

Quick Start 🚀

Prerequisites

  • Node.js 14 or higher
  • Google Cloud project with BigQuery enabled
  • Claude Desktop

Installation Options

  • Quick Install via Smithery: Automated installation for Claude Desktop.
  • Manual Setup: Requires Google Cloud authentication and configuration in Claude Desktop.

Current Limitations ⚠️

  • MCP support is limited to Claude Desktop.
  • Local MCP server connections only.
  • 1GB query processing limit.