Specification
- Skill ID
- aj-geddes/useful-ai-prompts/database-backup-restore
- Publisher
- aj-geddes
- Repository
- useful-ai-prompts
- Installs
- 0
- Files
- 9
- Synced
- Sep 23, 2026
How to use it
Open any RiverX project, open the Skills panel in the chat, and search for this identifier. The files are fetched from the source repository at install time.
aj-geddes/useful-ai-prompts/database-backup-restoreInstalls these files- SKILL.md
- references/binary-log-backups.md
- references/full-database-backup-2.md
- references/full-database-backup.md
- references/incremental-differential-backups.md
- references/mysql-restore.md
- references/postgresql-restore.md
- scripts/validate-schema.sh
- templates/migration-template.sql
What this skill tells the agent
Database Backup & Restore
Table of Contents
- Overview
- When to Use
- Quick Start
- Reference Guides
- Best Practices
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.sqlReference 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
More from aj-geddes
Use this skill in a project
Open any RiverX project, search the Skills panel for aj-geddes/useful-ai-prompts/database-backup-restore, and install it in one click.