Your Brand

Database backup

Create a backup of PostgreSQL (pg_dump) or ClickHouse. S3 only: backups-dev/ in dev, backups/ in prod.

Database type

PostgreSQL

ClickHouse (full backup)

PostgreSQL connection string

Save path

Storage: backups/myproject/{timestamp}.zip (S3: backups-dev/ in dev, backups/ in prod). Cannot be empty.

Backup type

Full — schema and data (default)

Schema only — DDL only, no data

Data only — data only, schema must exist

Restore

Restore the latest backup (by timestamp) from S3 (myproject). backups-dev/ in dev, backups/ in prod. PostgreSQL: .zip with backup.sql. ClickHouse: native format.

Restore type

PostgreSQL

ClickHouse

Target PostgreSQL connection string

Save path

Same path used when creating the backup: backups/myproject/{timestamp}.zip

Nuke database

Drop all schema and data in the target database. Leaves it as default empty Postgres (public schema dropped and recreated). This cannot be undone.

PostgreSQL connection string

Run custom SQL

Execute custom SQL against a PostgreSQL or ClickHouse database. Output is shown below.

Database type

PostgreSQL

ClickHouse

PostgreSQL connection string

SQL

Scheduled backups

Add jobs to run pg_dump on a cron schedule. The server loads jobs on startup and refreshes from the database about every 30 seconds.

Type	Connection	Save path	Schedule	Timezone	Max backups	Run on start	Actions
`postgresql`	postgres://p…postgres	`dbtools`	`0 3 * * *`	UTC	10	No