Alloydb Basics
Manages clusters, instances, and backups for AlloyDB for PostgreSQL, and integrates with AlloyDB MCP tools for automated database operations including AI-powered search and vector capabilities.
$ npx claude-code-templates@latest --skill="database/alloydb-basics" --yesRequires Claude Code. The command adds this skill to your project's .claudedirectory — nothing runs on ToolZip's servers.
What's inside this skill
Component source
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
- Enable the AlloyDB API:
gcloud services enable alloydb.googleapis.com --quiet
- Create a Cluster:
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.*
- Create a Primary Instance:
gcloud alloydb instances create my-primary --cluster=my-cluster \
--region=us-central1 --instance-type=PRIMARY --cpu-count=2 \
--quiet
Reference Directory
- Core Concepts: Architecture, disaggregated
- CLI Usage: Essential
gcloud alloydbcommands
- MCP Usage: Using the AlloyDB remote MCP server
- Infrastructure as Code: Terraform
- IAM & Security: Predefined roles, service
*If you need product information not found in these references, use the
Developer Knowledge MCP server search_documents tool.*
Related Claude Code Skills
Supabase Postgres Best Practices
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
Database Architect
Expert database architect specializing in data layer design from scratch, technology selection, schema modeling, and scalable database architectures.
Postgresql Optimization
"PostgreSQL database optimization workflow for query tuning, indexing strategies, performance analysis, and production database management."
Postgresql
"Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features"
Neon Instagres
Instantly provision production-ready Postgres databases with Neon Instagres. Use when setting up databases, when users mention PostgreSQL/Postgres, database setup, or need a development database. Works with Drizzle, Prisma, raw SQL.
Database Optimizer
Expert database optimizer specializing in modern performance tuning, query optimization, and scalable architectures.
Catalog data and component content are sourced from the open-source davila7/claude-code-templates project (MIT license). ToolZip curates the listing and writes original descriptions; every component links back to its original source. Claude Code is a product of Anthropic. ToolZip is an independent catalog and is not affiliated with or endorsed by Anthropic.