What it is
Cloud SQL Basics is a Google Cloud skill for creating and managing fully managed relational database instances. Cloud SQL supports three engines -- MySQL, PostgreSQL, and SQL Server -- and automates patches, updates, backups, and replica management while providing high performance and availability. The skill provides a complete quick start workflow for PostgreSQL: enabling the Cloud SQL API, creating an instance with specified CPU and memory, setting the default user password, creating a database, retrieving the instance connection name, and connecting via the Cloud SQL Auth Proxy. The Auth Proxy provides secure connectivity without configuring SSL certificates or firewall rules directly, and the skill consistently recommends it over direct TCP connections. Reference documentation covers Cloud SQL editions (Enterprise and Enterprise Plus), instance architecture with read pools and high availability, essential gcloud sql commands, client library connectivity for Python, Java, Node.js, and Go, MCP server integration via the Gemini CLI extension, Terraform configuration, IAM predefined roles with SSL/TLS setup, and disaster recovery including backup types, point-in-time recovery, and Enterprise Plus Advanced DR. The skill also notes that the Developer Knowledge MCP server can be used for product information not found in the provided references.
Who it's for
- backend developers
- database administrators
- DevOps engineers
- Google Cloud developers
Requirements
Requirements
- Google Cloud Project with Cloud SQL Admin API enabled
- Cloud SQL Admin role (roles/cloudsql.admin)
- gcloud CLI authenticated
Setup
Step 1
bashInstall from Google skills repository: npx skills add google/skills --skill cloud-sql-basics
ينشئ ويدير مثيلات Cloud SQL لـ MySQL و PostgreSQL و SQL Server على Google Cloud مع النسخ الاحتياطي الآلي والتوافر العالي.
Pros & cons
Pros
- Pro:Supports three database engines: MySQL, PostgreSQL, SQL Server
- Pro:Complete quick start from API enablement through instance connection
- Pro:Reference directory covering editions, CLI, client libraries, MCP, IaC, IAM, and disaster recovery
- Pro:Cloud SQL Auth Proxy integration for secure connectivity
Cons
- Con:Specific to Google Cloud SQL; does not cover AWS RDS or Azure SQL Database
Related
Skill alloydb-basics
Manages clusters, instances, and backups for AlloyDB for PostgreSQL, and integrates with AlloyDB Model Context Protocol (MCP) tools for automated database operations. Use when creating, configuring, or administering AlloyDB databases. Do NOT use for general PostgreSQL instances (e.g. Cloud SQL) or other GCP databases.
Skill gemini-api
Use when the user asks about using Gemini in an enterprise environment or explicitly mentions Vertex AI, Google Cloud, or Agent Platform. Guides the usage of the Gemini API on Agent Platform with the Google Gen AI SDK. Covers SDK usage (Python, JS/TS, Go, Java, C#), capabilities like multimodal inputs, tools, media generation, caching, batch prediction, and Live API.
Skill google-cloud-recipe-auth
Provides expert guidance on Identity and Access Management (IAM) and authenticating and authorizing to Google Cloud services and APIs, covering human users, service identities, Application Default Credentials (ADC), and best practices for secure access.
Skill google-cloud-recipe-onboarding
Guides a developer's first steps on Google Cloud, covering account creation, billing setup, project management, and deploying a first resource. Use when a new developer wants to initialize their first Google Cloud project, configure billing, and verify deployment. Don't use for enterprise organization setup (use Google Cloud Setup guided flow for that instead). Don't use for complex multi-project architectures.
Skill google-cloud-waf-sustainability
Provides recommendations for environmental sustainability, carbon footprint reduction, and energy efficiency based on the Sustainability pillar of the Google Cloud Well-Architected Framework (WAF). Use when the user asks to assess, design, or optimize Google Cloud workloads for sustainability—including the shared responsibility model, selecting low-carbon regions (CFE%), reducing resource and AI/ML energy waste, designing efficient software and storage lifecycles, or measuring and tracking emis…
Skill firebase
Google Firebase MCP integration. Manage Firestore databases, authentication, cloud functions, hosting, and storage. Build and manage your Firebase backend directly from your development workflow.