Set it once. Sleep well. Restore in minutes.

SQLBackup turns a fragile pile of cron scripts into one dependable agent. Here's the whole flow — and you can play with it right on this page.

STEP 01

Add your databases

Tell SQLBackup how to reach each database. Run a one-click connection test. Keep passwords in environment variables, never in the config file.

5 enginesTest firstEnv secrets
STEP 02

Define jobs

A job ties a database to one or more destinations, a cron schedule, a backup type, and retention rules. Toggle compression and encryption per job.

CronTypeRetention
STEP 03

Run the agent

Start SQLBackup and it runs continuously — firing each job on schedule, shipping offsite, pruning old copies, logging every result, and emailing you if anything fails.

ContinuousAlertsHistory

What happens inside a single backup

Click each stage. Every backup streams through these four steps — nothing is ever fully loaded into memory.

1 · Dump
native tools
2 · Compress
streaming gzip
3 · Encrypt
AES-256-GCM
4 · Ship
local · S3 · SFTP

Build a backup config — live

Make a few choices and watch the config.yaml SQLBackup would use update in real time. No install required.

PostgreSQL MySQL MariaDB SQL Server MongoDB
Local / NAS Amazon S3 Wasabi SFTP
Nightly 2 AM Hourly Every 30 min Weekly Sun
Compress (gzip) Encrypt (AES-256)
7 14 30 90
config.yaml

        

This is a real, valid SQLBackup config. Save it as config.yaml, set DB_PASSWORD in your environment, and run sqlbackup run.

The part that actually matters

A backup you can't restore is just wasted disk. With SQLBackup, recovery is one command — here's every step it runs.

Restore: analytics
from Amazon S3
Locate backupfind the key in the destination
Downloadpull the encrypted object
Decrypt & verifyAES-256-GCM authentication
Decompressrestore the original dump
Restore databaserebuild into analytics_restored

One command does all of it

No juggling openssl, gunzip, and psql by hand at the worst possible moment. SQLBackup handles the whole chain and restores into a database you name — so you can verify before promoting it.

# restore the latest analytics backup from S3 sqlbackup restore --job pg_nightly_full \ --from amazon_s3 \ --database analytics_restored

Tip: practice restores on a schedule. An untested backup isn't a backup yet.

Ready to set it and forget it?

Install SQLBackup, add a job, and your databases are protected by tonight.

Start free trial Read the Docs