Alloydb omni optimize

Skill gemini-cli-extensions/alloydb-omni/skills/alloydb-omni-optimize

Use these skills when you need to fine-tune the database engine settings, manage extensions, or optimize the columnar engine for better analytical performance.From its SKILL.md

Install

npx -y skills add gemini-cli-extensions/alloydb-omni --skill alloydb-omni-optimize

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

4 stars4 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

SKILL.md

1.9 KB, as published. Nobody here has run it

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

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`