alloydb-omni-access-control

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_pg_settings

Parameters

Name	Type	Description	Required	Default
setting_name	string	Optional: A	No
: : : specific : : :
: : : configuration : : :
: : : parameter : : :
: : : name pattern : : :
: : : to search : : :
: : : for. : : :
limit	integer	Optional: The	No	50
: : : maximum : : :
: : : number of : : :
: : : rows to : : :
: : : return. : : :

---

list_roles

Lists all the user-created roles in the instance . It returns the role name, Object ID, the maximum number of concurrent connections the role can make, along with boolean indicators for: superuser status, privilege inheritance from member roles, ability to create roles, ability to create databases, ability to log in, replication privilege, and the ability to bypass row-level security, the password expiration timestamp, a list of direct members belonging to this role, and a list of other roles/groups that this role is a member of.

Parameters

Name	Type	Description	Required	Default
role_name	string	Optional: a text to filter	No
: : : results by role name. The input : : :
: : : is used within a LIKE clause. : : :
limit	integer	Optional: The maximum number of	No	50
: : : rows to return. Default is 10 : : :

---