alloydb-omni-optimize · v1 · 2026-07-22 · sha256 6995f7d3fa46291a
alloydb-omni-optimize v1A
Immutable. This exact content never changes and is served at /api/v1/blob/6995f7d3fa46291a.
No tool to install first
claude plugin marketplace add https://markdownregistry.com/mp/a/art_ivpv6krsqz45olll/6995f7d3fa46291ab62f51c1e64a879ce14540ad9e86e69e2252d57571475b13.json
Then /plugin install alloydb-omni-optimize@markdownregistry-ivpv6krsqz45olll in Claude Code. It installs this exact version, the one graded A here, pinned to the commit it was graded at, and leaves it there.
---
name: alloydb-omni-optimize
description: Use these skills when you need to fine-tune the database engine settings,
manage extensions, or optimize the columnar engine for better analytical performance.
license: Apache-2.0
metadata:
version: v1
publisher: google
---
## 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 | No | |
: : : specific : : :
: : : configuration : : :
: : : parameter : : :
: : : name pattern : : :
: : : to search : : :
: : : for. : : :
| limit | integer | Optional: The | No | `50` |
: : : maximum : : :
: : : number of : : :
: : : rows to : : :
: : : return. : : :
--------------------------------------------------------------------------------