Can this skill handle multi-region failover?

Yes, it can orchestrate replication to secondary geographic regions and configure the automated logic needed for failover during a primary region outage.

What is PITR and how does this skill help?

Point-in-Time Recovery (PITR) allows you to restore a database to a specific second. This skill automates the configuration of transaction logs and backup schedules required for PITR.

How does it ensure my backups actually work?

The skill includes features for automated backup validation and recovery testing, regularly verifying that your backup files are non-corrupt and restorable.

Does it support both SQL and NoSQL databases?

While primarily focused on structured systems like PostgreSQL and MySQL, it can be adapted for any system supported by the database-recovery-manager plugin.

Database Recovery Manager

Name: Database Recovery Manager
Author: jeremylongshore

byjeremylongshore

•

883

데이터베이스 관리

Orchestrates complex database recovery operations including point-in-time recovery, disaster recovery plans, and automated failover strategies.

소개

The Database Recovery Manager skill empowers Claude to manage high-stakes database resilience tasks, ensuring production systems remain durable and available. It automates the technical heavy lifting of setting up Point-in-Time Recovery (PITR), configuring multi-region disaster recovery, and implementing automated failover procedures. Beyond setup, the skill prioritizes data integrity by automating backup validation and recovery testing, allowing teams to meet strict Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO) with AI-driven precision.

주요 기능

883 GitHub stars
Transaction log archiving and management
Multi-region disaster recovery and failover orchestration
Database replication and secondary region setup
Automated Point-in-Time Recovery (PITR) configuration
Continuous backup validation and recovery testing

사용 사례

Setting up automated failover to minimize downtime during database outages
Establishing a point-in-time recovery strategy to protect against accidental data loss
Implementing a disaster recovery plan for production PostgreSQL or MySQL instances

소개

주요 기능

883 GitHub stars
Transaction log archiving and management
Multi-region disaster recovery and failover orchestration
Database replication and secondary region setup
Automated Point-in-Time Recovery (PITR) configuration
Continuous backup validation and recovery testing

사용 사례

Setting up automated failover to minimize downtime during database outages
Establishing a point-in-time recovery strategy to protect against accidental data loss
Implementing a disaster recovery plan for production PostgreSQL or MySQL instances