SkillRepo
Sign InSign Up
Catalog
google/alloydb-basics

google

alloydb-basics

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

global
0installs0uses—~574
v1.0Saved May 2, 2026

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:

    gcloud services enable alloydb.googleapis.com

  2. Create a Cluster:

    gcloud alloydb clusters create my-cluster --region=us-central1 \
    --password=my-password --network=my-vpc

    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:

    gcloud alloydb instances create my-primary --cluster=my-cluster \
    --region=us-central1 --instance-type=PRIMARY --cpu-count=2

Reference Directory

If you need product information not found in these references, use the Developer Knowledge MCP server search_documents tool.

Files7
7 files · 28.6 KB

Select a file to preview

Grade adjusted by static analysis guardrails

AI scored this skill as grade B, but static analysis findings capped it to C:

  • • Hardcoded credentials or secrets detected in content (max: C)

Overall Score

79/100

Grade

C

Adequate

Safety

72

Quality

85

Clarity

82

Completeness

78

Summary

This skill provides foundational guidance for managing AlloyDB for PostgreSQL clusters, instances, and backups using gcloud CLI, client libraries, Terraform, and the AlloyDB MCP server. It includes reference documentation on architecture, CLI commands, connection methods, IAM security, and infrastructure-as-code patterns, enabling AI agents to help users set up and operate AlloyDB resources.

Static Analysis Findings

1 finding

Patterns detected by deterministic static analysis before AI scoring. Hover over any finding code for detailed information and remediation guidance.

Credential Exposure
SEC-023Plaintext Password or Secret2x in 2 filesMax: C

Password or secret in plaintext

references/client-library-usage.mdpassword="my-password
references/iac-usage.mdpassword = "alloydb-cluster
85% confidenceCWE-256: Plaintext Storage of a Password

Detected Capabilities

Cluster creation and management via gcloud CLIInstance provisioning (primary and read pool)Backup creation and listingClient library setup (Python, Java, Go)Terraform resource configurationSecurity and IAM configuration guidanceMCP server integration for AI workloads

Trigger Keywords

Phrases that MCP clients use to match this skill to user intent.

alloydb cluster setupdatabase connection poolingterraform alloydbpostgresql managed servicegcp iam authenticationvector databasealloydb mcp integration

Risk Signals

WARNING

Password in plaintext: 'password="my-password"' in Python connector example

references/client-library-usage.md, Python Usage Example section
WARNING

Password in plaintext: 'password="my-password"' in Go connector example

references/client-library-usage.md, Go Usage Example section
WARNING

Password in plaintext: 'password = "alloydb-cluster"' in Terraform example

references/iac-usage.md, Terraform Example section
WARNING

Hardcoded credential in gcloud command: '--password=my-password'

SKILL.md, Quick Start section (Step 2)
WARNING

Hardcoded credential in gcloud command: '--password=my-password'

references/cli-usage.md, Clusters section

Referenced Domains

External domains referenced in skill content, detected by static analysis.

alloydb.region.rep.googleapis.comcloud.google.comdocs.cloud.google.comgithub.commcp-toolbox.devregistry.terraform.iowww.apache.org

Use Cases

  • Set up a new AlloyDB cluster with secure authentication
  • Connect to AlloyDB from Python, Java, Go, or Node.js applications
  • Deploy AlloyDB infrastructure using Terraform or Kubernetes Config Connector
  • Configure IAM authentication and security best practices
  • Integrate AlloyDB with AI applications via MCP server

Quality Notes

  • Positive: Well-structured reference directory with clear separation of concerns (CLI, client libraries, IAM, IaC, MCP)
  • Positive: Comprehensive examples for multiple programming languages and infrastructure approaches
  • Positive: Explicit security recommendations throughout, including strong warnings against Public IP with open Authorized Networks
  • Positive: Clear guidance on IAM authentication as the preferred approach over passwords
  • Positive: Comprehensive IAM roles table and security best practices documented
  • Positive: MCP usage section links to proper authentication setup and external resources
  • Caution: Plaintext passwords in code examples are documented for clarity but should be marked with prominent warnings about secrets management. The Quick Start does include a note recommending Secret Manager and IAM auth, but examples still show literals.
  • Positive: Terraform and KCC examples show both approaches for infrastructure declaration
  • Positive: All referenced domains and external links are legitimate Google Cloud documentation resources
  • Positive: Skill acknowledges when additional information should be sourced from external knowledge bases (e.g., Developer Knowledge MCP server)
Model: claude-haiku-4-5-20251001Analyzed: May 2, 2026

Reviews

Add this skill to your library to leave a review.

No reviews yet

Be the first to share your experience.

Add google/alloydb-basics to your library

Get Started Free

Command Palette

Search for a command to run...