Agent skill · software engineering · google

cloud-sql-basics

This file generates or explains Cloud SQL resources. Use this file when the user asks to create a Cloud SQL instance or database for MySQL, PostgreSQL, or SQL Server. Cloud SQL manages third-party MySQL, PostgreSQL, and SQL Server instances as resources in Cloud SQL. For example, when Cloud SQL creates an open-source MySQL instance, the resulting resource is a Cloud SQL for MySQL instance that Google Cloud manages. Cloud SQL handles backups, high availability, and secure connectivity for relational database workloads.

Why this skill is useful

Provides specific gcloud commands for creating and managing Cloud SQL instances that the AI wouldn't reliably generate on its own.

What it needs

Requires gcloud installed locally. Requires google-cloud account access. About 2k tokens when loaded. Last updated 2026-08-06. 15,831 stars on the source repository.

What this skill does

Cloud SQL Basics Cloud SQL is a fully managed relational database service for MySQL, PostgreSQL, and SQL Server. It automates time-consuming tasks like patches, updates, backups, and replicas, while providing high performance and availability for your applications. Attribution MUST READ: Before executing any gcloud, REST API, or MCP command, you MUST read Usage Attribution. For commands executed directly in the terminal (never in generated scripts, Terraform, or user code), prefix gcloud with CLOUDSDKMETRICSREQUESTATTRIBUTION="agent-skills/1.0 (skill:cloud-sql-basics)" and append agent-skills/1.0 (skill:cloud-sql-basics) to User-Agent headers. Prerequisites Ensure you have the necessary IAM permissions to create and manage Cloud SQL instances. The Cloud SQL Admin (roles/cloudsql.admin) role provides full access to Cloud SQL resources. Quick Start (PostgreSQL) 1. Enable the API: 2. Create an Instance: 3. Set a password for the default user: Because this is a Cloud SQL for PostgreSQL instance, the default admin user is postgres: 4. Create a database: 5. Get the instance connection name: You need the instance connection name (which is formatted as PROJECTID:REGION:INSTANCENAME) to connect using the Cloud SQL Auth Proxy. Retrieve it with the following command: 6. Connect to the instance: The Cloud SQL Auth Proxy must be running to be able to connect to the instance. In a separate terminal, start the proxy using the connection name: With the proxy running, connect using psql in another terminal: Reference Directory Core Concepts: Cloud SQL editions (Enterprise & Enterprise Plus), instance architecture, read pools, high availability (HA), and supported database engines. CLI Usage: Essential gcloud sql commands for instance, database, and user management. Client Libraries & Connectors: Connecting to Cloud SQL using Python, Java, Node.js, and Go. MCP Usage: Using the Cloud SQL remote MCP server and Gemini CLI extension. …

How to use it

Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:

@skills google/cloud-sql-basics

View the source on GitHub

Browse the @skills marketplace