Skip to content

aktonay/skillz / skills/cloud/alloydb-basics

alloydb-basics

Verified

Manages clusters, instances, and backups for AlloyDB for PostgreSQL, and integrates with AlloyDB model context protocol (MCP) tools for automated database operations.

FileKindSize
SKILL.mdskill md2.3 KB
references/cli-usage.mdmarkdown1.2 KB
references/client-library-usage.mdmarkdown5.4 KB
references/core-concepts.mdmarkdown2.1 KB
references/iac-usage.mdmarkdown3.2 KB
references/iam-security.mdmarkdown4.3 KB
references/mcp-usage.mdmarkdown1.3 KB

references/cli-usage.md

View on GitHub
# AlloyDB CLI Usage

AlloyDB resources are managed using the `gcloud alloydb` command group.

## Clusters

1. Create a cluster: `gcloud alloydb clusters create CLUSTER_ID --region=REGION
   --password=PASSWORD`

2. List clusters: `gcloud alloydb clusters list --region=REGION`

3. Get cluster info: `gcloud alloydb clusters describe CLUSTER_ID
   --region=REGION`

4. Delete a cluster: `gcloud alloydb clusters delete CLUSTER_ID --region=REGION`

## Instances

1. Create a primary instance: `gcloud alloydb instances create INSTANCE_ID
   --cluster=CLUSTER_ID --region=REGION --instance-type=PRIMARY --cpu-count=8`

2. 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`

3. List instances: `gcloud alloydb instances list --cluster=CLUSTER_ID
   --region=REGION`

4. Restart an instance: `gcloud alloydb instances restart INSTANCE_ID
   --cluster=CLUSTER_ID --region=REGION`

## Backups

1. Create a backup: `gcloud alloydb backups create BACKUP_ID
   --cluster=CLUSTER_ID --region=REGION`

2. List backups: `gcloud alloydb backups list --region=REGION`
deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall