mcpField
D
data-replication-setup

data-replication-setup

github.com/aj-geddesData & databases373421 installsUpdated 34w ago
Repository

About data-replication-setup

A database replication setup skill for teams planning availability, disaster recovery, or read scaling. It covers primary-standby and multi-master approaches, replication monitoring, and related configuration guides.

Key features

  1. 01Primary-standby replication
  2. 02Multi-master replication
  3. 03Logical replication
  4. 04Monitoring and maintenance guidance
  5. 05Failover and recovery planning

Use cases

  1. 01Configuring read replicas
  2. 02Planning disaster recovery
  3. 03Setting up multi-region replication
  4. 04Monitoring replication health

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/aj-geddes/useful-ai-prompts --skill data-replication-setup

After installing, type/data-replication-setupin Claude Code to confirm it loaded.

Bundled files

References and scripts installed along with SKILL.md.

references/
logical-replication.md
master-slave-primary-standby-setup.md
master-slave-setup.md
scripts/
validate-schema.sh
templates/
migration-template.sql

Details

From the project README

Data Replication Setup

Table of Contents

Overview

Configure database replication for disaster recovery, load distribution, and high availability. Covers master-slave, multi-master replication, and monitoring strategies.

When to Use

  • High availability setup
  • Disaster recovery planning
  • Read replica configuration
  • Multi-region replication
  • Replication monitoring and maintenance
  • Failover automation
  • Cross-region backup strategies

Quick Start

PostgreSQL - Configure Primary Server:

-- On primary server: postgresql.conf
-- wal_level = replica
-- max_wal_senders = 10
-- wal_keep_size = 1GB

-- Create replication user
CREATE ROLE replication_user WITH REPLICATION ENCRYPTED PASSWORD 'secure_password';

-- Allow replication connections: pg_hba.conf
-- host    replication     replication_user   standby_ip/32    md5

-- Enable WAL archiving for continuous backup
-- archive_mode = on
-- archive_command = 'test ! -f /archive/%f && cp %p /archive/%f'

Reference Guides

Detailed implementations in the references/ directory:

GuideContents
Master-Slave (Primary-Standby) SetupMaster-Slave (Primary-Standby) Setup
Logical ReplicationLogical Replication
Master-Slave SetupMaster-Slave Setup

Best Practices

✅ DO
  • Follow established patterns and conventions
  • Write clean, maintainable code
  • Add appropriate documentation
  • Test thoroughly before deploying
❌ DON'T
  • Skip testing or validation
  • Ignore error handling
  • Hard-code configuration values

Comments

Markdown supported