Fork and restore from Managed ClickHouse® backups
Restore a Managed ClickHouse® service by forking it: the fork is a new service created from the backup of an existing service. The source service keeps running and is not modified.
List the available backups
Backups are part of the service description. List them with their names, dates and sizes:
exo dbaas show my-clickhouse -z ch-gva-2 --backupsFork the service
Create a new service with --clickhouse-fork-from set to the name of the source service. Pick a
plan with at least as many nodes as the source: startup-16 below matches a Startup source,
a Business source needs a Business or Premium plan.
exo dbaas create clickhouse startup-16 my-clickhouse-fork -z ch-gva-2 \
--clickhouse-fork-from my-clickhouse \
--clickhouse-ip-filter <your-ip>/32Watch the fork until the state is running, then connect to it and check your data:
exo dbaas show my-clickhouse-fork -z ch-gva-2 --output-template '{{ .State }}'Important
The fork is restored from a backup of the source service, not from its live state. By default the latest backup is used; data written to the source after that backup is not present in the fork.
To fork from an older daily backup instead, add --clickhouse-recovery-backup-name with one
of the backup names listed above:
exo dbaas create clickhouse startup-16 my-clickhouse-fork -z ch-gva-2 \
--clickhouse-fork-from my-clickhouse \
--clickhouse-recovery-backup-name 2026-08-04T11:34:26+00:00 \
--clickhouse-ip-filter <your-ip>/32The API validates the name and refuses the creation with Cannot find such backup to recover from. when it does not match an existing backup.
Important
You cannot fork Managed ClickHouse services to a fewer number of nodes. Reducing the number of nodes is only possible by switching the service plan from Business to Startup on a running service:
exo dbaas update my-clickhouse -z ch-gva-2 -f --plan startup-16See Resize a service. The generic scaling page describes the platform behavior.
Once the new fork service is running, you can set up your application’s connection settings to point to this new fork service.