All skills
google avatar

/alloydb-basics

@becc4b8
by googlegoogle/skills21k stars
1,698

Manages clusters, instances, and backups for AlloyDB for PostgreSQL, and integrates with AlloyDB Model Context Protocol (MCP) tools for automated database operations. Use when creating, configuring, or administering AlloyDB databases. Do NOT use for general PostgreSQL instances (e.g. Cloud SQL) or other GCP databases.

Use this Skill: https://skilld.dev/gh/google/skills/alloydb-basics

This session only. Nothing lands on disk.

referencescli-usage.md

≈891 tokens on demand. Your agent reads this file only when SKILL.md points to it.

AlloyDB CLI Usage

Ensure you have the Google Cloud SDK installed and authenticated (gcloud auth login) before running these commands.

Manage AlloyDB resources using the gcloud alloydb command group.

Clusters

  • Create a cluster:

    gcloud alloydb clusters create CLUSTER_ID --region=REGION \
        --password=PASSWORD --network=VPC_NAME
  • List clusters:

    gcloud alloydb clusters list --region=REGION
  • Get cluster information:

    gcloud alloydb clusters describe CLUSTER_ID --region=REGION
  • Delete a cluster:

    gcloud alloydb clusters delete CLUSTER_ID --region=REGION
    

    Instances

  • Create a primary instance:

    gcloud alloydb instances create INSTANCE_ID --cluster=CLUSTER_ID \
        --region=REGION --instance-type=PRIMARY --cpu-count=8
  • Create a read pool instance:

    gcloud alloydb instances create INSTANCE_ID --cluster=CLUSTER_ID \
        --region=REGION --instance-type=READ_POOL \
        --read-pool-node-count=2 --cpu-count=2
  • List instances:

    gcloud alloydb instances list --cluster=CLUSTER_ID --region=REGION
  • Restart an instance:

    gcloud alloydb instances restart INSTANCE_ID --cluster=CLUSTER_ID \
        --region=REGION
  • Scale read pool horizontally (node count):

    gcloud alloydb instances update INSTANCE_ID --cluster=CLUSTER_ID \
        --region=REGION --read-pool-node-count=NODE_COUNT
  • Scale instance vertically (CPU count):

    gcloud alloydb instances update INSTANCE_ID --cluster=CLUSTER_ID \
        --region=REGION --cpu-count=CPU_COUNT
  • Scale instance vertically (machine type):

    gcloud alloydb instances update INSTANCE_ID --cluster=CLUSTER_ID \
        --region=REGION --machine-type=MACHINE_TYPE

Backups & Restore

  • Create an on-demand backup:

    gcloud alloydb backups create BACKUP_ID --cluster=CLUSTER_ID \
        --region=REGION
  • List backups:

    gcloud alloydb backups list --region=REGION
  • Configure continuous backup recovery window:

    gcloud alloydb clusters update CLUSTER_ID --region=REGION \
        --continuous-backup-recovery-window-days=DAYS
  • Enable and configure automated scheduled backups:

    gcloud alloydb clusters update CLUSTER_ID --region=REGION \
        --automated-backup-days-of-week=DAYS_OF_WEEK \
        --automated-backup-start-times=START_TIMES \
        --automated-backup-retention-period=RETENTION_PERIOD

    Example: --automated-backup-days-of-week=MONDAY,WEDNESDAY,FRIDAY --automated-backup-start-times=01:00 --automated-backup-retention-period=30d

  • Disable automated backups:

    gcloud alloydb clusters update CLUSTER_ID --region=REGION \
        --disable-automated-backup
  • Restore from a discrete backup:

    gcloud alloydb clusters restore DEST_CLUSTER_ID --region=REGION \
        --backup=BACKUP_ID
  • Restore to a point in time (PITR):

    gcloud alloydb clusters restore DEST_CLUSTER_ID --region=REGION \
        --source-cluster=SOURCE_CLUSTER_ID \
        --point-in-time=TIMESTAMP

    Note: TIMESTAMP must be in RFC 3339 format, e.g. 2026-07-30T15:00:00.00Z.

Source: SKILL.md on GitHub

No alerts10d3 checks · Risk SAFE
  • Gen Agent Trust Hub10d

    This skill provides comprehensive guidance for managing AlloyDB resources and incorporates numerous security best practices, such as recommending IAM authentication and private network configurations. It includes some external references and command templates that warrant standard review during use.

  • Socket10d

    No alerts

  • Snyk10d

    Risk: LOW · No issues

Signed by skilld at becc4b8. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub yesterday.

Activeupdated 2 weeks ago
metadata
{
  "version": "1.0.0",
  "category": "Databases"
}

README badge

README badge for google/skills/alloydb-basics