aktonay/skillz / skills/cloud/alloydb-basics
alloydb-basics
VerifiedManages clusters, instances, and backups for AlloyDB for PostgreSQL, and integrates with AlloyDB model context protocol (MCP) tools for automated database operations.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 2.3 KB |
| references/cli-usage.md | markdown | 1.2 KB |
| references/client-library-usage.md | markdown | 5.4 KB |
| references/core-concepts.md | markdown | 2.1 KB |
| references/iac-usage.md | markdown | 3.2 KB |
| references/iam-security.md | markdown | 4.3 KB |
| references/mcp-usage.md | markdown | 1.3 KB |
SKILL.md
View on GitHub---
name: alloydb-basics
description: >-
Manages clusters, instances, and backups for AlloyDB for PostgreSQL, and
integrates with AlloyDB model context protocol (MCP) tools for automated database operations.
---
# AlloyDB Basics
AlloyDB for PostgreSQL is a managed, PostgreSQL-compatible database service
designed for enterprise-grade performance and availability. It utilizes a
disaggregated compute and storage architecture to scale resources independently.
It also provides AlloyDB AI, a collection of features that includes AI-powered
search (vector, hybrid search, and AI functions), natural language capabilities,
conversational analytics, and inference features like forecasting and model
endpoint management to help developers build AI apps faster.
## Quick Start
1. **Enable the AlloyDB API:**
```bash
gcloud services enable alloydb.googleapis.com --quiet
```
2. **Create a Cluster:**
```bash
gcloud alloydb clusters create my-cluster --region=us-central1 \
--password=my-password --network=my-vpc \
--quiet
```
*Note: For production, we recommend using IAM database authentication
instead of passwords. If passwords must be used, use secure secret
management (e.g., Secret Manager) instead of passing passwords in
cleartext.*
3. **Create a Primary Instance:**
```bash
gcloud alloydb instances create my-primary --cluster=my-cluster \
--region=us-central1 --instance-type=PRIMARY --cpu-count=2 \
--quiet
```
## Reference Directory
- [Core Concepts](references/core-concepts.md): Architecture, disaggregated
storage, and performance features.
- [CLI Usage](references/cli-usage.md): Essential `gcloud alloydb` commands
for cluster and instance management.
- [Client Libraries & Connectors](references/client-library-usage.md):
Connecting to AlloyDB using Python, Java, Node.js, and Go.
- [MCP Usage](references/mcp-usage.md): Using the AlloyDB remote MCP server
and Gemini CLI extension.
- [Infrastructure as Code](references/iac-usage.md): Terraform
configuration and deployment examples.
- [IAM & Security](references/iam-security.md): Predefined roles, service
agents, and database authentication.
*If you need product information not found in these references, use the
Developer Knowledge MCP server `search_documents` tool.*Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| 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: 119k | Updated | Claude CodeCodex | Verified | Install |
| 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: 119k | Updated | Claude CodeCodex | Verified | Install |
| 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: 118k | Updated | Claude CodeCodex | Verified | Install |
| 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: 118k | Updated | Claude CodeCodex | Verified | Install |