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

cloud-sql-postgres-health

Audit Cloud SQL for PostgreSQL instance health and performance bottlenecks.

42|7|Updated Sep 12, 2025
Search Tags:#postgresql#performance-tuning#query-optimization#autovacuum#cloud-sql#database-health#storage-bloat
One-click install
npx skills add https://github.com/gemini-cli-extensions/cloud-sql-postgresql --skill cloud-sql-postgres-health
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: cloud-sql-postgres-health
Source: https://github.com/gemini-cli-extensions/cloud-sql-postgresql/tree/main/skills/cloud-sql-postgres-health
Command: npx skills add https://github.com/gemini-cli-extensions/cloud-sql-postgresql --skill cloud-sql-postgres-health

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Manually auditing Cloud SQL for PostgreSQL health, identifying performance bottlenecks like storage bloat and invalid indexes, and troubleshooting slow queries or blocking locks is time-consuming and requires deep expertise in both PostgreSQL and Google Cloud Monitoring. This Skill eliminates that manual effort by providing automated tools to gather insights and diagnose issues using natural language.

Core Features & Use Cases

  • Performance Metrics Analysis: Fetch query-level and system-level Cloud Monitoring time series data to identify high latency, high CPU usage, connection bottlenecks, and I/O issues.
  • Query Tuning: Generate PostgreSQL EXPLAIN plans for SQL statements to inspect optimizer estimates and identify opportunities to add indexes or rewrite queries for better performance.
  • Real-Time Workload Monitoring: List active running queries, long-running transactions, and held locks to diagnose concurrency issues and blocking in production environments.
  • Use Case: A database administrator can use this Skill to quickly identify the top 5 slowest queries consuming the most execution time, generate their EXPLAIN plans, and check for invalid indexes or storage bloat causing degraded performance.

Quick Start

Ask the AI to list the top 5 longest-running active queries on your Cloud SQL PostgreSQL instance to identify potential performance blockers immediately.

Frequently Asked Questions about cloud-sql-postgres-health

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

FAQPage Schema
How do I identify slow queries and performance bottlenecks in Cloud SQL PostgreSQL?▼

This Skill audits Cloud SQL PostgreSQL by fetching query-level and system-level Cloud Monitoring time series data to detect high latency, CPU usage, connection bottlenecks, and I/O issues.

How do I check active transactions and blocking locks in PostgreSQL?▼

You can check active transactions and blocking locks in PostgreSQL by listing active running queries, long-running transactions, and held locks to diagnose concurrency issues in production environments.

What is the best way to detect storage bloat and invalid indexes in Cloud SQL PostgreSQL?▼

The best way to detect storage bloat and invalid indexes in Cloud SQL PostgreSQL is using automated database health auditing tools that retrieve PostgreSQL system statistics without manual command-line execution.

How do I generate EXPLAIN plans for PostgreSQL query tuning?▼

You generate EXPLAIN plans for PostgreSQL query tuning by inspecting optimizer estimates for SQL statements, which helps identify opportunities to add indexes or rewrite queries for better performance.

Can I use natural language to troubleshoot Cloud SQL PostgreSQL maintenance configurations?▼

Yes, you can use natural language to troubleshoot Cloud SQL PostgreSQL maintenance configurations, eliminating manual database troubleshooting workflows and automating the retrieval of system statistics.

Related Skills

Explore More Data & Analytics Skills→
interflownexinterflownex
2

cloud-sql-postgres-health

Diagnose query bottlenecks and resource constraints in Google Cloud SQL for PostgreSQL instances.

Community
Advanced
AngelP17AngelP17
1

sql-optimization-patterns

Analyze EXPLAIN output and apply indexing strategies to optimize slow SQL queries.

Community
Advanced
Anthony-BibleAnthony-Bible

cloud-metrics

Query Google Cloud Monitoring metrics via the Cloud Monitoring API.

Community
Intermediate
IldarMinaevIldarMinaev
1

postgresql-troubleshooting-sql

Run SQL scripts to diagnose PostgreSQL health, replication, storage, and query performance.

Community
Advanced