---
id: gh-cloud-sql-basics
name: "cloud-sql-basics"
url: https://skills.yangsir.net/skill/gh-cloud-sql-basics
author: google
domain: cloud-infra
tags: ["gcp", "cloud-sql", "database", "infrastructure", "sql-server"]
install_count: 14700
rating: 4.50 (120 reviews)
github: https://github.com/google/skills/tree/main/skills/cloud/cloud-sql-basics
---

# cloud-sql-basics

> 此技能提供 Google Cloud SQL 关系型数据库服务的基础管理能力，涵盖实例创建、配置、连接及安全设置。它自动化了 MySQL、PostgreSQL 和 SQL Server 数据库的部署与维护，显著提升了开发效率，确保应用数据的高性能与高可用性。

**Stats**: 14,700 installs · 4.5/5 (120 reviews)

## Before / After 对比

### 数据库实例部署效率

**Before**:

传统手动部署数据库实例，需要耗费大量时间进行环境配置、网络设置、用户权限管理及基础安全加固，过程繁琐且易出错，通常需要数小时才能完成一个可用的实例。

**After**:

借助 Cloud SQL 自动化工具和命令行，可快速创建、配置和连接数据库实例，大幅减少手动操作和潜在错误，数分钟内即可获得一个生产就绪的数据库。

| Metric | Before | After | Change |
|---|---|---|---|
| 部署时间 | 120分钟 | 10分钟 | -92% |

## Readme

# 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.

## 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:**
    ```bash
    gcloud services enable sqladmin.googleapis.com --quiet
    ```

2.  **Create an Instance:**
    ```bash
    gcloud sql instances create INSTANCE_NAME \
      --database-version=POSTGRES_18 \
      --cpu=2 \
      --memory=7680MiB \
      --region=REGION \
      --quiet
    ```

3.  **Set a password for the default user:**

    Because this is a Cloud SQL for PostgreSQL instance, the default admin user
    is `postgres`:
    ```bash
    gcloud sql users set-password postgres \
      --instance=INSTANCE_NAME --password=PASSWORD \
      --quiet
    ```

4.  **Create a database:**
    ```bash
    gcloud sql databases create DATABASE_NAME \
      --instance=INSTANCE_NAME \
      --quiet
    ```

5.  **Get the instance connection name:**

    You need the instance connection name (which is formatted as
    `PROJECT_ID:REGION:INSTANCE_NAME`) to connect using the Cloud SQL Auth
    Proxy. Retrieve it with the following command:
    ```bash
    gcloud sql instances describe INSTANCE_NAME \
      --format="value(connectionName)" \
      --quiet
    ```

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:
    ```bash
    ./cloud-sql-proxy INSTANCE_CONNECTION_NAME
    ```

    With the proxy running, connect using `psql` in another terminal:
    ```bash
    psql "host=127.0.0.1 port=5432 user=postgres dbname=DATABASE_NAME password=PASSWORD sslmode=disable"
    ```

## Reference Directory

-   [Core Concepts](references/core-concepts.md): Instance architecture, high
    availability (HA), and supported database engines.

-   [CLI Usage](references/cli-usage.md): Essential `gcloud sql` commands for
    instance, database, and user management.

-   [Client Libraries & Connectors](references/client-library-usage.md):
    Connecting to Cloud SQL using Python, Java, Node.js, and Go.

-   [MCP Usage](references/mcp-usage.md): Using the Cloud SQL remote MCP
    server and Gemini CLI extension.

-   [Infrastructure as Code](references/iac-usage.md): Terraform
    configuration for instances, databases, and users.

-   [IAM & Security](references/iam-security.md): Predefined roles, SSL/TLS
    certificates, and Auth Proxy configuration.

*If you need product information not found in these references, use the
    Developer Knowledge MCP server `search_documents` tool.*


---
*Source: https://skills.yangsir.net/skill/gh-cloud-sql-basics*
*Markdown mirror: https://skills.yangsir.net/api/skill/gh-cloud-sql-basics/markdown*