BigQuery MCP ServerServer

ergut

BigQueryData AccessAI Integration

Loading subscription status...

💡 Description

This server allows an LLM like Claude to access BigQuery data directly. It serves as a friendly translator between AI assistants and databases, enabling secure and efficient interactions.

📝 JSON Entries

{
  "mcpServers": [
    {
      "bigquery": {
        "args": [
          "-y",
          "@ergut/mcp-bigquery-server",
          "--project-id",
          "your-project-id",
          "--location",
          "us-central1"
        ],
        "command": "npx"
      }
    }
  ]
}

🛠️ Tools

query

⚡ Features

Run SQL queries with natural language questions.
Access both tables and materialized views within datasets.
Explore dataset schemas clearly labeled with resource types.
Analyze data within secure limits (default query limit is 1 GB).
Maintain data security with read-only access.

💬 Example Queries

What were our top 10 customers last month?
List all the tables in the BigQuery dataset.