OpsVault

OpsVault is a single-binary CLI tool that automates MySQL and PostgreSQL database backups on Linux servers. It dumps your databases, compresses them with gzip, uploads them to any remote storage via rclone, and runs as a systemd service — all configured from a single YAML file.

curl -fsSL https://get.opsvault.dev | sudo bash

Features

• MySQL & PostgreSQL — uses mysqldump and pg_dump under the hood
• Any remote storage — Google Drive, S3, Backblaze B2, SFTP, and anything else rclone supports
• Cron scheduling — standard 5-field cron expressions
• systemd integration — installs and manages itself as a service
• Notifications — Telegram bot and SMTP email
• Retention policies — keep last N backups or delete files older than N days, both local and remote
• Backup history — persistent success/failure log per database, queryable with backup history
• Restore — restore any .sql.gz backup to its database with a single command
• Single static binary — no runtime dependencies, no Docker required

How it works

opsvault scheduler run  (started by systemd)
        │
        ▼  (on schedule, e.g. every night at 02:00)
  backup.RunAll()
        │
        ├─ mysqldump / pg_dump  →  gzip  →  /var/backups/opsvault/
        │
        ├─ rclone copy  →  remote storage
        │
        ├─ retention cleanup (local + remote)
        │
        └─ Telegram / email notification

Quick navigation

☕ Buy me a coffee

Whether you use this project, have learned something from it, or just like it, please consider supporting it by buying me a coffee — so I can dedicate more time to open-source projects like this.