How does it manage disk space and old backups?

It provides retention policy examples and scripts to automatically find and delete old backup files after a specific number of days, weeks, or months.

Does it provide a way to restore data?

Yes, the skill can generate matching restore scripts for every backup configuration it creates, ensuring a complete disaster recovery loop.

Can I schedule backups automatically?

Yes, the skill includes a cron scheduler tool that helps you generate and install crontab entries for daily, weekly, or custom intervals.

Which databases are supported by this skill?

This skill supports PostgreSQL (pg_dump), MySQL (mysqldump), MongoDB (mongodump), and SQLite.

Does it handle backup encryption?

Yes, it generates scripts that include GPG symmetric encryption (AES256) options to ensure your backups are secure at rest.

Database Backup Automator

Name: Database Backup Automator
Author: Brmbobo

byBrmbobo

0•

Database Management

Automates database backup processes with scheduling, compression, and encryption for production-ready disaster recovery.

The Database Backup Automator is a comprehensive tool designed to simplify and secure your data management workflows. It generates production-grade backup and restore scripts for major database systems including PostgreSQL, MySQL, MongoDB, and SQLite. By incorporating advanced features like GPG encryption, multi-level compression, and customizable retention policies, this skill ensures your data remains protected and compliant. It also streamlines the scheduling of automated tasks via cron, providing a robust disaster recovery framework for developers and system administrators.

Key Features

01Secure GPG Encryption and Gzip Compression

02Validation Tools for Backup Integrity Checks

03Multi-Database Support (Postgres, MySQL, Mongo, SQLite)

04Automated Scheduling with Cron Expression Generation

05Customizable Data Retention and Cleanup Policies

060 GitHub stars

Use Cases

01Setting up nightly encrypted backups for a production PostgreSQL instance

02Creating standardized disaster recovery scripts for a multi-tenant application

03Automating MongoDB snapshots with auto-cleanup of old archives

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add brmbobo/web2podcast automating-database-backups

For use in Claude.ai and ChatGPT

Download Skill