tmolavi/mcp-agent-skills-hub/alloydb-omni-optimize

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

list_autovacuum_configurations

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

list_available_extensions

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

list_columnar_configurations

List AlloyDB Omni columnar-related configurations (name and current setting) from pg_settings.

list_columnar_recommended_columns

Lists columns that AlloyDB Omni recommends adding to the columnar engine to improve query performance.

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

: : : specific : : : : : : configuration : : : : : : parameter : : : : : : name pattern : : : : : : to search : : : : : : for. : : :

: : : maximum : : : : : : number of : : : : : : rows to : : : : : : return. : : :