skills.rest
wangx7
wangx7COMMUNITY
Explore all skills by this author →
GitHub

cloud-sql-basics

Provision and administer Cloud SQL instances for MySQL, PostgreSQL, and SQL Server.

Updated Jun 26, 2026
Search Tags:#postgresql#gcloud#mysql#database-management#google-cloud#sql-server#cloud-sql
One-click install
npx skills add https://github.com/wangx7/skills-collection --skill cloud-sql-basics-wangx7
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: cloud-sql-basics
Source: https://github.com/wangx7/skills-collection/tree/main/google-skills/skills/cloud/cloud-sql-basics
Command: npx skills add https://github.com/wangx7/skills-collection --skill cloud-sql-basics-wangx7

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill eliminates the manual overhead of provisioning, configuring, and managing relational database instances on Google Cloud, removing the need to handle underlying infrastructure, backup scheduling, and secure connectivity setup manually.

Core Features & Use Cases

  • Multi-Engine Instance Management: Provision and administer Cloud SQL instances for MySQL, PostgreSQL, and SQL Server with pre-configured high availability and automated backups.
  • Cross-Tool Workflow Support: Access guided instructions for gcloud CLI operations, client library integration, Terraform infrastructure as code deployment, and MCP server usage for automated database management.
  • Use Case: A backend developer can use this Skill to spin up a production-ready PostgreSQL instance, configure secure access, and connect their application in minutes instead of spending hours on infrastructure setup.

Quick Start

Use the cloud-sql-basics skill to create a fully managed PostgreSQL Cloud SQL instance with high availability and a default database in your Google Cloud project.

Frequently Asked Questions about cloud-sql-basics

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

FAQPage Schema
How do I provision a Cloud SQL instance for PostgreSQL with high availability?▼

Provisioning a Cloud SQL PostgreSQL instance with high availability is automated by configuring pre-configured infrastructure settings, automated backups, and secure connectivity to deploy a production-ready database in minutes.

Can I manage MySQL and SQL Server instances on Google Cloud using gcloud CLI?▼

Yes, you can manage MySQL, PostgreSQL, and SQL Server instances on Google Cloud using gcloud CLI operations, which supports instance creation, database administration, and IAM-based access control.

Does Cloud SQL support Terraform infrastructure as code deployment for database management?▼

Cloud SQL database management supports Terraform infrastructure as code deployment, allowing you to automate provisioning, configure secure connectivity, and manage instances across MySQL, PostgreSQL, and SQL Server.

What is the best way to configure secure access for a Google Cloud SQL database?▼

The best way to configure secure access for a Cloud SQL database involves using IAM-based access control and secure connectivity configuration, ensuring protected connections via client libraries or MCP servers.

How do I connect my application to a managed Cloud SQL database using client libraries?▼

You connect your application to a managed Cloud SQL database by integrating client libraries, which provide guided instructions for secure connectivity and database operations alongside gcloud CLI support.

Can I use an MCP server for automated Cloud SQL database operations?▼

Yes, an MCP server can be used for automated Cloud SQL database operations, providing guided instructions for managing instances, configuring backups, and integrating with your application infrastructure.

Related Skills

Explore More Software Engineering Skills→
kubiyabotkubiyabot
16

gcp

Manage Google Cloud resources by wrapping the native gcloud CLI.

Official
Advanced
lance-doniflance-donif

relational-database-mcp-cloudbase

Manage CloudBase Relational Database instances and permissions through MCP tools.

Community
Intermediate
googlegoogle
17.1k

cloud-sql-basics

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

Official
Advanced
BagelHoleBagelHole
46

gcp-cloud-sql

Provision and configure Google Cloud SQL and Spanner instances with high availability and automated backups.

Community
Intermediate