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
---
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.*
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