Can I schedule backups to run automatically?

Absolutely. The skill assists in creating and configuring cron jobs to automate backups on daily, weekly, or custom intervals.

Which databases are supported by this skill?

This skill supports PostgreSQL, MySQL, MongoDB, and SQLite, utilizing native tools like pg_dump and mongodump for reliable backups.

Does it handle backup encryption and security?

Yes, the skill generates scripts that can include encryption and compression steps to ensure your sensitive data remains secure and storage-efficient.

Does this skill help with data restoration?

Yes, it generates clear, step-by-step restoration procedures and scripts to ensure you can recover your data quickly in the event of a failure.

Can I use this for cloud-hosted databases?

While it generates scripts for local execution, the output can be easily integrated with cloud storage tools like AWS S3 or GCS for offsite backup storage.

Database Backup Automator

Name: Database Backup Automator
Author: jeremylongshore

byjeremylongshore

•

884

Database Management

Automates database backup scheduling, script generation, and restore procedures for popular SQL and NoSQL engines.

About

The Database Backup Automator is a specialized Claude Code skill designed to streamline data protection strategies by generating customized backup scripts for PostgreSQL, MySQL, MongoDB, and SQLite. It automates the entire lifecycle of database maintenance—from configuring compression and encryption to setting up automated cron jobs and creating detailed disaster recovery restoration guides. This skill is ideal for developers and DevOps engineers who need to ensure data integrity and business continuity through consistent, scheduled backups and verified recovery paths.

Key Features

Automated shell script generation with built-in compression and encryption
Configurable retention policies to optimize storage space management
884 GitHub stars
Multi-database support including PostgreSQL, MySQL, MongoDB, and SQLite
Cron job configuration for hands-off automated scheduling
Comprehensive disaster recovery and restoration procedure documentation

Use Cases

Generating a disaster recovery plan and restore script for a MongoDB cluster
Implementing weekly backup rotations for SQLite databases with custom retention logic
Setting up automated daily encrypted backups for a production PostgreSQL instance

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