skills.rest
interflownex
interflownexCOMMUNITY
Explore all skills by this author →
GitHub

cloud-sql-postgres-replication

Monitor PostgreSQL replication lag and audit database roles in Cloud SQL.

2|1|Updated May 25, 2026
Search Tags:#monitoring#security#database#postgresql#replication#cloud-sql
One-click install
npx skills add https://github.com/interflownex/All-in-One --skill cloud-sql-postgres-replication-interflownex
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: cloud-sql-postgres-replication
Source: https://github.com/interflownex/All-in-One/tree/main/.gemini/skills/cloud-sql-postgres-replication
Command: npx skills add https://github.com/interflownex/All-in-One --skill cloud-sql-postgres-replication-interflownex

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires @toolbox-sdk/server, and includes scripts (resource) components.

What problem does it solve?

This skill addresses the complexity of maintaining high-availability database clusters by providing automated visibility into replication lag, synchronization states, and security configurations.

Core Features & Use Cases

  • Replication Health Monitoring: Track replication lag across primary and standby nodes to ensure data consistency.
  • Security Auditing: List and verify database roles, privileges, and configuration parameters.
  • Use Case: A database administrator can use this skill to quickly identify which replication slot is causing WAL bloat or to audit user permissions across a production PostgreSQL instance.

Quick Start

Use the cloud-sql-postgres-replication skill to fetch the current replication statistics for the database instance.

Frequently Asked Questions about cloud-sql-postgres-replication

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

FAQPage Schema
How do I monitor PostgreSQL replication lag in Cloud SQL?▼

Monitoring PostgreSQL replication lag in Cloud SQL involves tracking synchronization states and replication statistics across primary and standby nodes. This skill fetches current replication data to provide automated visibility into cluster data consistency.

Why does PostgreSQL WAL bloat happen and how can I identify the replication slot causing it?▼

PostgreSQL WAL bloat happens when replication slots retain unflushed write-ahead logs. You can identify the replication slot causing WAL bloat by using this skill to fetch current replication statistics and track slot status.

How do I audit database roles and user privileges in a PostgreSQL instance?▼

Auditing database roles and user privileges in a PostgreSQL instance involves listing and verifying configuration parameters and access rights. This skill performs security auditing to list and verify database roles and privileges across the instance.

Can I use this PostgreSQL replication monitoring tool with cloud-based database environments?▼

Yes, you can use this PostgreSQL replication monitoring tool with cloud-based database environments. It interfaces with Cloud SQL PostgreSQL instances using the @toolbox-sdk/server package to track synchronization lag and manage security configurations.

Do I need the toolbox-sdk server package to manage Cloud SQL PostgreSQL replication health?▼

Yes, you need the @toolbox-sdk/server package to manage Cloud SQL PostgreSQL replication health. This dependency is required to interface with Cloud SQL PostgreSQL instances for tracking replication slots, synchronization lag, and user role privileges.

Related Skills

Explore More Software Engineering Skills→
interflownexinterflownex
2

cloud-sql-postgres-admin

Automate provisioning and administration of Google Cloud SQL for PostgreSQL instances.

Community
Intermediate
Nir-BhayNir-Bhay
19

database-replication-setup

Configure database replication across MySQL, PostgreSQL, and MongoDB systems.

Community
Advanced
IldarMinaevIldarMinaev
1

postgresql-troubleshooting-sql

Run SQL scripts to diagnose PostgreSQL health, replication, storage, and query performance.

Community
Advanced
manutejmanutej
61

PostgreSQL Database Administration

Automate PostgreSQL administration for customer support platform databases.

Community
Advanced