// Use these skills when you need to fine-tune the database engine settings, manage extensions, or optimize the columnar engine for better analytical performance.
Use these skills when you need to manage user roles, inspect permissions, and verify security-related configuration parameters.
Use these skills when you need to explore the database structure, identify schema objects like views and triggers, and execute SQL queries to interact with your data.
Use these skills when you need to audit database health, identify storage bloat, find broken indexes, and verify tablespace or maintenance configurations.
Use these skills when you need to troubleshoot production issues by identifying locks, tracking long-running transactions, and getting a high-level view of server state.
Use these skills when you need to analyze query performance, generate execution plans, check table/column statistics, and monitor overall database activity.
Use these skills when you need to monitor the health of database replication, manage sync states between nodes, and audit publication tables for distributed setups.
| 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. |
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.
List PostgreSQL autovacuum-related configurations (name and current setting) from pg_settings.
Discover all PostgreSQL extensions available for installation on this server, returning name, default_version, and description.
List AlloyDB Omni columnar-related configurations (name and current setting) from pg_settings.
Lists columns that AlloyDB Omni recommends adding to the columnar engine to improve query performance.
List all installed PostgreSQL extensions with their name, version, schema, owner, and description.
List PostgreSQL memory-related configurations (name and current setting) from pg_settings.
| 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 |