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

cloud-sql-postgres-data

Explore Cloud SQL for PostgreSQL schema objects and execute custom SQL queries.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill eliminates the manual effort of navigating complex PostgreSQL database structures, writing repetitive raw SQL for common exploration tasks, and troubleshooting schema issues when working with Cloud SQL for PostgreSQL instances.

Core Features & Use Cases

  • Schema Object Exploration: List tables, views, indexes, sequences, stored procedures, and triggers across user schemas with detailed metadata including ownership, definitions, and usage statistics.
  • Custom SQL Execution: Run ad-hoc SQL statements to interact with your data directly for ad-hoc analysis or debugging.
  • Use Case: A database administrator can use this skill to quickly identify unused indexes that are wasting storage space, or a developer can pull full table schema definitions to generate data access layer code.

Quick Start

Ask your AI agent to list all tables in the public schema of your Cloud SQL PostgreSQL instance along with their column definitions and constraints.

Frequently Asked Questions about cloud-sql-postgres-data

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

FAQPage Schema
How do I list tables and views in a Cloud SQL PostgreSQL database?▼

You can list tables and views in Cloud SQL PostgreSQL by using schema exploration to retrieve objects across user schemas, along with detailed metadata like ownership and column definitions.

Can I run ad-hoc SQL queries against my Cloud SQL PostgreSQL instance without manual command line interaction?▼

Yes, you can execute custom ad-hoc SQL queries directly against Cloud SQL PostgreSQL without manual command line interaction, enabling seamless data analysis and debugging.

What is the best way to identify unused indexes in a PostgreSQL database?▼

The best way to identify unused indexes in a PostgreSQL database is to list indexes with usage statistics, allowing administrators to pinpoint wasted storage space and optimize performance.

How do I retrieve stored procedures and triggers from a Cloud SQL PostgreSQL schema?▼

You retrieve stored procedures and triggers from a Cloud SQL PostgreSQL schema by using schema exploration tools to list these objects and extract their full definitions and metadata.

Does this Skill require manual CLI setup to inspect PostgreSQL schema configurations?▼

No, it eliminates manual command line interaction for inspecting PostgreSQL schema configurations, allowing you to quickly diagnose performance issues and interact with production data safely.

Related Skills

Explore More Data & Analytics Skills→
wangx7wangx7

cloud-sql-basics

Provision and administer Cloud SQL instances for MySQL, PostgreSQL, and SQL Server.

Community
Intermediate
bytedancebytedance
79.6k

data-analysis

Analyzes Excel and CSV files with DuckDB SQL queries and exports results to CSV, JSON, or Markdown.

Official
Intermediate
interflownexinterflownex
2

cloud-sql-mysql-monitor

Analyze MySQL query metrics and resource utilization on Google Cloud SQL.

Community
Advanced
googlegoogle
17.1k

cloud-sql-basics

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

Official
Advanced