BigQuery MCP ServerServer

takuya0206
GitHub
BigQuerySQLCloud

Loading subscription status...

💡 Description

This server enables interaction with Google BigQuery to execute read-only SQL queries, list datasets and tables, inspect table schemas, retrieve sample data, and estimate query costs, allowing AI agents to analyze data stored in BigQuery.

📝 JSON Entries

{
  "mcpServers": [
    {
      "BigQuery": {
        "env": {
          "GOOGLE_APPLICATION_CREDENTIALS": "/path/to/service-account-key.json"
        },
        "args": [
          "--project-id",
          "your-project-id",
          "--location",
          "asia-northeast1",
          "--max-results",
          "1000",
          "--max-bytes-billed",
          "500000000000"
        ],
        "command": "/path/to/dist/bigquery-mcp-server"
      }
    }
  ]
}

🛠️ Tools

Execute read-only (SELECT) BigQuery SQL queriesList all datasetsList all tables in a datasetGet table schema and sample dataDry run query to check validity and estimate costs

Features

  • Authentication and connection management
  • Read-only access to BigQuery
  • Cost estimation for queries

💬 Example Queries

  • SELECT * FROM `project.dataset.table` LIMIT 10
  • List all datasets in the project
  • Get information for table 'your_table' in dataset 'your_dataset'