explainx.ainewsletter3.02k
Productivity

database-backup-restore▌

aj-geddes/useful-ai-prompts · updated Apr 8, 2026

$npx skills add https://github.com/aj-geddes/useful-ai-prompts --skill database-backup-restore
0 commentsdiscussion
summary

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

skill.md

Database Backup & Restore

Table of Contents

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

Reference Guides

Detailed implementations in the references/ directory:

Guide Contents
Full Database Backup Full Database Backup
Incremental & Differential Backups Incremental & Differential Backups
Full Database Backup Full Database Backup
Binary Log Backups Binary Log Backups
PostgreSQL Restore PostgreSQL Restore
MySQL Restore MySQL Restore

Best Practices

✅ DO

  • Follow established patterns and conventions
  • Write clean, maintainable code
  • Add appropriate documentation
  • Test thoroughly before deploying

❌ DON'T

  • Skip testing or validation
  • Ignore error handling
  • Hard-code configuration values

Discussion

Product Hunt–style comments (not star reviews)
  • No comments yet — start the thread.
general reviews

Ratings

4.6★★★★★30 reviews
  • ★★★★★Nikhil Taylor· Dec 28, 2024

    database-backup-restore has been reliable in day-to-day use. Documentation quality is above average for community skills.

  • ★★★★★Pratham Ware· Dec 4, 2024

    database-backup-restore reduced setup friction for our internal harness; good balance of opinion and flexibility.

  • ★★★★★Aanya Menon· Dec 4, 2024

    database-backup-restore reduced setup friction for our internal harness; good balance of opinion and flexibility.

  • ★★★★★Sakshi Patil· Nov 23, 2024

    I recommend database-backup-restore for anyone iterating fast on agent tooling; clear intent and a small, reviewable surface area.

  • ★★★★★Arjun Yang· Nov 23, 2024

    I recommend database-backup-restore for anyone iterating fast on agent tooling; clear intent and a small, reviewable surface area.

  • ★★★★★Nikhil Johnson· Nov 19, 2024

    database-backup-restore fits our agent workflows well — practical, well scoped, and easy to wire into existing repos.

  • ★★★★★Chaitanya Patil· Oct 14, 2024

    Useful defaults in database-backup-restore — fewer surprises than typical one-off scripts, and it plays nicely with `npx skills` flows.

  • ★★★★★Jin Rahman· Oct 14, 2024

    Useful defaults in database-backup-restore — fewer surprises than typical one-off scripts, and it plays nicely with `npx skills` flows.

  • ★★★★★Hana Perez· Oct 10, 2024

    We added database-backup-restore from the explainx registry; install was straightforward and the SKILL.md answered most questions upfront.

  • ★★★★★Henry Thompson· Sep 1, 2024

    database-backup-restore reduced setup friction for our internal harness; good balance of opinion and flexibility.

showing 1-10 of 30

1 / 3