database-backup-restore
Installation
SKILL.md
Database Backup & Restore
Use this skill when
- Choosing backup strategy (full, incremental, PITR)
- Testing restore processes
- Setting retention and RTO/RPO targets
Do not use this skill when
- Transient data stores (caches, queues)
- Application-level concerns
Instructions
- Define RPO (data loss) and RTO (recovery time) targets.
- Back up incrementally with regular full backups; use PITR where available.
- Encrypt backups and store off-site/away from the DB.
- Test restores on a schedule; untested backups are fiction.
- Document the restore runbook and run periodic drills.
- Protect backup keys and access paths from ransomware.
- Verify backup integrity with automated health checks.