skills.rest
ssmleo
ssmleoCOMMUNITY
Explore all skills by this author →
GitHub

cloud-sql-basics

Automate Cloud SQL instance and database management using gcloud commands.

Updated Jul 4, 2026
Search Tags:#database management#infrastructure as code#cloud sql#iam security#client libraries#gcloud sql
One-click install
npx skills add https://github.com/ssmleo/govfolio --skill cloud-sql-basics-ssmleo
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: cloud-sql-basics
Source: https://github.com/ssmleo/govfolio/tree/main/.agents/skills/cloud-sql-basics
Command: npx skills add https://github.com/ssmleo/govfolio --skill cloud-sql-basics-ssmleo

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires gcloud, python, java, node.js, go, terraform, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill streamlines the process of managing Cloud SQL instances and databases, reducing the complexity of database administration tasks.

Core Features & Use Cases

  • Instance Management: Create, list, describe, restart, and manage Cloud SQL instances.
  • Database and User Management: Create databases and users, manage permissions, and perform operations and backups.
  • CLI Usage: Utilize the gcloud sql command group for efficient management.
  • Client Libraries: Connect to Cloud SQL using Python, Java, Node.js, and Go.
  • Infrastructure as Code: Provision and manage Cloud SQL resources using Terraform.
  • IAM & Security: Implement IAM roles and secure connectivity for Cloud SQL instances.
  • MCP Usage: Manage Cloud SQL instances and execute SQL queries using the Model Context Protocol (MCP).
  • Use Case: For a developer looking to automate the deployment of a Cloud SQL instance and database, this Skill provides the necessary commands and guidance.

Quick Start

Create a Cloud SQL instance for PostgreSQL with the following command:

gcloud sql instances create 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 PostgreSQL instance using the `gcloud sql instances create` command, specifying the database version, CPU, memory, and region parameters to provision the instance.

Can I provision and manage Cloud SQL resources using Terraform?▼

Yes, you can provision and manage Cloud SQL resources using Terraform. This Skill provides infrastructure as code capabilities to automate instance deployment and configuration management.

How do I connect to Cloud SQL using Python, Java, Node.js, or Go client libraries?▼

Connect to Cloud SQL by utilizing the Python, Java, Node.js, and Go client libraries. This Skill provides the necessary tools and guidance for programmatic access to your instances.

Does this support IAM roles and secure connectivity for Cloud SQL instances?▼

Yes, it supports IAM security and secure connectivity for Cloud SQL instances. You can implement IAM roles and manage secure connections to protect your MySQL, PostgreSQL, or SQL Server databases.

What's the best way to automate Cloud SQL database and user management tasks?▼

Automate Cloud SQL database and user management tasks by utilizing the `gcloud sql` command group. This approach streamlines creating databases, managing users, and configuring permissions.

Can I execute SQL queries on Cloud SQL instances using the Model Context Protocol?▼

Yes, you can manage Cloud SQL instances and execute SQL queries using the Model Context Protocol (MCP). This allows integrated database management and query execution.

Related Skills

Explore More Software Engineering Skills→
Oruga420Oruga420

gws-installer

Install and configure the Google Workspace CLI for terminal access.

Community
Advanced
pxlcrtivpxlcrtiv

alloydb-basics

Manage AlloyDB for PostgreSQL clusters, instances, and backups.

Community
Intermediate
neverinfamousneverinfamous
19

gcp

Provide best-practice guidance for provisioning and securing Google Cloud Platform infrastructure.

Community
Advanced
googlegoogle
17.1k

cloud-sql-basics

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

Official
Advanced