Which databases are supported by this skill?

This skill primarily supports PostgreSQL and MySQL, facilitating both physical and logical replication strategies.

How does this skill handle replication lag?

It allows you to set specific thresholds for replication lag and configure alerts to notify you when those limits are exceeded.

Can Claude help with automatic failover?

Yes, the skill can configure automatic failover settings to ensure your database cluster remains available during primary node failure.

Does it support read scaling?

Absolutely. The skill helps implement read scaling by configuring and distributing read-only queries across multiple database replicas to improve performance.

Is this skill suitable for production environments?

Yes, it follows industry best practices for replication and high availability, though manual verification of failover procedures is always recommended for production safety.

Database Replication Manager

Name: Database Replication Manager
Author: jeremylongshore

byjeremylongshore

•

883

•

数据库管理

Automates the configuration and management of database replication, failover, and high availability for distributed SQL environments.

This skill empowers Claude to streamline complex database replication processes, including master-slave setups and high-availability configurations for PostgreSQL and MySQL. By automating tasks such as automatic failover, replication lag monitoring, and read scaling, it ensures data consistency and minimizes downtime across multi-instance database topologies. It is an essential tool for developers and DBAs looking to implement robust disaster recovery strategies and improve application performance through distributed read operations.

主要功能

01Read scaling implementation across multiple replicas

02Real-time replication lag monitoring and alerting

03Automated master-slave replication setup

04883 GitHub stars

05Configurable automatic failover and high availability

06Support for both physical and logical replication strategies

使用场景

01Setting up a highly available PostgreSQL cluster with automatic failover

02Implementing read scaling by distributing traffic across database replicas

03Monitoring MySQL replication lag to ensure data consistency between nodes

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills skill-adapter

For use in Claude.ai and ChatGPT

Download Skill