skills.rest
marquesfelip
marquesfelipCOMMUNITY
Explore all skills by this author →
GitHub

backup-and-restore

Automate backup, restore, and disaster recovery planning for relational databases.

Updated Mar 29, 2026
Search Tags:#postgresql#restore#backup#mysql#disaster-recovery#pitr#wal-archiving
One-click install
npx skills add https://github.com/marquesfelip/agents-and-skills --skill backup-and-restore-marquesfelip
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: backup-and-restore
Source: https://github.com/marquesfelip/agents-and-skills/tree/main/skills/backup-and-restore
Command: npx skills add https://github.com/marquesfelip/agents-and-skills --skill backup-and-restore-marquesfelip

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Backup planning and disaster recovery are error-prone and time-consuming. This skill automates the design, validation, and execution of backup and restore procedures for relational databases.

Core Features & Use Cases

  • Automates backup type selection (logical/physical) and WAL archiving for PITR.
  • Provides runbooks for PostgreSQL and MySQL with encryption, retention, and offsite storage considerations.
  • Supports DR planning, regular backup drills, and compliance-ready reporting.

Quick Start

Initialize a full backup cycle for your target database and perform a restore drill to validate recoverability.

Frequently Asked Questions about backup-and-restore

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

FAQPage Schema
How do I set up PostgreSQL point-in-time recovery using WAL archiving?▼

PostgreSQL point-in-time recovery relies on WAL archiving to capture continuous transaction logs. This skill automates backup type selection and configures WAL archiving procedures to enable precise restoration to specific recovery points.

What is the best way to automate disaster recovery planning for relational databases?▼

Disaster recovery planning for relational databases requires defining RPO/RTO targets and automating runbook development. This skill structures your DR practice by selecting appropriate tooling and generating compliance-ready recovery procedures.

How do I create a restore drill runbook for MySQL and PostgreSQL?▼

Creating a restore drill runbook for MySQL and PostgreSQL validates actual recoverability. This skill provides structured runbooks incorporating encryption, retention policies, and offsite storage to verify your backup restoration process.

Does this disaster recovery skill work with both cloud and on-premises database environments?▼

Disaster recovery planning applies to relational databases across both on-premises and cloud environments. The skill designs backup and restore procedures tailored to your specific infrastructure while maintaining consistent RPO and RTO targets.

When do I need logical versus physical backups for database disaster recovery?▼

Logical versus physical backup selection depends on your recovery point and time objectives. This skill automates backup type selection by evaluating your database scale, disaster recovery requirements, and PITR needs.

How do I verify database backup integrity and compliance for audit reporting?▼

Database backup integrity verification requires regular restore drills and compliance-ready reporting. This skill automates the validation process by executing full backup cycles and documenting recoverability for audit purposes.

Related Skills

Explore More Software Engineering Skills→
wangx7wangx7

cloud-sql-basics

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

Community
Intermediate
jeremylongshorejeremylongshore
2.6k

fairdb-backup-manager

Automate FairDB PostgreSQL backup and recovery with pgBackRest and Wasabi S3.

Community
Advanced
OpenAEC-FoundationOpenAEC-Foundation
163

frappe-ops-backup

Automate backups, restores, and disaster-recovery planning for Frappe/ERPNext deployments.

Official
Advanced
vecearvecear

backup-restore-runbook-generator

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

Community
Advanced