Create, list, and start/stop a ClickHouse Cloud service programmatically via the ClickHouse Cloud REST API.

Documented steps

1. Create an API key in the ClickHouse Cloud console under the API Keys page, choosing a role (developer = read-only, admin = full read/write) and optionally an IP allowlist; copy the Key ID and Key secret shown — they are displayed only once.
2. All requests use base URL `https://api.clickhouse.cloud/v1` and are authenticated with HTTP Basic Authentication, using the Key ID as the username and Key secret as the password, e.g. `curl --user $KEY_ID:$KEY_SECRET https://api.clickhouse.cloud/v1/organizations`.
3. List services in an organization: `curl --request GET --url https://api.clickhouse.cloud/v1/organizations/{organizationId}/services --header 'Authorization: Basic <base64(KEY_ID:KEY_SECRET)>'` (or `--user $KEY_ID:$KEY_SECRET`).
4. Create a new service: `curl --request POST --url https://api.clickhouse.cloud/v1/organizations/{organizationId}/services --user $KEY_ID:$KEY_SECRET --header 'Content-Type: application/json' --data '{"name":"my-service","minTotalMemoryGb":48,"maxTotalMemoryGb":360}'` — this creates the service asynchronously and returns its current state plus a generated password.
5. Start, stop, or wake a service by updating its state: `curl --request PATCH --url https://api.clickhouse.cloud/v1/organizations/{organizationId}/services/{serviceId}/state --user $KEY_ID:$KEY_SECRET --header 'Content-Type: application/json' --data '{"command":"stop"}'` (command is one of start, stop, awake).
6. Fetch a single service's details: `curl --request GET --url https://api.clickhouse.cloud/v1/organizations/{organizationId}/services/{serviceId} --user $KEY_ID:$KEY_SECRET`.
7. Delete a service once it is stopped: `curl --request DELETE --url https://api.clickhouse.cloud/v1/organizations/{organizationId}/services/{serviceId} --user $KEY_ID:$KEY_SECRET`.
8. Reference: https://clickhouse.com/docs/cloud/manage/openapi