Postgresql Replication

Name: Postgresql Replication
Author: pluginagentmarketplace

🌐Community

by pluginagentmarketplace · vlatest · Repository

Automates PostgreSQL replication setup, monitoring, and failover for high availability and data protection.

Install on your platform

We auto-selected Claude Code based on this skill’s supported platforms.

Run in terminal (recommended)

terminal

claude mcp add postgresql-replication npx -- -y @trustedskills/postgresql-replication

Or manually add to ~/.claude/settings.json

~/.claude/settings.json

{
  "mcpServers": {
    "postgresql-replication": {
      "command": "npx",
      "args": [
        "-y",
        "@trustedskills/postgresql-replication"
      ]
    }
  }
}

Requires Claude Code (claude CLI). Run claude --version to verify your install.

About This Skill

What it does

This skill facilitates PostgreSQL replication, allowing for data to be copied from one database server (the primary) to another (the replica). This provides redundancy and read scalability by offloading read queries to the replica. The skill can configure both streaming replication and logical decoding for flexible data synchronization.

When to use it

Disaster Recovery: Set up a standby PostgreSQL server in a different location for failover in case of primary server failure.
Read Scalability: Distribute read-only queries across multiple replica servers, reducing load on the primary database.
Data Analytics/Reporting: Create replicas specifically for running analytical queries without impacting the performance of the main transactional database.
Geographic Distribution: Deploy a replica closer to users in different regions to minimize latency for data access.

Key capabilities

Streaming Replication
Logical Decoding
Configuration Management
Redundancy and Failover Support

Example prompts

"Configure PostgreSQL streaming replication from server A to server B."
"Set up a logical decoding replica for database analytics."
“Create a standby PostgreSQL instance in AWS us-west-2.”

Tips & gotchas

Requires appropriate permissions on both the primary and replica servers.
Network connectivity between the primary and replica is essential for replication to function correctly.

View Repository →

TrustedSkills Verification

Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.

Security Audits

Gen Agent Trust Hub	Pass
Socket	Pass
Snyk	Pass

Details

Version: vlatest
License
Author: pluginagentmarketplace
Installs: 2

Repository (canonical source) →

🌐 Community

Passed automated security scans.