Database Backup Restore

Covers the essentials of database backup and restore workflows, from pg_dump and mysqldump commands to point-in-time recovery and cross-region replication. You'll use this when setting up automated backup jobs, defining retention policies, or testing disaster recovery procedures. The reference guides walk through full backups, incremental strategies, and binary log handling for both PostgreSQL and MySQL. The quick start examples are straightforward, showing text and compressed formats plus table exclusions. It's practical for compliance requirements and RTO/RPO planning, though you'll want to adapt the patterns to your specific infrastructure and recovery objectives.

skills.sh installs: 588
GitHub stars: 379
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add aj-geddes/useful-ai-prompts --skill database-backup-restore --agent claude-code

Installs into .claude/skills of the current project.

Files

Overview

Implement comprehensive backup and disaster recovery strategies. Covers backup types, retention policies, restore testing, and recovery time objectives (RTO/RPO).

When to Use

Backup automation setup
Disaster recovery planning
Recovery testing procedures
Backup retention policies
Point-in-time recovery (PITR)
Cross-region backup replication
Compliance and audit requirements

Quick Start

pg_dump - Text Format:

# Simple full backup
pg_dump -h localhost -U postgres -F p database_name > backup.sql

# With compression
pg_dump -h localhost -U postgres -F p database_name | gzip > backup.sql.gz

# Backup with verbose output
pg_dump -h localhost -U postgres -F p -v database_name > backup.sql 2>&1

# Exclude specific tables
pg_dump -h localhost -U postgres database_name \
  --exclude-table=temp_* --exclude-table=logs > backup.sql