Skip to content

jeremylongshore/tons-of-skills-marketplace / plugins/database/database-backup-automator/skills/automating-database-backups

automating-database-backups

Flagged

Automate database backup processes with scheduling, compression, and encryption. Supports PostgreSQL (pg_dump), MySQL (mysqldump), MongoDB (mongodump), and SQLite. Generates production-ready backup scripts with retention policies and restore procedures. Trigger: "automate database backups", "schedule backups", "create backup script", "disaster recovery". Use when working with automating database backups. Trigger with 'automating', 'database', 'backups'.

config/settings.yaml

View on GitHub
# Database Backup Automator Configuration
# Default settings for backup script generation

# Default backup directory
backup_directory: /var/backups

# Compression settings
compression:
  default: gzip
  options:
    - none
    - gzip
    - zstd

# Encryption settings
encryption:
  default: none
  options:
    - none
    - gpg
    - openssl
  key_file: /etc/backup.key

# Retention policies (days)
retention:
  daily: 7
  weekly: 28
  monthly: 365

# Default schedules (cron format)
schedules:
  hourly: "0 * * * *"
  daily: "0 2 * * *"
  daily_midnight: "0 0 * * *"
  twice_daily: "0 2,14 * * *"
  every_6_hours: "0 */6 * * *"
  weekly: "0 2 * * 0"
  monthly: "0 2 1 * *"

# Database defaults
databases:
  postgresql:
    port: 5432
    user: postgres
    format: custom
    backup_dir: /var/backups/postgresql

  mysql:
    port: 3306
    user: root
    options:
      - --single-transaction
      - --routines
      - --triggers
      - --events
    backup_dir: /var/backups/mysql

  mongodb:
    port: 27017
    backup_dir: /var/backups/mongodb
    options:
      - --gzip

  sqlite:
    backup_dir: /var/backups/sqlite

# Notification settings (optional)
notifications:
  on_success: false
  on_failure: true
  email: ""

# Logging
logging:
  enabled: true
  file: backup.log
  max_size_mb: 10
  retention_days: 30
deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall