Does it handle backup encryption?

Yes, the skill generates scripts that include options for both compression and encryption to ensure data remains secure while stored.

How does it help with disaster recovery?

Beyond just taking backups, the skill generates clear, step-by-step restoration procedures to ensure you can recover data quickly during an emergency.

Which databases does this skill support?

The Database Backup Automator currently supports PostgreSQL, MySQL, MongoDB, and SQLite.

Can it schedule backups automatically?

Yes, it creates and configures cron jobs to automate backups based on your specified frequency, such as daily or weekly intervals.

Can I set data retention policies?

Yes, the skill allows you to define retention policies to automatically clean up old backups and manage storage space efficiently.

Database Backup Automator

Name: Database Backup Automator
Author: BbgnsurfTech

byBbgnsurfTech

•

Database Management

Automates the creation of scheduled, encrypted, and compressed database backups with integrated recovery procedures.

About

This skill provides a comprehensive solution for managing database reliability by automating the entire backup lifecycle. It generates specialized scripts for PostgreSQL, MySQL, MongoDB, and SQLite that include essential features like data compression and encryption. By configuring automated cron jobs and establishing clear, documented restoration procedures, the skill helps developers implement robust disaster recovery plans and maintain data integrity without manual intervention.

Key Features

3 GitHub stars
Standardized disaster recovery and restoration documentation
Integrated data compression and encryption for secure storage
Automated scheduling via system-level cron job configuration
Customizable retention policies to optimize storage management
Multi-database support for PostgreSQL, MySQL, MongoDB, and SQLite

Use Cases

Implementing weekly backup schedules and retention policies for MongoDB
Setting up daily encrypted backups for a production PostgreSQL database
Generating standardized restore procedures for disaster recovery drills

About

Key Features

3 GitHub stars
Standardized disaster recovery and restoration documentation
Integrated data compression and encryption for secure storage
Automated scheduling via system-level cron job configuration
Customizable retention policies to optimize storage management
Multi-database support for PostgreSQL, MySQL, MongoDB, and SQLite

Use Cases

Implementing weekly backup schedules and retention policies for MongoDB
Setting up daily encrypted backups for a production PostgreSQL database
Generating standardized restore procedures for disaster recovery drills