skills.rest
zinohome
zinohomeCOMMUNITY
Explore all skills by this author →
GitHub

backup-restore-runbook-generator

Generate backup and restore scripts, validation checks, and disaster recovery runbooks for databases.

1|Updated Nov 6, 2025
Search Tags:#automation#database#disaster recovery#restore#backup#business continuity#runbook
One-click install
npx skills add https://github.com/zinohome/CozyChat --skill backup-restore-runbook-generator
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: backup-restore-runbook-generator
Source: https://github.com/zinohome/CozyChat/tree/main/.claude/skills/backup-restore-runbook-generator
Command: npx skills add https://github.com/zinohome/CozyChat --skill backup-restore-runbook-generator

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires aws-sdk, psql, pg_dump, pg_restore, pg_basebackup, mysqldump, curl, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the creation of comprehensive disaster recovery procedures, including backup scripts, restore processes, validation checks, and role assignments, ensuring business continuity.

Core Features & Use Cases

  • Automated Backup Scripts: Generates scripts for full, incremental, and transaction log backups for databases like PostgreSQL and MySQL.
  • Restore Procedures: Provides scripts for full restores and point-in-time recovery (PITR).
  • Validation Checks: Includes scripts to validate the integrity and completeness of restored data.
  • DR Runbook Generation: Creates a structured runbook for incident response, recovery steps, and RTO/RPO definitions.
  • Use Case: Automatically generate a detailed disaster recovery plan for your critical PostgreSQL database, including automated backup scripts and a step-by-step guide for restoring data in case of an outage.

Quick Start

Generate a disaster recovery runbook for a PostgreSQL database, including backup and restore scripts.

Frequently Asked Questions about backup-restore-runbook-generator

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate database backup and restore scripts for disaster recovery?▼

Automate database backup and restore scripts by generating procedures for full, incremental, and transaction log backups. This disaster recovery automation produces executable scripts and validation checks to ensure business continuity during an outage.

What is point-in-time recovery and how is it included in a DR runbook?▼

Point-in-time recovery (PITR) restores a database to a specific moment using transaction logs. A DR runbook includes PITR scripts and step-by-step restore procedures to minimize data loss and meet your defined Recovery Point Objective.

Does this disaster recovery generator support both PostgreSQL and MySQL databases?▼

Yes, the disaster recovery generator supports PostgreSQL and MySQL. It utilizes dependencies like pg_dump, pg_restore, mysqldump, and pg_basebackup to create tailored backup scripts and restore procedures for your specific database environment.

How do I validate restored data integrity after a database recovery?▼

Validate restored data integrity by running generated validation checks post-restore. These scripts verify the completeness and accuracy of the recovered database, ensuring the restoration meets business continuity requirements before resuming operations.

What goes into a disaster recovery runbook for business continuity?▼

A disaster recovery runbook includes RTO and RPO definitions, role assignments, automated backup scripts, and step-by-step restore procedures. This documented plan ensures structured incident response and sustained business continuity.

Related Skills

Explore More Software Engineering Skills→
jholhewresjholhewres
3

backup

Manage file, database, and system backups with rsync, tar, and database dump tools.

Community
Intermediate
rampstackcorampstackco
523

backup-and-disaster-recovery

Plan and orchestrate backups and disaster recovery procedures for critical systems.

Official
Advanced
BagelHoleBagelHole
46

backup-recovery

Implement data backup and recovery with rsync, Restic, and cloud storage.

Community
Intermediate
BagelHoleBagelHole
46

database-backups

Automate PostgreSQL and MySQL full, incremental, and transaction log backups with S3 uploads.

Community
Intermediate