bigquery-mcp/docker-compose.yml.example at main · aicayzer/bigquery-mcp · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
services:
  # BigQuery MCP Server - Single clean service supporting CLI-first architecture
  bigquery-mcp:
    build: .
    image: bigquery-mcp:latest
    container_name: bigquery-mcp
    command: ["python", "src/server.py", "--project", "your-project-id:*", "--billing-project", "your-billing-project"]
    volumes:
      - ./logs:/app/logs
      - ~/.config/gcloud:/home/mcpuser/.config/gcloud:ro
      # Optional: Mount config file for complex setups
      - ./config:/app/config:ro
    environment:
      - LOG_LEVEL=${LOG_LEVEL:-INFO}
      # Note: CLI arguments take precedence over environment variables
      - COMPACT_FORMAT=${COMPACT_FORMAT:-false}
      - BIGQUERY_BILLING_PROJECT=${BIGQUERY_BILLING_PROJECT:-}
    stdin_open: true
    tty: false

    # Example configurations for different use cases:

    # Simple usage (single project):
    # command: ["python", "src/server.py", "--project", "my-project:*", "--billing-project", "my-project"]

    # Enterprise usage (multiple projects):
    # command: [
    #   "python", "src/server.py",
    #   "--project", "analytics-prod:user_*,session_*",
    #   "--project", "logs-prod:application_*,system_*",
    #   "--project", "ml-dev:training_*,models_*",
    #   "--billing-project", "my-billing-project",
    #   "--log-level", "INFO",
    #   "--compact-format", "true",
    #   "--timeout", "300"
    # ]

    # Config file fallback (if no --project specified):
    # command: ["python", "src/server.py", "--config", "/app/config/config.yaml"]

# For development with additional debugging:
# Uncomment the following service for development usage
#  bigquery-mcp-dev:
#    build: .
#    image: bigquery-mcp-dev:latest
#    container_name: bigquery-mcp-dev
#    command: [
#      "python", "src/server.py",
#      "--project", "YOUR_DEV_PROJECT:*",
#      "--billing-project", "YOUR_DEV_PROJECT",
#      "--log-level", "DEBUG",
#      "--log-queries", "true",
#      "--log-results", "true"
#    ]
#    volumes:
#      - ./logs:/app/logs
#      - ~/.config/gcloud:/home/mcpuser/.config/gcloud:ro
#    environment:
#      - LOG_LEVEL=DEBUG
#    stdin_open: true
#    tty: false