alloydb-postgres-optimize

Original：🇺🇸 English

Translated

6 scripts

Use these skills when you need to discover and manage PostgreSQL extensions or fine-tune engine-level settings such as memory allocation and server configuration parameters.

3installs

Sourcegemini-cli-extensions/alloydb

Added on2026-04-29

NPX Install

npx skill4agent add gemini-cli-extensions/alloydb alloydb-postgres-optimize

SKILL.md Content

View Translation Comparison →

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.

get_cluster

Retrieves details about a specific AlloyDB cluster.

Parameters

Name	Type	Description	Required
project	string	The GCP project ID. This is pre-configured; do not ask for it unless the user explicitly provides a different one.	No
location	string	The location of the cluster (e.g., 'us-central1').	Yes
cluster	string	The ID of the cluster.	Yes

list_available_extensions

Discover all PostgreSQL extensions available for installation on this server, returning name, default_version, and description.

list_installed_extensions

List all installed PostgreSQL extensions with their name, version, schema, owner, and description.

list_memory_configurations

List PostgreSQL memory-related configurations (name and current setting) from pg_settings.

list_pg_settings

Parameters

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

alloydb-postgres-optimize

NPX Install

Tags

SKILL.md Content

Usage

Scripts

database_overview

get_cluster

Parameters

list_available_extensions

list_installed_extensions

list_memory_configurations

list_pg_settings

Parameters