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

Ready to run

npx skills add https://github.com/gemini-cli-extensions/cloud-sql-postgresql --skill cloud-sql-postgres-data

💬 Prompt for ChatGPT / Claude Chat▼

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.