ClickHouse 22.x → 25.x · self-hosted & ClickHouse Cloud
Desktop-based applictaion to automate ClickHouse database backup to S3 compatible storage, OneDrive, Google Drive, Cloudflare R2, etc. Download Cloudhouse Backup tool and try for free.
The ClickHouse backup tool is a desktop application, not a hosted service. It runs on your machine and writes each backup straight to the storage you picked. Nobody charges you per gigabyte, and no copy of your ClickHouse data ever sits on somebody else’s server.
The ClickHouse Backup Tool complete the process in a few simple steps. Connect your HTTP, select location to save backup, set the plan and click Save & Run now. The software create automate ClickHouse database backup at your selected location on every run.
Everything you need to back up ClickHouse databases automatically and restore them anywhere.
ClickHouse Backup Tool software runs everytime when you turn on your system. It will start taking backup automatically. Schedule the backup plan once, and the software will automate backup at your desired location.
Rows are exported with SELECT FORMAT Native, ClickHouse’s own compact binary encoding. Decimal, LowCardinality, Nullable, Array, Map, DateTime64 and enums come back exactly as they were where CSV or JSON would quietly flatten them.
A backup should contain more than table rows. The ClickHouse backup tool captures each table's CREATE statement along with its data, helping preserve important settings such as engines, sorting keys partitions, Codecs and TTL rules during restoration.
ClickHouse Cloud database can be backup Just like self-hosted installations. Enter the connection details from your ClickHouse Cloud console, enable HTTPS, use port 8443 and provide the required password.
Internal databases such as system and information_schema are excluded automatically. These databases contain ClickHouse own system information and are not intended to be restored as part of a regular data backup.
Choose when backspace Should run and create a schedule That match your workload. Set daily, weekly, monthly or yearly backup cycles. The tool will create automate ClickHouse database backup and define how many copies to retain. Older backups are removed automatically according to your retention settings.
Backup ClickHouse database to local drive or cloud storage. Supported destination include your PC, NAS, Onedrive Amazon S3, Wasabi, Backblaze B2, Cloudflare R2, MinIO, SFTP or FTP. Save ClickHouse backups to a location that suits your setup. You can also save backup copies at multiple locations for extra protection.
Backup files are compressed while being processed to reduce their size the protected with AES-256-GCM encryption. This helps save storage space while keeping sensitive analytics data protected at its destination.
If you manage multiple database systems then you do not need separate backup solutions for each one. The SQL Backup Tool also support other database which make of a convenient all-in-one backup solution for different database environments.
Restoring a ClickHouse database backup is straightforward. The app guides you through four easy steps: select the backup job, choose the backup version you want to restore, decide where and how to restore it and review your choices before starting. The ClickHouse backup tool downloads the file, decrypts it, decompresses it, recreates each table from its stored DDL and streams the rows back with INSERT FORMAT Native into the original database or a new one, on any ClickHouse server you can reach over HTTP. Press play to watch every step.
Restoring into a fresh database is the safest rehearsal: create events_test, restore into it and query it side by side with production before you touch anything live.
| Capability | Other Tools | Prapl SQL Backup Tool |
|---|---|---|
| Backup Automation | Require manual setup | Automatically Scheduled |
| Deployment Support | Limited | Self-hosted, Docker, Kubernetes, VMs & ClickHouse Cloud — HTTP only |
| Storage Destination | Limited storage options | Local/NAS, OneDrive, S3, Wasabi, Backblaze, R2, MinIO, SFTP & FTP |
| Data security | Good | AES-256 before the file leaves your PC |
| Backup Compression | Supported but limited | Yes |
| Backup Monitoring | No | Dashboard, email & cloud alerts |
| Setup Process | Complex | Simple wizard, four steps |
| You hold the keys | No | Always |
| Storage cost | Often rented per GB | Your own storage · no per-GB fee |
.chdump) holding each table’s SHOW CREATE TABLE DDL followed by its rows in Native formatAES-256-GCM, key via scrypt, per-file salt, per-chunk nonce · secrets in the Windows Credential ManagerOne flat price covers every engine on the machine. Explore the others:
Create a backup of your ClickHouse data and save it to local or cloud storage. Download the ClickHouse Backup Tool and use every feature free for 15 days — no credit card required. If it fits, subscribe for just $9/month with a 14-day money-back guarantee.
