Agent skill
backup-recovery
Define RPO/RTO, implement PITR/Snapshots, and test restores.
Install this agent skill to your Project
npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/other/other/security-andreibesleaga-gabbe-2
SKILL.md
backup-recovery Skill
"A backup is not a backup until you have successfully restored from it."
1. Define Objectives
- RPO (Recovery Point Objective): Max data loss. (e.g., "1 hour", "5 minutes", "0 seconds").
- RTO (Recovery Time Objective): Max downtime. (e.g., "4 hours", "30 minutes").
2. Strategies
- Point-In-Time Recovery (PITR): Archive WAL/Binlogs to replay transactions up to a specific second. (Critical for RPO ~0).
- Snapshot: Daily/Hourly full disk copy. Low impact, slower restore.
- Logical Dump:
pg_dump/mysqldump. Portable, slow for large data.
3. Storage & Retention
- Immutability: Backups must be Read-Only (WORM) to prevent Ransomware encryption.
- Off-site: Replicate to a different region/cloud provider (3-2-1 Rule).
- Retention: Keep Dailies for 7 days, Weeklies for 1 month, Monthlies for 1 year.
4. Testing (The Golden Rule)
- Automated Restore Drill: Weekly CI job that:
- Spins up a fresh DB.
- Pulls the latest backup.
- Restores it.
- Runs integrity check (
SELECT count(*) ...). - Reports success/failure to Slack.
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
Didn't find tool you were looking for?