backup-restore-manager

Automate PostgreSQL and MySQL backups and restores with Python and YAML.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/alabasi2025/manus-skills-library --skill backup-restore-manager
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: backup-restore-manager
Source: https://github.com/alabasi2025/manus-skills-library/tree/main/infrastructure/backup-restore-manager
Command: npx skills add https://github.com/alabasi2025/manus-skills-library --skill backup-restore-manager

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill automates the backup and restoration of databases, reducing manual, error-prone processes and safeguarding data integrity.

Core Features & Use Cases

  • Full, Differential, Incremental, and Point-in-Time backups: Schedule and automate backups for PostgreSQL and MySQL.
  • Restore & Verification: Restore from compressed backups with optional checksum verification.
  • Automation & Scheduling: Define cron-based schedules and automatic retention/configuration via YAML.
  • Cloud & Local Storage: Store backups locally and upload to cloud providers when configured.

Quick Start

Use the backup-restore-manager to create a full backup of your Postgres database and verify the output.

Frequently Asked Questions about backup-restore-manager

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate PostgreSQL and MySQL database backups with scheduling?

You can automate database backups by defining cron-based schedules and retention policies via YAML configuration. The Skill orchestrates pg_dump and mysqldump operations to execute full, differential, incremental, and point-in-time backups automatically.

What is the best way to schedule incremental and point-in-time backups for MySQL?

Scheduling incremental and point-in-time backups is handled through YAML-based configuration files. The Skill uses Python scripts to orchestrate these specific backup types alongside standard full and differential backups for MySQL databases.

Can I restore a database from a compressed backup and verify its checksum?

Yes, you can restore databases directly from compressed backups. The Skill includes optional checksum verification during the restore process to ensure data integrity before the database is recovered.

Does this database backup approach support direct uploads to cloud storage providers?

Yes, the backup process supports both local storage and optional cloud storage uploads. Once the database dump is compressed and checksummed, the Python scripts can automatically upload the backup files to configured cloud providers.

How do I configure backup retention and automation rules for PostgreSQL?

Backup retention and automation rules are configured using YAML files. This approach allows you to define specific schedules and manage automatic retention policies for PostgreSQL backups without manual intervention.

Why use YAML configuration for database backup orchestration instead of manual scripts?

Using YAML configuration standardizes backup orchestration by defining schedules, retention, and storage options in one place. This reduces manual, error-prone processes by letting Python scripts automatically manage compression, checksums, and dumps.