Which databases are supported by this skill?

This skill is specifically designed to manage replication and high availability for PostgreSQL and MySQL databases.

How does it handle replication lag?

The skill allows you to set specific thresholds (e.g., 5 seconds). If replication delay exceeds this limit, it can trigger alerts or automated management actions.

Can this skill help with disaster recovery?

Yes, by configuring master-slave replication and automatic failover, the skill helps ensure your data remains available during a primary node failure.

What is the difference between physical and logical replication in this context?

The skill supports physical replication for exact block-level copies and logical replication for more flexible, granular data streaming between different database versions or architectures.

Database Replication Manager

Name: Database Replication Manager
Author: intent-solutions-io

byintent-solutions-io

0•

Database Management

Automates the setup and management of database replication, failover, and high availability configurations for PostgreSQL and MySQL.

The Database Replication Manager skill empowers Claude to handle complex database administration tasks by automating the deployment of master-slave topologies, configuring automatic failover mechanisms, and managing read scaling. It simplifies both physical and logical replication strategies, providing a streamlined interface for monitoring replication lag and ensuring data consistency across distributed environments. Whether you are building a disaster recovery plan or scaling read performance, this skill provides the necessary domain-specific guidance and automation to maintain a robust database infrastructure.

Key Features

01Configurable automatic failover for high availability

020 GitHub stars

03Automated master-slave replication setup

04Real-time replication lag monitoring and alerting

05Support for both physical and logical replication strategies

06Read scaling implementation via replica distribution

Use Cases

01Setting up a highly available PostgreSQL cluster with automatic failover

02Implementing read scaling for MySQL to handle high traffic volumes

03Monitoring database health and alerting on replication synchronization delays

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add intent-solutions-io/plugins-nixtla skill-adapter

For use in Claude.ai and ChatGPT

Download Skill