alloydb-postgres-optimize · v1 · 2026-07-22 · sha256 2a650cab9af181d1

alloydb-postgres-optimize v1A

Immutable. This exact content never changes and is served at /api/v1/blob/2a650cab9af181d1.

No tool to install first
claude plugin marketplace add https://markdownregistry.com/mp/a/art_3oo3eoq2tfklgz6m/2a650cab9af181d117bf1f13f3d4b116e7e66711067553e2e53db02b7dd07915.json

Then /plugin install alloydb-postgres-optimize@markdownregistry-3oo3eoq2tfklgz6m 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-postgres-optimize
description: 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.
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


### 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 | Default |
| :--- | :--- | :--- | :--- | :--- |
| 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` |


---