BigQuery MCP ServerServer

ergut
GitHub
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.