Which databases does this skill support?

The skill provides specialized automation for PostgreSQL (pg_dump), MySQL (mysqldump), MongoDB (mongodump), and SQLite.

How are the backups secured?

The skill implements industry-standard encryption using GPG or OpenSSL and utilizes environment variables for secure credential handling.

Can it help with storage management?

Yes, it includes features for backup compression (gzip/zstd) and automated retention policies that delete old files based on a daily, weekly, or monthly schedule.

Does it handle automated scheduling?

Yes, it generates Crontab entries and system configurations to manage recurring backup tasks based on your required frequency.

Database Backup Automator

Name: Database Backup Automator
Author: jeremylongshore

byjeremylongshore

•

983

Database Management

Automates database backup workflows with scheduling, encryption, and multi-database support for robust disaster recovery.

About

This skill streamlines database administration by generating customized backup scripts for PostgreSQL, MySQL, MongoDB, and SQLite, integrating essential security features like GPG encryption and zstd compression. It simplifies the implementation of complex disaster recovery strategies by handling crontab scheduling, tiered retention policies, and providing structured restoration procedures, ensuring data integrity and business continuity for developers and system administrators.

Key Features

Storage-efficient compression (gzip/zstd) and verification
Automated scheduling via Crontab configuration
Multi-database support for PostgreSQL, MySQL, MongoDB, and SQLite
Tiered retention policy and automated cleanup scripts
983 GitHub stars
Secure backup encryption using GPG or OpenSSL

Use Cases

Setting up automated nightly backups for production databases to remote storage
Creating a full disaster recovery plan with documented restoration steps
Implementing encrypted database dumps to meet security and compliance requirements

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills automating-database-backups

For use in Claude.ai and ChatGPT

Download Skill

GitHub