alloydb-omni-replication

name	alloydb-omni-replication
description	Use these skills when you need to monitor the health of database replication, manage sync states between nodes, and audit publication tables for distributed setups.

Usage

All scripts can be executed using Node.js. Replace <param_name> and <param_value> with actual values.

Bash: node <skill_dir>/scripts/<script_name>.js '{"<param_name>": "<param_value>"}'

PowerShell: node <skill_dir>/scripts/<script_name>.js '{\"<param_name>\": \"<param_value>\"}'

Note: The scripts automatically load the environment variables from various .env files. Do not ask the user to set vars unless skill executions fails due to env var absence.

Scripts

database_overview

Fetches the current state of the PostgreSQL server, returning the version, whether it's a replica, uptime duration, maximum connection limit, number of current connections, number of active connections, and the percentage of connections in use.

---

list_publication_tables

Parameters

Name	Type	Description	Required	Default
table_names	string	Optional: Filters by a comma-separated list of table names.	No
publication_names	string	Optional: Filters by a comma-separated list of publication names.	No
schema_names