From aj-geddes-useful-ai-prompts-4
Implements database backup and restore strategies for PostgreSQL and MySQL, covering pg_dump, binary logs, PITR, retention policies, and disaster recovery testing.
npx claudepluginhub joshuarweaver/cascade-code-languages-misc-1 --plugin aj-geddes-useful-ai-prompts-4This skill uses the workspace's default tool permissions.
- [Overview](#overview)
Searches, retrieves, and installs Agent Skills from prompts.chat registry using MCP tools like search_skills and get_skill. Activates for finding skills, browsing catalogs, or extending Claude.
Searches prompts.chat for AI prompt templates by keyword or category, retrieves by ID with variable handling, and improves prompts via AI. Use for discovering or enhancing prompts.
Checks Next.js compilation errors using a running Turbopack dev server after code edits. Fixes actionable issues before reporting complete. Replaces `next build`.
Implement comprehensive backup and disaster recovery strategies. Covers backup types, retention policies, restore testing, and recovery time objectives (RTO/RPO).
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
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 |