managing-database-recovery

Orchestrate database recovery operations with the database-recovery-manager plugin.

2.6k|379|Updated Oct 10, 2025
One-click install
npx skills add https://github.com/jeremylongshore/claude-code-plugins-plus --skill managing-database-recovery
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: managing-database-recovery
Source: https://github.com/jeremylongshore/claude-code-plugins-plus/tree/main/plugins/database/database-recovery-manager/skills/database-recovery-manager
Command: npx skills add https://github.com/jeremylongshore/claude-code-plugins-plus --skill managing-database-recovery

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This skill empowers Claude to orchestrate comprehensive database recovery strategies, including disaster recovery setup, point-in-time recovery implementation, and automated failover configuration. It leverages the database-recovery-manager plugin to ensure database resilience and minimize downtime.

Core Features & Use Cases

  • Disaster Recovery Setup: Configure replication to secondary regions and automate failover.
  • Point-in-Time Recovery (PITR): Implement PITR with regular backups and transaction log archiving.
  • Automated Backup Validation: Verify backup integrity and test recovery procedures.
  • Use Case: Set up a robust disaster recovery plan for a production PostgreSQL database with automated failover to a secondary region.

Quick Start

User request: "Set up disaster recovery for my production PostgreSQL database."

The skill will:

  1. Invoke the /recovery command.
  2. Configure a disaster recovery plan, including setting up replication to a secondary region and automating failover procedures.

Frequently Asked Questions about managing-database-recovery

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

FAQPage Schema
How do I set up disaster recovery for a production database?

Disaster recovery setup configures replication to secondary regions and automates failover procedures. This Skill orchestrates the complete process—from replication configuration through failover automation—to minimize downtime when primary systems fail.

What is point-in-time recovery (PITR) and when do I need it?

Point-in-time recovery (PITR) restores your database to any moment in time by combining regular backups with transaction log archiving. Use PITR when you need to recover from data corruption, accidental deletions, or logical errors without losing all post-incident work.

Can I automate failover to a secondary region?

Yes. This Skill automates multi-region failover through the database-recovery-manager plugin, which handles replication setup, failover triggers, and orchestration to ensure your production database switches to a secondary region with minimal manual intervention.

How do I verify that my database backups will actually restore?

Automated backup validation tests recovery procedures by verifying backup integrity and simulating restore operations. This Skill performs these validation tests to confirm backups are usable before you face a real disaster.

Does this work with PostgreSQL and other production databases?

Yes. The Core Task Description explicitly covers PostgreSQL and applies to production database environments requiring disaster recovery planning, PITR configuration, and failover testing across supported database platforms.