skills.rest
rnavarych
rnavarychCOMMUNITY
Explore all skills by this author →
GitHub

role-database:backup-recovery

Plan database backup and disaster recovery across PostgreSQL, MySQL, MongoDB, and Redis.

14|3|Updated Feb 22, 2026
Search Tags:#database#postgresql#disaster recovery#backup#recovery#mysql#mongodb
One-click install
npx skills add https://github.com/rnavarych/alpha-engineer --skill role-database-backup-recovery
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: role-database:backup-recovery
Source: https://github.com/rnavarych/alpha-engineer/tree/main/plugins/roles/role-database/skills/backup-recovery
Command: npx skills add https://github.com/rnavarych/alpha-engineer --skill role-database-backup-recovery

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses the critical need for reliable data protection by providing comprehensive strategies for backing up and recovering data across various database engines, ensuring business continuity and minimizing data loss.

Core Features & Use Cases

  • Diverse Backup Methods: Supports full, incremental, and differential backups tailored to specific database needs (e.g., pg_dump, XtraBackup, mongodump).
  • Point-in-Time Recovery (PITR): Enables recovery to a specific moment using transaction logs (WAL, oplog).
  • Disaster Recovery Planning: Offers guidance on RPO/RTO tiers and DR patterns like warm standby and multi-site active.
  • Use Case: Implement a robust backup solution for a PostgreSQL database, ensuring you can recover to any point in time within the last 7 days and have a disaster recovery plan in place for a regional outage.

Quick Start

Configure pgBackRest for daily full backups and hourly incremental backups for the main PostgreSQL database.

Frequently Asked Questions about role-database:backup-recovery

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

FAQPage Schema
How do I implement point-in-time recovery for PostgreSQL using WAL logs?▼

PostgreSQL point-in-time recovery uses WAL transaction logs to restore your database to a specific moment. This Skill guides you through PITR configuration, enabling recovery to any second within your retained log window.

What is the best way to plan database disaster recovery with defined RPO and RTO?▼

Database disaster recovery planning defines RPO and RTO tiers to minimize data loss and downtime. This Skill provides DR patterns like warm standby and multi-site active architectures tailored to your business continuity requirements.

Does this disaster recovery Skill support MongoDB and MySQL backup strategies?▼

Yes, this disaster recovery Skill supports MongoDB and MySQL backup strategies. It covers engine-specific methods like mongodump and XtraBackup, ensuring comprehensive data protection across PostgreSQL, MySQL, MongoDB, and Redis.

How do I configure incremental backups for PostgreSQL to save storage space?▼

Configure PostgreSQL incremental backups using tools like pgBackRest to save storage space. This Skill outlines strategies for daily full and hourly incremental backups, optimizing storage while maintaining rapid recovery capabilities.

When do I need transaction log backups for database recovery?▼

You need transaction log backups for database recovery when requiring point-in-time restoration or minimal data loss. This Skill explains how utilizing WAL or oplog logs enables granular recovery beyond standard full or incremental database backups.

Can I use cloud-native solutions for database backup and disaster recovery?▼

Yes, you can use cloud-native solutions for database backup and disaster recovery. This Skill covers cloud-native integrations alongside traditional methods, providing patterns for multi-site active architectures and regional outage resilience.

Related Skills

Explore More Software Engineering Skills→
Snowflake-LabsSnowflake-Labs
1

data-migration-setup

Configure Snowflake migration environments with workflow configs and infrastructure components.

Official
Intermediate
DexploarerDexploarer
7

disaster-recovery-planner

Design disaster recovery strategies with tiered RTO/RPO targets and multi-region failover.

Community
Advanced
wangx7wangx7

cloud-sql-basics

Provision and administer Cloud SQL instances for MySQL, PostgreSQL, and SQL Server.

Community
Intermediate
jholhewresjholhewres
3

backup

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

Community
Intermediate