Help us improve
Share bugs, ideas, or general feedback.
From role-database
Provides backup strategies and disaster recovery for PostgreSQL, MySQL, MongoDB, Redis with full/incremental/PITR options, verification scripts, and RPO/RTO planning. Use for implementing backups or troubleshooting recovery.
npx claudepluginhub rnavarych/alpha-engineer --plugin role-databaseHow this skill is triggered — by the user, by Claude, or both
Slash command
/role-database:backup-recoveryThis skill is limited to the following tools:
The summary Claude sees in its skill listing — used to decide when to auto-load this skill
Load from `references/` based on what's needed:
Guides PostgreSQL/MySQL backup and recovery: PITR via WAL archiving, physical/logical backups, RPO/RTO planning, S3/local storage.
Implements backup strategies for databases, filesystems, and cloud resources using tar, rsync, pg_dump, AWS S3. Automates scheduling, retention, encryption, verification, and disaster recovery.
Designs backup and disaster recovery plans with data asset inventory, RPO/RTO targets, tiered strategies for databases/storage/logs, integrity checks via SQL, verification schedules, and recovery runbooks.
Share bugs, ideas, or general feedback.
Load from references/ based on what's needed:
Backup types comparison (full/incremental/differential/continuous) with speed and storage tradeoffs. RPO/RTO planning tiers (critical/important/standard/archive) with strategies. PostgreSQL: pg_dump, pg_basebackup, pgBackRest config and commands, Barman. MySQL: mysqldump, XtraBackup (full + incremental + prepare + restore), MySQL Shell dump/load. MongoDB: mongodump with oplog, mongorestore with oplog replay, fsync lock for snapshots. Redis: RDB config, AOF config, hybrid mode recommendation. Load when: implementing backup for a specific database engine.
Automated restore testing bash script with row count comparison and alerting. Backup monitoring checklist (job alerts, size trends, WAL lag, disk space). Cloud-native backup services table (AWS Backup, Cloud SQL, Azure Backup, Atlas). Disaster recovery patterns comparison (backup/restore, pilot light, warm standby, multi-site active). Anti-patterns: untested backups, no encryption, single-region storage, missing retention policy. Load when: setting up backup verification, choosing DR patterns, or reviewing backup compliance.