skilld
All skills
google avatar

/cloud-sql-basics

@becc4b8
by googlegoogle/skills21k stars
1,698

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.

Ask your Agent

Use this Skill: https://skilld.dev/gh/google/skills/cloud-sql-basics

This session only. Nothing lands on disk.

referencesmcp-usage.md

≈821 tokens on demand. Your agent reads this file only when SKILL.md points to it.

Cloud SQL MCP Usage

Cloud SQL can be managed via the Model Context Protocol (MCP), which allows agents to manage database instances, execute SQL queries, and automate backup or migration workflows.

MCP is available via remote Google Cloud MCP servers and through local execution with the MCP Toolbox.

Google Cloud MCP for Cloud SQL

The Cloud SQL MCP server includes the following tools:

  • clone_instance: Creates a Cloud SQL instance as a clone of a source instance.
  • create_backup: Creates an on-demand backup of a Cloud SQL instance.
  • create_instance: Initiates the creation of a Cloud SQL instance.
  • create_user: Creates a database user for a Cloud SQL instance.
  • execute_sql: Executes any valid SQL statements (DDL, DCL, DQL, DML) on a Cloud SQL instance.
  • execute_sql_readonly: Safely executes read-only SQL queries on a Cloud SQL instance.
  • get_instance: Gets details and status of a Cloud SQL instance.
  • get_operation: Gets the status of a long-running operation in Cloud SQL.
  • import_data: Imports data into a Cloud SQL instance from Cloud Storage.
  • list_instances: Lists all Cloud SQL instances in a project.
  • list_users: Lists all database users for a Cloud SQL instance.
  • postgres_upgrade_precheck: Performs pre-checks before upgrading PostgreSQL engine versions.
  • restore_backup: Restores a backup to a Cloud SQL instance.
  • update_instance: Updates supported settings of a Cloud SQL instance.
  • update_user: Updates a database user for a Cloud SQL instance.

Server Toolsets & IAM Requirements

  • Full MCP Set Endpoint: https://sqladmin.googleapis.com/mcp (Exposes all management, query, and backup tools).
  • Read-Only Toolset Endpoint: https://sqladmin.googleapis.com/mcp/readonly (Restricts access to read-only tools like execute_sql_readonly).
  • Required IAM Role: Using the Cloud SQL remote MCP server requires the roles/mcp.toolUser role in addition to Cloud SQL resource roles (e.g., roles/cloudsql.admin or roles/cloudsql.editor).

Setup Instructions

For remote server setup, see the documentation for:

Supported Operations

Agents using the Cloud SQL MCP can:

  • Automate database schema migrations.
  • Create and restore instance backups on-demand.
  • Run engine version upgrade pre-checks (PostgreSQL).
  • Perform health checks and monitor operation logs.
  • Assist in debugging SQL performance issues using read-only or full SQL execution tools.

MCP toolbox for databases

MCP toolbox for databases can be installed locally and provide various predefined and custom tools for Cloud SQL. Read more about MCP Toolbox in the documentation.

Source: SKILL.md on GitHub

Third-party checks

No alerts10d3 checks · Risk SAFE
  • Gen Agent Trust Hub10d

    This skill provides comprehensive documentation and administrative patterns for managing Google Cloud SQL resources. It includes security-focused guidance on the principle of least privilege, IAM-based authentication, and secure connectivity practices. While the skill references external package installations and powerful administrative tools, these are standard components of the service and are documented alongside relevant security considerations.

  • Socket10d

    No alerts

  • Snyk10d

    Risk: LOW · No issues

Provenance

Signed by skilld at becc4b8. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub yesterday.

Activeupdated 2 weeks ago

Capability

metadata
{
  "version": "1.0.0",
  "category": "Databases"
}

README badge

README badge for google/skills/cloud-sql-basics