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

データベース管理

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.

主な機能

Secure GPG Encryption and Gzip Compression
Validation Tools for Backup Integrity Checks
Multi-Database Support (Postgres, MySQL, Mongo, SQLite)
Automated Scheduling with Cron Expression Generation
Customizable Data Retention and Cleanup Policies
0 GitHub stars

ユースケース

Setting up nightly encrypted backups for a production PostgreSQL instance
Creating standardized disaster recovery scripts for a multi-tenant application
Automating 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

GitHub

概要