cloud-sql-postgres-view-config

Retrieve Cloud SQL for PostgreSQL instance state, extensions, and configuration parameters.

42|7|Updated Sep 12, 2025
One-click install
npx skills add https://github.com/gemini-cli-extensions/cloud-sql-postgresql --skill cloud-sql-postgres-view-config
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: cloud-sql-postgres-view-config
Source: https://github.com/gemini-cli-extensions/cloud-sql-postgresql/tree/main/skills/cloud-sql-postgres-view-config
Command: npx skills add https://github.com/gemini-cli-extensions/cloud-sql-postgresql --skill cloud-sql-postgres-view-config

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Manually querying Cloud SQL for PostgreSQL instances to check server state, installed extensions, and configuration parameters is time-consuming and requires writing custom SQL commands. This Skill eliminates that overhead by providing prebuilt tools to retrieve this information instantly.

Core Features & Use Cases

  • Instance State Overview: Get real-time details on PostgreSQL version, replica status, uptime, connection limits, and active connection counts.
  • Extension Management: Discover all available extensions for installation, and list installed extensions with their versions, schemas, and owners.
  • Configuration Inspection: View memory-related server settings and filter PostgreSQL configuration parameters by name or result limit.
  • Use Case: A database administrator can quickly verify if a required PostgreSQL extension is installed on a production instance, or check current memory allocation settings without accessing the database directly.

Quick Start

Use the cloud-sql-postgres-view-config skill to check the current connection usage and list all installed extensions on your Cloud SQL PostgreSQL instance.

Frequently Asked Questions about cloud-sql-postgres-view-config

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

FAQPage Schema
How do I view installed PostgreSQL extensions on a Cloud SQL instance?

To view installed PostgreSQL extensions, you can retrieve an inventory of installed extensions with their versions, schemas, and owners, as well as discover all available extensions for installation without manual query execution.

Does this tool provide read-only access to PostgreSQL metadata for database administration?

You can inspect PostgreSQL memory and server configuration parameters by filtering settings by name or result limit, eliminating the need to write custom SQL commands to check engine-level settings.

How do I check my Cloud SQL PostgreSQL instance state and connection limits?

To check your Cloud SQL PostgreSQL instance state, you can retrieve real-time details on version, uptime, replica status, connection limits, and active connection counts without executing manual SQL queries.

Can I inspect PostgreSQL memory and server configuration parameters without writing SQL?

You can inspect PostgreSQL memory and server configuration parameters by filtering settings by name or result limit, eliminating the need to write custom SQL commands to check engine-level settings.