skills.rest
google
googleOFFICIAL
Explore all skills by this author →
Website𝕏@GoogleOSSGitHub

cloud-sql-basics

Manage Cloud SQL instances and databases using gcloud CLI and Terraform.

17.1k|1.4k|Updated Mar 31, 2026
Search Tags:#database management#gcloud#sql server#postgreSQL#cloud sql
One-click install
npx skills add https://github.com/google/skills --skill cloud-sql-basics-google
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: cloud-sql-basics
Source: https://github.com/google/skills/tree/main/skills/cloud/cloud-sql-basics
Command: npx skills add https://github.com/google/skills --skill cloud-sql-basics-google

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires gcloud, terraform, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill addresses the challenge of managing and operating Cloud SQL instances and databases, streamlining database management tasks.

Core Features & Use Cases

  • Instance Creation and Management: Create, configure, and manage Cloud SQL instances for MySQL, PostgreSQL, and SQL Server.
  • Database Creation and Management: Create, modify, and manage databases within Cloud SQL instances.
  • Security and Access Control: Implement security measures such as IAM roles, SSL/TLS certificates, and Auth Proxy configuration.
  • Automation and Integration: Automate database management tasks using Terraform for Infrastructure as Code (IaC).
  • Use Case: For example, use this Skill to set up a Cloud SQL instance with PostgreSQL and create a database, then connect to it using the Cloud SQL Auth Proxy.

Quick Start

Create a Cloud SQL instance with PostgreSQL by running the following command:

gcloud sql instances create MY_INSTANCE_NAME \
  --database-version=POSTGRES_18 \
  --cpu=2 \
  --memory=7680MiB \
  --region=REGION \
  --quiet

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 instance for PostgreSQL using gcloud?▼

Create a Cloud SQL instance for PostgreSQL by running the gcloud sql instances create command, specifying the database version, CPU, memory, and region parameters to configure the instance.

Can I automate Cloud SQL database management tasks with Terraform?▼

Yes, you can automate Cloud SQL database management using Terraform for Infrastructure as Code, allowing you to provision and configure instances and databases declaratively.

Does this Skill support managing Cloud SQL instances for MySQL and SQL Server?▼

Yes, this Skill supports instance creation and database management for Cloud SQL across MySQL, PostgreSQL, and SQL Server environments using gcloud CLI and Terraform.

How do I configure security and access control for Cloud SQL instances?▼

Configure Cloud SQL security by implementing IAM roles, managing SSL/TLS certificates, and setting up the Cloud SQL Auth Proxy to control database access.

Do I need gcloud and Terraform to manage Cloud SQL instances?▼

Yes, you need the gcloud CLI for direct instance and database management operations, and Terraform for automating infrastructure management tasks using Infrastructure as Code.

What is the best way to connect to a Cloud SQL database after creation?▼

Connect to a newly created Cloud SQL database by configuring and running the Cloud SQL Auth Proxy, which provides secure access to your instances without exposing them publicly.

Related Skills

Explore More Software Engineering Skills→
alex-tgkalex-tgk
1

gcloud

Configure, authenticate, and manage Google Cloud resources via the gcloud CLI.

Community
Intermediate
salverius-techsalverius-tech

database-workflow

Provide database best practices for migrations, schema design, and query optimization.

Community
Advanced
masermediagroup-stackmasermediagroup-stack
1

architecting-networks

Design secure, scalable cloud network architectures for VPC topology and hybrid connectivity.

Community
Advanced
ancolemanancoleman
503

deploying-on-aws

Guide AWS service selection and infrastructure implementation using CDK or Terraform.

Community
Advanced