ClickHouse CLI

curl https://clickhouse.com/cli | sh

clickhousectl cloud auth

export CLICKHOUSE_CLOUD_API_KEY=your-key
export CLICKHOUSE_CLOUD_API_SECRET=your-secret

# 서비스 목록 조회
clickhousectl cloud service list

# 서비스 생성
clickhousectl cloud service create --name my-service \
  --provider aws \
  --region us-east-1

# 서비스 상세 정보 조회
clickhousectl cloud service get <service-id>

# 서비스 스케일 조정
clickhousectl cloud service scale <service-id> \
  --min-replica-memory-gb 24 \
  --max-replica-memory-gb 48 \
  --num-replicas 3

# 서비스 시작/중지
clickhousectl cloud service start <service-id>
clickhousectl cloud service stop <service-id>

# 서비스 삭제
clickhousectl cloud service delete <service-id>

# Postgres 서비스 목록 조회
clickhousectl cloud postgres list

# Postgres 서비스 생성
clickhousectl cloud postgres create \
  --name my-pg \
  --region us-east-1 \
  --size c6gd.xlarge \
  --pg-version 18

# 서비스 상세 정보 조회
clickhousectl cloud postgres get <pg-id>

# 서비스 업데이트
clickhousectl cloud postgres update <pg-id> --size c6gd.2xlarge --add-tag env=prod

# 비밀번호 재설정
clickhousectl cloud postgres reset-password <pg-id> --generate

# 읽기 레플리카 및 특정 시점 복원
clickhousectl cloud postgres read-replica create <pg-id> --name replica-1
clickhousectl cloud postgres restore <pg-id> --name restored --restore-target 2026-04-16T12:00:00Z

# 서비스 삭제
clickhousectl cloud postgres delete <pg-id>

clickhousectl cloud org list
clickhousectl cloud org get <org-id>

clickhousectl cloud key list
clickhousectl cloud key create --name ci-key --role-id <role-id>
clickhousectl cloud key delete <key-id>

clickhousectl cloud member list
clickhousectl cloud invitation create --email dev@example.com --role-id <role-id>

clickhousectl cloud backup list <service-id>
clickhousectl cloud backup get <service-id> <backup-id>

clickhousectl cloud --json service list