BigQuery MCP 服务器

claude mcp add bigquery-aicayzer --env PROJECT_PATTERN='<PROJECT_PATTERN>' --env BILLING_PROJECT='<BILLING_PROJECT>' -- python src/server.py --project '{{config.PROJECT_PATTERN}}' --billing-project '{{config.BILLING_PROJECT}}'

~/.codex/config.toml

[mcp_servers.bigquery-aicayzer]
command = "python"
args = ["src/server.py", "--project", "{{config.PROJECT_PATTERN}}", "--billing-project", "{{config.BILLING_PROJECT}}"]
env = { PROJECT_PATTERN = "<PROJECT_PATTERN>", BILLING_PROJECT = "<BILLING_PROJECT>" }

# codex mcp add bigquery-aicayzer --env PROJECT_PATTERN='<PROJECT_PATTERN>' --env BILLING_PROJECT='<BILLING_PROJECT>' -- python src/server.py --project '{{config.PROJECT_PATTERN}}' --billing-project '{{config.BILLING_PROJECT}}'

~/.cursor/mcp.json

{
  "mcpServers": {
    "bigquery-aicayzer": {
      "command": "python",
      "args": [
        "src/server.py",
        "--project",
        "{{config.PROJECT_PATTERN}}",
        "--billing-project",
        "{{config.BILLING_PROJECT}}"
      ],
      "env": {
        "PROJECT_PATTERN": "<PROJECT_PATTERN>",
        "BILLING_PROJECT": "<BILLING_PROJECT>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "bigquery-aicayzer": {
      "type": "stdio",
      "command": "python",
      "args": [
        "src/server.py",
        "--project",
        "{{config.PROJECT_PATTERN}}",
        "--billing-project",
        "{{config.BILLING_PROJECT}}"
      ],
      "env": {
        "PROJECT_PATTERN": "<PROJECT_PATTERN>",
        "BILLING_PROJECT": "<BILLING_PROJECT>"
      }
    }
  }
}

~/.gemini/settings.json

{
  "mcpServers": {
    "bigquery-aicayzer": {
      "command": "python",
      "args": [
        "src/server.py",
        "--project",
        "{{config.PROJECT_PATTERN}}",
        "--billing-project",
        "{{config.BILLING_PROJECT}}"
      ],
      "env": {
        "PROJECT_PATTERN": "<PROJECT_PATTERN>",
        "BILLING_PROJECT": "<BILLING_PROJECT>"
      }
    }
  }
}

claude_desktop_config.json

{
  "mcpServers": {
    "bigquery-aicayzer": {
      "command": "python",
      "args": [
        "src/server.py",
        "--project",
        "{{config.PROJECT_PATTERN}}",
        "--billing-project",
        "{{config.BILLING_PROJECT}}"
      ],
      "env": {
        "PROJECT_PATTERN": "<PROJECT_PATTERN>",
        "BILLING_PROJECT": "<BILLING_PROJECT>"
      }
    }
  }
}

.trae/mcp.json

{
  "mcpServers": {
    "bigquery-aicayzer": {
      "command": "python",
      "args": [
        "src/server.py",
        "--project",
        "{{config.PROJECT_PATTERN}}",
        "--billing-project",
        "{{config.BILLING_PROJECT}}"
      ],
      "env": {
        "PROJECT_PATTERN": "<PROJECT_PATTERN>",
        "BILLING_PROJECT": "<BILLING_PROJECT>"
      }
    }
  }
}