managing-database-replication

Configure master-slave replication and automatic failover for PostgreSQL and MySQL deployments.

2.6k|379|Updated Oct 10, 2025

Search Tags:#database #PostgreSQL #MySQL #data consistency #replication #high availability #failover

Ready to run

npx skills add https://github.com/jeremylongshore/claude-code-plugins-plus --skill managing-database-replication

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: managing-database-replication
Source: https://github.com/jeremylongshore/claude-code-plugins-plus/tree/main/plugins/database/database-replication-manager/skills/database-replication-manager
Command: npx skills add https://github.com/jeremylongshore/claude-code-plugins-plus --skill managing-database-replication

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 automate and streamline database replication processes, ensuring high availability and data consistency across multiple database instances. It simplifies the configuration and management of complex replication topologies for databases like PostgreSQL and MySQL.

Core Features & Use Cases

Master-Slave Replication Setup: Configure new replication environments with ease.
Automatic Failover: Implement and manage automatic failover for database clusters.
Replication Lag Monitoring: Track lag and trigger alerts based on predefined thresholds.
Use Case: Set up master-slave replication for a PostgreSQL database with automatic failover, ensuring continuous operation even during outages.

Quick Start

User request: "Set up master-slave replication for my PostgreSQL database with automatic failover."

The skill will:

Activate the database-replication-manager plugin.
Guide the user through the configuration process, prompting for connection details and failover settings.
Generate and execute the necessary PostgreSQL commands to establish master-slave replication and configure automatic failover.

Frequently Asked Questions about managing-database-replication

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

FAQPage Schema

How do I set up master-slave replication for PostgreSQL or MySQL?▼

Master-slave replication configures a primary database to automatically sync changes to one or more replica servers. This Skill automates the setup process by prompting for connection details, generating the necessary replication commands for your chosen database, and establishing the replication stream to enable read scaling and failover capability.

What's the difference between physical and logical replication?▼

Physical replication copies the database's underlying storage blocks, offering lower overhead and faster recovery. Logical replication copies individual row changes, allowing selective replication and compatibility across PostgreSQL versions. This Skill supports both modes so you can choose based on your consistency and operational requirements.

How does automatic failover work in a replicated database cluster?▼

Automatic failover detects when the master database fails and promotes a replica to become the new master, redirecting client connections to maintain service. This Skill configures the failover mechanism and monitoring thresholds, so your database cluster continues operating without manual intervention during outages.

Can I monitor replication lag and set up alerts?▼

Replication lag monitoring tracks how far behind replicas are from the master. This Skill implements lag tracking and supports alert triggers when lag exceeds your defined thresholds, helping you catch performance issues before they impact read consistency or failover readiness.

Does this Skill work with existing database deployments?▼

Yes. The Skill guides you through configuration by collecting your existing master and replica connection details, replication parameters, and failover preferences. It then generates and executes commands to establish replication on your current PostgreSQL or MySQL instances without requiring a full database migration.

What prerequisites do I need before setting up replication?▼

You need at least two running PostgreSQL or MySQL instances, network connectivity between them, appropriate user privileges for replication operations, and knowledge of connection details like host, port, and credentials. The Skill prompts for this information during configuration.