cloud-sql-postgres-admin

Category: Databases & Storage | Uploader: gemini-cli-extensions | Downloads: 0 | Version: v1.0（Latest）

Use these skills when you need to provision new Cloud SQL instances, create databases and users, clone existing environments, and monitor the progress of long-running operations.

Changelog: Source: GitHub https://github.com/gemini-cli-extensions/cloud-sql-postgresql

Directory Structure

Current level: tree/main/skills/cloud-sql-postgres-admin/

📁 scripts/
- 📄 clone_instance.js 3.1 KB
- 📄 create_backup.js 2.8 KB
- 📄 create_database.js 3.1 KB
- 📄 create_instance.js 3.1 KB
- 📄 create_user.js 3.1 KB
- 📄 get_instance.js 3.1 KB
- 📄 list_databases.js 3.1 KB
- 📄 list_instances.js 3.1 KB
- 📄 postgres_upgrade_precheck.js 2.8 KB
- 📄 restore_backup.js 2.8 KB
- 📄 wait_for_operation.js 3.1 KB
📄 SKILL.md 8.5 KB

SKILL.md

---
name: cloud-sql-postgres-admin
description: Use these skills when you need to provision new Cloud SQL instances, create databases and users, clone existing environments, and monitor the progress of long-running operations.
---

## 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

### clone_instance

Clone an existing Cloud SQL instance into a new instance. The clone can be a direct copy of the source instance, or a point-in-time-recovery (PITR) clone from a specific timestamp. The call returns a Cloud SQL Operation object. Call wait_for_operation tool after this, make sure to use multiplier as 4 to poll the opertation status till it is marked DONE.

#### 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       |         |
| sourceInstanceName      | string | The name of the instance to be cloned.                                                                             | Yes      |         |
| destinationInstanceName | string | The name of the new instance that will be created by cloning the source instance.                                  | Yes      |         |
| pointInTime             | string | The timestamp in RFC 3339 format to which the source instance should be cloned.                                    | No       |         |
| preferredZone           | string | The preferred zone for the new instance.                                                                           | No       |         |
| preferredSecondaryZone  | string | The preferred secondary zone for the new instance.                                                                 | No       |         |

---

### create_database

#### 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       |         |
| instance | string | The ID of the instance where the database will be created.                                                         | Yes      |         |
| name     | string | The name for the new database. Must be unique within the instance.                                                 | Yes      |         |

---

### create_instance

#### 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       |               |
| name            | string | The name of the instance                                                                                                                                 | Yes      |               |
| databaseVersion | string | The database version for Postgres. If not specified, defaults to the latest available version (e.g., POSTGRES_17).                                       | No       | `POSTGRES_17` |
| rootPassword    | string | The root password for the instance                                                                                                                       | Yes      |               |
| editionPreset   | string | The edition of the instance. Can be `Production` or `Development`. This determines the default machine type and availability. Defaults to `Development`. | No       | `Development` |

---

### create_user

#### 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       |         |
| instance | string  | The ID of the instance where the user will be created.                                                             | Yes      |         |
| name     | string  | The name for the new user. Must be unique within the instance.                                                     | Yes      |         |
| password | string  | A secure password for the new user. Not required for IAM users.                                                    | No       |         |
| iamUser  | boolean | Set to true to create a Cloud IAM user.                                                                            | Yes      |         |

---

### get_instance

#### Parameters

| Name       | Type   | Description                                                                                                        | Required | Default |
| :--------- | :----- | :----------------------------------------------------------------------------------------------------------------- | :------- | :------ |
| projectId  | string | The GCP project ID. This is pre-configured; do not ask for it unless the user explicitly provides a different one. | No       |         |
| instanceId | string | The instance ID                                                                                                    | Yes      |         |

---

### list_databases

Lists all databases for a Cloud SQL instance.

#### 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       |         |
| instance | string | The instance ID                                                                                                    | Yes      |         |

---

### list_instances

Lists all type of Cloud SQL instances for a project.

#### 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       |         |

---

### wait_for_operation

#### 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       |         |
| operation | string | The operation ID                                                                                                   | Yes      |         |

---

Comments 0

Latest | Hot

Please login before commenting.

Loading comments...

cloud-sql-postgres-admin

Directory Structure

SKILL.md

Report

Notice