gcp-cloud-sql

Provision Cloud SQL and Spanner databases. Configure high availability, backups, and security. Use when deploying managed databases on GCP.

Ir a la instalación

Repositorio: BagelHole/DevOps-Security-Agent-Skills
Última actividad en el origen: 24 de marzo de 2026 a las 22:02
Idioma detectado de SKILL.md: inglés
Estrellas: 49
Forks: 4

Opciones de instalación

De forma predeterminada está seleccionado el prompt que primero revisa el origen. Puedes cambiar a un comando directo o descargar una copia local.

Instalar con Codex o Claude Copia este prompt, pégalo en Codex, Claude u otro asistente, y deja que revise la página de la skill y la instale por ti.

Un comando directo omite el prompt de revisión. Revisa el origen antes de ejecutarlo.

npx skills add https://github.com/BagelHole/DevOps-Security-Agent-Skills --skill gcp-cloud-sql

El comando permanece en una sola línea. Desplázate horizontalmente para revisarlo antes de copiarlo.

¿Prefieres una copia local? Descarga los archivos que SkillsMP tiene disponibles ahora.

Revisa los archivos de origen

Lee SKILL.md y los archivos complementarios que muestra SkillsMP antes de decidir si quieres instalarlo.

SKILL.md

Instrucciones de origen · Vista previa de solo lectura

Volver a la búsqueda Volver a la instalación

ai-pipeline-orchestration

Orchestrate AI/ML pipelines for data ingestion, model training, batch inference, and RAG indexing using Prefect, Airflow, or Dagster. Build reliable, observable, and retriable workflows for production AI systems.

2026-05-22

llm-caching

Implement multi-layer LLM caching with exact match, semantic similarity, and provider-side prompt caching. Reduce API costs by 30–70%, cut latency, and improve throughput using Redis, GPTCache, and provider caching APIs.

2026-05-22

llm-cost-optimization

Reduce LLM API and infrastructure costs through model selection, prompt caching, batching, caching, quantization, and self-hosting strategies. Track spend by team and model, set budgets, and implement cost-aware routing.

2026-05-22

Ver todos los de este repositorio

name	gcp-cloud-sql
description	Provision Cloud SQL and Spanner databases. Configure high availability, backups, and security. Use when deploying managed databases on GCP.
license	MIT
metadata	{"author":"devops-skills","version":"1.0"}

GCP Cloud SQL

Deploy and manage fully managed relational databases (PostgreSQL, MySQL, SQL Server) on Google Cloud.

When to Use

Running production relational databases without managing replication, patching, or backups
Migrating on-premises PostgreSQL or MySQL workloads to a managed service
Applications requiring ACID transactions, relational schemas, and SQL query support
Workloads that need automated high availability with regional failover

Prerequisites

Google Cloud SDK (gcloud) installed and authenticated
Cloud SQL Admin API and Service Networking API enabled
IAM role roles/cloudsql.admin for full management

gcloud services enable sqladmin.googleapis.com servicenetworking.googleapis.com

Instance Tiers Reference

Tier	vCPUs	Memory	Use Case
db-f1-micro	Shared

resource "google_sql_database_instance" "main" { name = "prod-db" database_version = "POSTGRES_16" region = "us-central1" settings { tier = "db-custom-4-16384" availability_type = "REGIONAL" disk_type = "PD_SSD" disk_size = 100 disk_autoresize = true backup_configuration { enabled = true start_time = "02:00" point_in_time_recovery_enabled = true backup_retention_settings { retained_backups = 14 } } ip_configuration { ipv4_enabled = false private_network = google_compute_network.vpc.id require_ssl = true } maintenance_window { day = 7; hour = 4 } database_flags { name = "max_connections"; value = "200" } user_labels = { env = "production" } } deletion_protection = true depends_on = [google_service_networking_connection.private_vpc] } resource "google_sql_database" "app" { name = "myapp" instance = google_sql_database_instance.main.name } resource "google_sql_user" "app" { name = "appuser" instance = google_sql_database_instance.main.name password = random_password.db_password.result } resource "google_sql_database_instance" "replica" { name = "prod-db-replica-1" master_instance_name = google_sql_database_instance.main.name region = "us-central1" database_version = "POSTGRES_16" replica_configuration { failover_target = false } settings { tier = "db-custom-4-16384" disk_type = "PD_SSD" disk_autoresize = true ip_configuration { ipv4_enabled = false private_network = google_compute_network.vpc.id } } } resource "google_compute_global_address" "private_ip" { name = "google-managed-services" purpose = "VPC_PEERING" address_type = "INTERNAL" prefix_length = 16 network = google_compute_network.vpc.id } resource "google_service_networking_connection" "private_vpc" { network = google_compute_network.vpc.id service = "servicenetworking.googleapis.com" reserved_peering_ranges = [google_compute_global_address.private_ip.name] }

Method	Use Case	Requirement
Public IP + SSL	Dev/test access	Authorized networks configured
Cloud SQL Auth Proxy	Production on GCE/GKE	SA with `roles/cloudsql.client`
Private IP	VPC-native apps	VPC peering configured
Cloud SQL Connector lib	App-level integration	SA credentials

Symptom	Cause	Fix
`Connection refused` via public IP	IP not in authorized networks	Add IP with `gcloud sql instances patch --authorized-networks`
`SSL required` error	`require_ssl=true` but client not using SSL	Use Cloud SQL Proxy or pass `sslmode=require`
High replication lag	Replica tier too small or write-heavy primary	Increase replica tier; reduce write load
Instance slow despite RUNNABLE	Under-provisioned CPU/memory	Scale tier with `gcloud sql instances patch --tier`
Proxy returns `ECONNREFUSED`	Wrong connection name or missing IAM role	Verify `project:region:instance` format; grant `roles/cloudsql.client`
Cannot create private IP instance	VPC peering not established	Run `gcloud services vpc-peerings connect` first
Backup restore fails	Incompatible version	Ensure same major database version between source and target

gcp-cloud-sql

Opciones de instalación

Revisa los archivos de origen

GCP Cloud SQL

When to Use

Prerequisites

Instance Tiers Reference

GCP Cloud SQL

When to Use

Prerequisites

Instance Tiers Reference

Create a PostgreSQL Instance

Create a MySQL Instance

Private IP Configuration

Read Replicas

Backups and Restore

Cloud SQL Auth Proxy

Connection Methods Summary

Terraform Configuration

Common Operations

Troubleshooting

Related Skills

gcp-cloud-sql

Datos de origen

Opciones de instalación

Revisa los archivos de origen

Más de este repositorio

Más de este repositorio

GCP Cloud SQL

When to Use

Prerequisites

Instance Tiers Reference

GCP Cloud SQL

When to Use

Prerequisites

Instance Tiers Reference

Create a PostgreSQL Instance

Create a MySQL Instance

Private IP Configuration

Read Replicas

Backups and Restore

Cloud SQL Auth Proxy

Connection Methods Summary

Terraform Configuration

Common Operations

Troubleshooting

Related Skills