skills.rest
ivanuser
ivanuserCOMMUNITY
Explore all skills by this author →
GitHub

backup-disaster-recovery

Automate MySQL and PostgreSQL backups with offsite storage and restore validation.

Updated Mar 20, 2026
Search Tags:#postgresql#restore#backup#mysql#disaster-recovery#dr#offsite
One-click install
npx skills add https://github.com/ivanuser/cortex-server-skills --skill backup-disaster-recovery-ivanuser
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: backup-disaster-recovery
Source: https://github.com/ivanuser/cortex-server-skills/tree/main/infra/backup-disaster-recovery
Command: npx skills add https://github.com/ivanuser/cortex-server-skills --skill backup-disaster-recovery-ivanuser

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It consolidates database backups and offsite replication with automated verification to ensure rapid recovery during incidents.

Core Features & Use Cases

  • Automated MySQL and PostgreSQL backups with both full/dump formats and compression for offsite storage.
  • Offsite replication and retention policies with periodic restore validation drills to prove DR readiness.
  • Use Case: When a production database experiences failures, run scheduled backups, push to offsite storage, and perform restore checks to confirm data integrity.

Quick Start

Use the backup-disaster-recovery skill to perform a full backup of your configured databases and verify restoration readiness.

Frequently Asked Questions about backup-disaster-recovery

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

FAQPage Schema
How do I automate PostgreSQL backups and send them to offsite storage?▼

Automated PostgreSQL backups are pushed to offsite object storage using full and compressed dump formats. The process applies retention policies and schedules regular syncs to ensure offsite protection without manual intervention.

What is the best way to verify disaster recovery readiness for a MySQL database?▼

Disaster recovery readiness is verified through periodic restore validation drills. The system performs automated restore checks on the MySQL backups to confirm data integrity and prove that recovery is possible during an incident.

Can I apply retention policies and safety rules to database backups for production deployments?▼

Retention policies and safety rules can be applied to regular backups for production MySQL and PostgreSQL deployments. This ensures offsite replication and database protection are managed automatically without risking data loss.

Does disaster recovery work with both MySQL and PostgreSQL production databases?▼

Disaster recovery works with both MySQL and PostgreSQL production deployments. It automates database backups, offsite replication to object storage, and restore validation drills for both database types.

Why do I need restore validation drills for offsite database backups?▼

Restore validation drills are needed to confirm data integrity and ensure rapid recovery during actual incidents. They prove that your offsite backups can be successfully restored when a production database experiences failures.

How do I perform a full database backup and check restoration readiness?▼

A full database backup is performed by running the configured backup process, which then pushes the data to offsite storage. Restoration readiness is checked automatically through restore verification to confirm data integrity.

Related Skills

Explore More Software Engineering Skills→
jeremylongshorejeremylongshore
2.6k

managing-database-replication

Configure master-slave replication and automatic failover for PostgreSQL and MySQL deployments.

Community
Advanced
Camilo8902Camilo8902

backup-restore-runbook-generator

Generate disaster recovery runbooks with backup and restore scripts for PostgreSQL and MySQL.

Community
Advanced
Nir-BhayNir-Bhay
19

backup-retention-policy

Design backup retention policies with the 3-2-1-1-0 rule and tiered storage.

Community
Advanced
ryukyagamilightryukyagamilight
1

cloud-backup

Manage data backups and synchronization to AWS S3, Alibaba OSS, and Azure Blob Storage.

Community
Advanced