gcp-cloudsql-infrastructure
Skill4 starsChanged 5 months agoMITView on GitHub
Cloud SQL PostgreSQL infrastructure provisioning and operations. Machine type selection, storage sizing, HA configuration, backup strategies, VPC networking. Use when configuring Cloud SQL instances, planning database capacity, setting up backups, or designing high availability.
In this repository101 other files it gives its agents.
- ai-video-understandingSkill
- apple-foundation-modelsSkill
- arch-dddSkill
- arch-decision-recordsSkill
- arch-diagramsSkill
- arch-eventsSkill
- arch-mvp-roadmapSkill
- arch-python-modernSkill
- aws-app-runnerSkill
- aws-cicd-patternsSkill
- aws-security-hardeningSkill
- azure-functions-python-v2Skill
- azure-identity-m2m-authSkill
- azure-service-bus-messagingSkill
- azure-workflow-execution-modelsSkill
- caddy-tls-proxySkill
- compliance-frameworksSkill
- design-system-workflowSkill
- dev-debugging-strategiesSkill
- dev-standardsSkill
- docker-python-poetrySkill
- docker-pythonSkill
- fastapi-patternsSkill
- ffmpeg-laravel-videoSkill
- formik-yup-react-nativeSkill
- frontend-accessibilitySkill
- frontend-angular-aiSkill
- frontend-angularSkill
- frontend-angular-toolingSkill
- frontend-design-systemsSkill
- frontend-material-chatSkill
- frontend-material-design-3Skill
- frontend-svelteSkill
- gcp-cicd-patternsSkill
- gcp-cloud-runSkill
- gcp-finopsSkill
- gcp-observabilitySkill
- gcp-security-hardeningSkill
- github-actions-cicdSkill
- healthkit-biofeedbackSkill
- infra-terraformSkill
- ios-app-qualitySkill
- ios-audio-hapticsSkill
- jest-nestjs-testingSkill
- langchain-azure-openai-patternsSkill
- laravel-auth-hardeningSkill
- laravel-ci-mysqlSkill
- laravel-mix-webpackSkill
- laravel-modern-patternsSkill
- laravel-pint-patternsSkill
- laravel-s3-storageSkill
- laravel-sail-dockerSkill
- mobile-app-deploymentSkill
- mobile-e2e-testingSkill
- mobile-offline-syncSkill
- mobile-push-notificationsSkill
- mobile-video-uploadSkill
- mongodb-asyncmongoclient-patternsSkill
- mongodb-atlas-patternsSkill
- nestjs-patternsSkill
- The first 60 shown.
The file
Files
Cloud SQL Infrastructure
Infrastructure-level patterns for Google Cloud SQL PostgreSQL provisioning and operations.
Machine Type Selection
| Type | vCPU | RAM | Cost/mo | Use Case |
db-f1-micro | Shared | 0.6GB | ~$16 | Dev/test only (CPU throttling) |
db-g1-small | Shared | 1.7GB | ~$28 | Light staging workloads |
db-standard-1 | 1 | 3.75GB | ~$68 | Production-like staging |
db-standard-2 | 2 | 7.5GB | ~$136 | Small production |
db-standard-4 | 4 | 15GB | ~$272 | Medium production |
Selection Heuristics
| Concurrent Connections | Recommended Tier |
| <10 | db-f1-micro (dev only) |
| 10-30 | db-g1-small |
| 30-100 | db-standard-1 |
| 100-300 | db-standard-2 |
| 300+ | db-standard-4 or higher |
Storage Types
| Type | $/GB/mo | IOPS | Latency | Use Case |
PD_HDD | $0.09 | Lower | 10-20ms | Cost-sensitive staging |
PD_SSD | $0.17 | Higher | 1-5ms | Production, performance testing |
PD_HDD runs ~10–20ms latency vs PD_SSD at ~1–5ms — HDD noticeably degrades response time on query-latency-sensitive workloads.
High Availability
| Mode | Description | Cost | Use When |
ZONAL | Single zone | Base | Staging, cost-sensitive prod |
REGIONAL | Multi-zone failover | +35% | Production with SLA requirements |
Failover time: 60-120 seconds for REGIONAL HA.
Backup Strategies
| Environment | Retention | PITR | Rationale |
| Staging | 3 days | No | Cost savings, easy to recreate |
| Production | 30 days | Yes | Compliance, disaster recovery |
Quick Decision Matrix
| Scenario | Machine | Storage | HA | Monthly Cost |
| Dev/Test | db-f1-micro | 10GB HDD | ZONAL | ~$17 |
| Staging | db-g1-small | 20GB HDD | ZONAL | ~$30 |
| Prod (small) | db-standard-1 | 50GB SSD | REGIONAL | ~$110 |
| Prod (medium) | db-standard-2 | 100GB SSD | REGIONAL | ~$200 |
See reference.md for sizing calculations, VPC networking, and Terraform patterns.
See examples.md for complete Terraform configurations.
Does it work?
Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.
No reviews yet
People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.
- It worked
- Partly
- It didn't
Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.
Your trail
Files you open will collect here, so you can find them again.
Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.
Now do this for your own.
Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.