cloud-sql-basics

Creates and manages Cloud SQL instances for MySQL, PostgreSQL, and SQL Server on Google Cloud.

Updated Jul 24, 2026
One-click install
npx skills add https://github.com/oliverconstance/webapp-scrum-team --skill cloud-sql-basics-oliverconstance
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: cloud-sql-basics
Source: https://github.com/oliverconstance/webapp-scrum-team/tree/main/.agent/skills/cloud-sql-basics
Command: npx skills add https://github.com/oliverconstance/webapp-scrum-team --skill cloud-sql-basics-oliverconstance

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Setting up a managed relational database on Google Cloud involves many steps—enabling APIs, provisioning instances, configuring users, and establishing secure connections. This Skill guides you through creating and managing Cloud SQL resources without memorizing gcloud commands or connection procedures. ## Core Features & Use Cases - Instance Provisioning: Create Cloud SQL instances for MySQL, PostgreSQL, or SQL Server with the correct database version, CPU, memory, and region settings. - Secure Connectivity: Set up the Cloud SQL Auth Proxy, configure SSL/TLS, and retrieve instance connection names for client applications. - Operational Guidance: Reference documentation covers backups, Point-in-Time Recovery, high availability, IAM roles, Terraform configuration, and client library connections in Python, Java, Node.js, and Go. - Use Case: You need a PostgreSQL database for a new application. Use this Skill to enable the SQL Admin API, create a POSTGRES_18 instance, set the postgres user password, create a database, and connect via the Cloud SQL Auth Proxy. ## Quick Start Ask the assistant to create a Cloud SQL PostgreSQL instance named my-db in us-central1 and show how to connect to it with the Auth Proxy.

Frequently Asked Questions about cloud-sql-basics

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create a Cloud SQL PostgreSQL instance with gcloud?▼

Run gcloud sql instances create with the instance name, --database-version=POSTGRES_18, CPU, memory, and region flags. First enable the API with gcloud services enable sqladmin.googleapis.com, then set the postgres user password and create your database.

How to connect to Cloud SQL from a local application?▼

Start the Cloud SQL Auth Proxy with your instance connection name in the format PROJECT_ID:REGION:INSTANCE_NAME. Then connect your client, such as psql, to 127.0.0.1 on the proxy port using your database credentials.

Does Cloud SQL support MySQL and SQL Server as well as PostgreSQL?▼

Yes, Cloud SQL manages MySQL, PostgreSQL, and SQL Server instances as fully managed resources. It handles backups, high availability, patching, and secure connectivity for all three database engines.

What IAM role is needed to manage Cloud SQL instances?▼

The Cloud SQL Admin role (roles/cloudsql.admin) provides full access to create and manage Cloud SQL resources. More granular predefined roles are available for read-only or client-only access patterns.

Can I manage Cloud SQL with Terraform instead of gcloud?▼

Yes, the Skill's references include Infrastructure as Code guidance with Terraform configurations for instances, databases, and users. This suits teams managing database infrastructure through version-controlled code.

How do I set up backups and point-in-time recovery for Cloud SQL?▼

Cloud SQL supports automated backups and Point-in-Time Recovery (PITR) using write-ahead logs. The disaster recovery reference covers backup types, replicas, read pools, and Enterprise Plus Advanced DR options.