Can it help with data recovery?

Absolutely. Along with creating backups, it generates clear, step-by-step restore procedures to ensure you can recover data quickly during an emergency.

Does it handle backup security?

Yes, the skill generates scripts that include both data compression and encryption to ensure backups are stored securely.

Does it manage storage space for old backups?

Yes, the skill helps implement retention policies to automatically prune old backup files and manage storage efficiency.

Which databases are supported by this skill?

The skill supports PostgreSQL, MySQL, MongoDB, and SQLite databases.

How are the backup schedules managed?

The skill creates and configures standard cron jobs on your system to automate backups at your requested frequency (daily, weekly, etc.).

Database Backup Automator

Name: Database Backup Automator
Author: jeremylongshore

byjeremylongshore

•

884

Database Management

Automates the creation of scheduled, encrypted, and compressed database backups for major SQL and NoSQL systems.

About

This skill provides a comprehensive solution for managing database reliability by automating the generation of backup scripts, scheduling cron jobs, and creating detailed restoration procedures. It supports popular databases like PostgreSQL, MySQL, MongoDB, and SQLite, ensuring that developers can implement robust disaster recovery plans with integrated encryption and compression to protect data integrity and optimize storage usage across various environments.

Key Features

Automated cron job scheduling for recurring backup tasks
Multi-database support for PostgreSQL, MySQL, MongoDB, and SQLite
Generation of step-by-step restoration procedures
Configurable retention policies to manage storage space
Built-in data encryption and compression for secure storage
884 GitHub stars

Use Cases

Creating a documented disaster recovery plan for compliance
Setting up automated daily offsite backups for production databases
Implementing encrypted backup schedules for sensitive MongoDB or SQL data

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills database-backup-automator

For use in Claude.ai and ChatGPT

Download Skill

GitHub