tmolavi/mcp-agent-skills-hub/alloydb-postgres-admin
Claude Code and agent skill by tmolavi/mcp-agent-skills-hub
- community
Checking that the SKILL.md file is still in the repository.
Use these skills when you need to provision new AlloyDB clusters and
Install
npx vskill@latest install tmolavi/mcp-agent-skills-hub/alloydb-postgres-adminSKILL.md
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
create_cluster
Creates a new AlloyDB cluster. This is a long-running operation, but the API call returns quickly. This will return operation id to be used by get operations tool. Take all parameters from user in one go.
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 to create the cluster in. The default value is us-central1. If quota is exhausted then use other regions. | No | us-central1 | |
| cluster | string | A unique ID for the AlloyDB cluster. | Yes | ||
| password | string | A secure password for the initial user. | Yes | ||
| network | string | The name of the VPC network to connect the cluster to (e.g., 'default'). | No | default | |
| user | string | The name for the initial superuser. Defaults to 'postgres' if not provided. | No |
create_instance
Creates a new AlloyDB instance (PRIMARY or READ_POOL) within a cluster. This is a long-running operation. This will return operation id to be used by get operations tool. Take all parameters from user in one go.
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 to create the instance in. | Yes | ||
| instance | string | A unique ID for the new AlloyDB instance. | Yes | ||
| instanceType | string | The type of instance to create. Valid values are: PRIMARY and READ_POOL. Default is PRIMARY | No | PRIMARY | |
| displayName | string | An optional, user-friendly name for the instance. | No | ||
| nodeCount | integer | The number of nodes in the read pool. Required only if instanceType is READ_POOL. Default is 1. | No | 1 |
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 |
get_instance
Retrieves details about a specific AlloyDB 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 | ||
| location | string | The location of the instance (e.g., 'us-central1'). | Yes | ||
| cluster | string | The ID of the cluster. | Yes | ||
| instance | string | The ID of the instance. | Yes |
list_clusters
Lists all AlloyDB clusters in a given project and location.
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 | Optional: The location to list clusters in (e.g., 'us-central1'). Use '-' to list clusters across all locations.(Default: '-') | No | - |
list_instances
Lists all AlloyDB instances in a given project, location and 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 | Optional: The location of the cluster (e.g., 'us-central1'). Use '-' to get results for all regions.(Default: '-') | No | - | |
| cluster | string | Optional: The ID of the cluster to list instances from. Use '-' to get results for all clusters.(Default: '-') | No | - |
wait_for_operation
This will poll on operations API until the operation is done. For checking operation status we need projectId, locationID and operationId. Once instance is created give follow up steps on how to use the variables to bring data plane MCP server up in local and remote setup.
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 ID | Yes | ||
| operation | string | The operation ID | Yes |
Security
- Security scanPassed, 90 of 100Pattern checks on the skill's files.
- Model reviewPassed
Quality evaluation
- Task evaluationNot runNo evaluation yet. Run one in Skill Studio.
Source
- SKILL.md in the repositoryCheckingskills/alloydb-postgres-admin/SKILL.md
Popularity
- Repository stars
- 8
- 7-day trend score
- 11
Stars and forks are for the whole GitHub repository, not this skill alone. Not refreshed yet.
Works with
Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.
- Claude Code
- Cursor
- GitHub Copilot
- Windsurf
- Codex
- Gemini CLI
- Cline
- Amp
- Roo Code
- Goose
- Continue
- Kilo Code
- Junie
- Trae
- OpenHands
- Qwen Code
- AI Agent
- Tabnine Chat
- Sourcegraph Cody
- Amazon Q
- Firebase Genkit
- Sweep
- Devin
- Phind
- Mentat
- Claude Desktop
- Aider
- GPT Pilot
- Plandex
- bolt.new
- v0
- Replit Agent
- Anse
- TypingMind
- BetterChatGPT
- LibreChat
- Warp AI
- Pieces
- Fig AI
Embed badge
[](https://verified-skill.com/skills/tmolavi/mcp-agent-skills-hub/alloydb-postgres-admin)