When should I choose Regional over Zonal availability?

Regional HA is recommended for production environments requiring an SLA, as it provides multi-zone failover with a recovery time of 60-120 seconds.

How does the skill determine the recommended machine type?

It uses a heuristic based on expected concurrent connections, ranging from db-f1-micro for light development to db-standard-4 and higher for production workloads.

Does this skill support other databases besides PostgreSQL?

While the specific machine tiers and patterns are optimized for PostgreSQL, the infrastructure sizing and high availability principles are broadly applicable to other Cloud SQL engines like MySQL.

Does the skill include VPC networking guidance?

Yes, it includes patterns for VPC networking and private IP configuration to ensure secure database connectivity.

Can this skill help with Terraform or IaC scripts?

Yes, it provides the configuration parameters and best practices required to build production-grade Terraform modules or Deployment Manager scripts.

GCP Cloud SQL Infrastructure

Name: GCP Cloud SQL Infrastructure
Author: ai-enhanced-engineer

byai-enhanced-engineer

0•

Cloud Infrastructure

Provisions and optimizes Google Cloud SQL PostgreSQL instances with production-ready patterns for machine sizing, storage, and high availability.

This skill empowers Claude to architect and manage Google Cloud SQL PostgreSQL infrastructure by providing domain-specific heuristics for machine type selection, storage performance, and disaster recovery strategies. It offers standardized patterns for environment-specific configurations—from cost-effective development setups to high-availability regional production clusters—ensuring that database deployments are right-sized, secure, and resilient based on specific workload requirements and concurrent connection needs.

Key Features

01Performance-optimized storage configuration (PD_SSD vs PD_HDD)

02High Availability (HA) design patterns for Zonal and Regional failover

030 GitHub stars

04Detailed cost-benefit matrices for dev, staging, and production tiers

05Tailored backup and Point-In-Time Recovery (PITR) strategy planning

06Automated machine type selection based on concurrent connection heuristics

Use Cases

01Architecting a new PostgreSQL instance for a high-traffic production environment with specific SLA requirements

02Optimizing cloud spend by right-sizing dev/test database instances using shared-core machines

03Designing disaster recovery and backup retention policies for enterprise compliance

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ai-enhanced-engineer/aiee-team gcp-cloudsql-infrastructure

For use in Claude.ai and ChatGPT

Download Skill