What tools does this skill require?

It utilizes standard system utilities including tar, rsync, and the AWS CLI, alongside database-specific binaries like pg_restore or xtrabackup.

Can I use this for cloud-based backups?

Yes, it includes built-in support for transferring and managing backups on AWS S3, Google Cloud Storage, and Azure Blob storage.

Which database engines are supported?

This skill is specifically designed for PostgreSQL and MySQL, utilizing industry-standard tools like pg_basebackup, pg_dump, mysqldump, and xtrabackup.

Does this skill support Point-in-Time Recovery?

Absolutely. It provides automated guidance for configuring WAL archiving (PostgreSQL) and binary logging (MySQL) to allow for granular restoration to specific timestamps.

How does it help with backup verification?

The skill includes procedures for setting up automated cron jobs that restore backups to a test environment and run integrity checks to ensure data validity.

Database Recovery Manager

Name: Database Recovery Manager
Author: micsapp

bymicsapp

0•

Database Management

Automates database backup, optimization, and point-in-time recovery procedures for PostgreSQL and MySQL.

The Database Recovery Manager skill provides a comprehensive framework for managing the end-to-end lifecycle of database backups and disaster recovery within Claude Code. It enables the automated configuration of WAL archiving, physical and logical backups, and complex point-in-time recovery (PITR) scenarios. By integrating with cloud storage providers like AWS S3 and providing automated verification through restoration testing, it ensures that your data remains protected and that your Recovery Point Objective (RPO) and Recovery Time Objective (RTO) targets are consistently met.

Key Features

010 GitHub stars

02Automated physical and logical backup workflows

03Automated backup verification and recovery runbook generation

04Cloud storage integration for AWS S3, GCS, and Azure

05WAL archiving and binary log configuration

06Point-in-Time Recovery (PITR) for precise data restoration

Use Cases

01Executing and documenting monthly disaster recovery drills

02Configuring automated, encrypted backup pipelines to remote cloud storage

03Restoring a database to a specific timestamp after accidental data loss

Key Features

010 GitHub stars

02Automated physical and logical backup workflows

03Automated backup verification and recovery runbook generation

04Cloud storage integration for AWS S3, GCS, and Azure

05WAL archiving and binary log configuration

06Point-in-Time Recovery (PITR) for precise data restoration

Use Cases

01Executing and documenting monthly disaster recovery drills

02Configuring automated, encrypted backup pipelines to remote cloud storage

03Restoring a database to a specific timestamp after accidental data loss