skills.rest
gemini-cli-extensions
gemini-cli-extensionsOFFICIAL
Explore all skills by this author →
GitHub

cloud-sql-postgres-lifecycle

Manage Cloud SQL PostgreSQL instance backups, restores, and upgrade checks.

42|7|Updated Sep 12, 2025
Search Tags:#postgresql#backup-restore#instance-management#cloud-sql#database-operations#upgrade-check
One-click install
npx skills add https://github.com/gemini-cli-extensions/cloud-sql-postgresql --skill cloud-sql-postgres-lifecycle
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: cloud-sql-postgres-lifecycle
Source: https://github.com/gemini-cli-extensions/cloud-sql-postgresql/tree/main/skills/cloud-sql-postgres-lifecycle
Command: npx skills add https://github.com/gemini-cli-extensions/cloud-sql-postgresql --skill cloud-sql-postgres-lifecycle

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Managing Cloud SQL for PostgreSQL instances typically requires switching between multiple tools and manually running complex commands for routine tasks like backups, restores, and upgrade checks, which is time-consuming and prone to human error.

Core Features & Use Cases

  • Instance Lifecycle Management: Create, retrieve, and list all Cloud SQL PostgreSQL instances in your GCP project.
  • Backup & Restore Operations: Create on-demand backups of instances and restore existing backups to target instances, including cross-project restores.
  • Upgrade Readiness Checks: Run pre-checks for major PostgreSQL version upgrades to identify critical blocking issues, warnings, and informational notes before upgrading.
  • Instance Status Monitoring: Get real-time overviews of instance health, including version, replica status, uptime, connection limits, and active connection counts.
  • Use Case: A database administrator can use this skill to verify an instance is ready for a PostgreSQL 18 upgrade, create a pre-upgrade backup, and monitor instance connection usage all via natural language prompts to their AI agent.

Quick Start

Ask your AI agent to run a pre-upgrade check for your Cloud SQL PostgreSQL instance named 'production-db' targeting PostgreSQL version 18.

Frequently Asked Questions about cloud-sql-postgres-lifecycle

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

FAQPage Schema
How do I manage Cloud SQL PostgreSQL backups and restores without memorizing gcloud commands?▼

You can manage Cloud SQL PostgreSQL backups and restores using natural language prompts to handle on-demand backups, target instance restores, and cross-project restores without manual command syntax.

What is the best way to run pre-upgrade readiness checks for a Cloud SQL PostgreSQL instance?▼

Pre-upgrade readiness checks for Cloud SQL PostgreSQL instances identify critical blocking issues, warnings, and informational notes before applying major version upgrades like PostgreSQL 18 via natural language requests.

Can I monitor real-time instance health and active connections for Cloud SQL PostgreSQL?▼

Yes, real-time instance status monitoring retrieves Cloud SQL PostgreSQL health data including version, replica status, uptime, connection limits, and active connection counts through natural language queries.

Does this approach support cross-project restores for Cloud SQL PostgreSQL backups?▼

Yes, cross-project restores are supported, allowing you to restore existing Cloud SQL PostgreSQL backups to target instances located in different GCP projects.

How do I list all Cloud SQL PostgreSQL instances in my GCP project?▼

You can retrieve an inventory of all Cloud SQL PostgreSQL instances in your GCP project by asking your AI agent to list them, eliminating the need for manual API calls.

Related Skills

Explore More Software Engineering Skills→
interflownexinterflownex
2

cloud-sql-postgres-admin

Automate provisioning and administration of Google Cloud SQL for PostgreSQL instances.

Community
Intermediate
sarimofficialsarimofficial

Database Timeout Handler

Diagnose Neon PostgreSQL connection timeouts and apply configuration fixes.

Community
Intermediate
automateyournetworkautomateyournetwork
627

gcp-cloud-monitoring

Query Google Cloud Monitoring for metrics, alert policies, and active alerts.

Community
Intermediate
googlegoogle
17.1k

cloud-sql-basics

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

Official
Advanced