# Jeremylongshore Claude Code Plugins Plus Skills Database Backup Automator > Overview - Skill: `tomevault-io/jeremylongshore-claude-code-plugins-plus-skills-database-bac` (Agent Skill, multi-file: 2 files) - Install (CLI): `npx skillmds@latest add tomevault-io/jeremylongshore-claude-code-plugins-plus-skills-database-bac` - Raw SKILL.md: https://api.skillmd.com/api/skills/tomevault-io/jeremylongshore-claude-code-plugins-plus-skills-database-bac/raw - Safety review: pending (external: skill-scanner PASS, skillspector PASS) - Works with: Claude Code, Claude.ai, OpenAI Codex - Category: Coding & Dev Tools - Author: tomevault-io (https://skillmd.com/u/tomevault-io) - Updated: 2026-09-17 - Page: https://skillmd.com/skills/tomevault-io/jeremylongshore-claude-code-plugins-plus-skills-database-bac --- ## Overview This skill streamlines the creation of database backup solutions. It generates scripts, configures schedules, and provides comprehensive restore procedures, ensuring data safety and efficient recovery. ## How It Works 1. **Analyze Requirements**: Determines the database type (PostgreSQL, MySQL, MongoDB, or SQLite) and backup requirements (frequency, retention). 2. **Generate Scripts**: Creates backup scripts with compression and encryption. 3. **Schedule Backups**: Sets up cron jobs for automated, scheduled backups. 4. **Document Restore**: Generates clear, concise restore procedures. ## When to Use This Skill This skill activates when you need to: - Create a backup schedule for a database. - Automate the database backup process. - Generate scripts for database restoration. - Implement a disaster recovery plan for a database. ## Examples ### Example 1: Setting up Daily Backups for PostgreSQL User request: "Create daily backups for my PostgreSQL database." The skill will: 1. Generate a `pg_dump` script with compression and encryption. 2. Create a cron job to run the backup script daily. ### Example 2: Automating Weekly Backups for MongoDB User request: "Automate weekly backups for my MongoDB database." The skill will: 1. Generate a `mongodump` script with compression and encryption. 2. Create a cron job to run the backup script weekly and implement a retention policy. ## Best Practices - **Retention Policies**: Implement clear retention policies to manage storage space. - **Testing Restores**: Regularly test restore procedures to ensure data integrity. - **Secure Storage**: Store backups in secure, encrypted locations, preferably offsite. ## Integration This skill can integrate with cloud storage plugins (S3, GCS, Azure) for offsite backup storage and monitoring plugins for backup success/failure alerts. --- > Converted and distributed by [TomeVault](https://tomevault.io/claim/jeremylongshore) — claim your Tome and manage your conversions.