What is Point-in-Time Recovery (PITR)?

PITR allows you to restore a database to a specific second in the past, minimizing data loss after accidental deletions or data corruption.

Can this skill handle multi-region failover?

Yes, the skill can configure replication and automated failover procedures across different geographic regions to ensure high availability during outages.

Does it work with different database types?

The skill is designed to manage recovery operations for major production databases like PostgreSQL and MySQL by leveraging the recovery manager plugin.

How does it automate backup validation?

It triggers recovery testing workflows to verify that existing backups are valid and can be restored within your required Recovery Time Objectives (RTO).

Is manual intervention required for recovery?

While the skill automates the configuration and execution, it provides clear documentation and logs for human oversight to ensure total control during critical recovery events.

Database Recovery Manager

Name: Database Recovery Manager
Author: jeremylongshore

byjeremylongshore

•

884

Database Management

Automates database disaster recovery, point-in-time recovery (PITR), and failover strategies to ensure high availability and data resilience.

About

The Database Recovery Manager skill empowers Claude to orchestrate complex database resilience tasks, ranging from setting up multi-region disaster recovery plans to implementing precise point-in-time recovery (PITR). By leveraging automated backup verification and failover configuration, it helps developers and DBAs maintain high availability for production systems while significantly reducing the risk of data loss during critical outages or hardware failures.

Key Features

Automated Point-in-Time Recovery (PITR) configuration
Transaction log archiving and management
Integration with production database monitoring and alerting
Automated backup validation and recovery testing
884 GitHub stars
Multi-region disaster recovery and failover setup

Use Cases

Setting up automated failover for a production PostgreSQL instance
Implementing granular data restoration via MySQL point-in-time recovery
Validating database backup integrity through automated testing routines

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills database-recovery-manager

For use in Claude.ai and ChatGPT

Download Skill

GitHub