cloud-sql-postgres-view-config

Inspect Cloud SQL for PostgreSQL instance configurations, memory settings, and installed extensions.

2|1|Updated May 25, 2026
One-click install
npx skills add https://github.com/interflownex/All-in-One --skill cloud-sql-postgres-view-config-interflownex
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: cloud-sql-postgres-view-config
Source: https://github.com/interflownex/All-in-One/tree/main/.gemini/skills/cloud-sql-postgres-view-config
Command: npx skills add https://github.com/interflownex/All-in-One --skill cloud-sql-postgres-view-config-interflownex

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires @toolbox-sdk/server, and includes scripts (resource) components.

What problem does it solve?

This skill addresses the complexity of managing PostgreSQL configurations and extensions by providing a streamlined interface to query server states, memory settings, and installed extensions directly.

Core Features & Use Cases

  • Instance Monitoring: Quickly retrieve uptime, connection limits, and active connection metrics to ensure database health.
  • Configuration Tuning: Easily list and inspect memory-related parameters and specific PostgreSQL settings to optimize performance.
  • Extension Management: Discover and audit available or installed PostgreSQL extensions to maintain feature parity and security compliance.

Quick Start

Use the cloud-sql-postgres-view-config skill to list all currently installed PostgreSQL extensions on your 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 monitor Cloud SQL PostgreSQL connection limits and uptime?

You can monitor Cloud SQL PostgreSQL instances by retrieving uptime, connection limits, and active connection metrics to ensure database health and optimal performance.

How do I list installed PostgreSQL extensions on a Cloud SQL instance?

To list installed PostgreSQL extensions on a Cloud SQL instance, you can query the server state to discover, audit, and verify installed extensions for security compliance.

What is the best way to inspect PostgreSQL memory settings in Cloud SQL?

Inspecting PostgreSQL memory settings in Cloud SQL involves listing and reviewing memory-related parameters to optimize database performance and ensure proper resource allocation.

Can I programmatically audit Cloud SQL PostgreSQL configuration settings?

Yes, you can programmatically audit Cloud SQL PostgreSQL environments to inspect server-level configurations, memory settings, and available extensions to ensure optimal resource allocation.

Does this skill require a specific toolbox SDK to view PostgreSQL configurations?

Yes, viewing PostgreSQL configurations requires the @toolbox-sdk/server dependency to facilitate programmatic querying of server states and operational metrics.

What limitations exist when querying Cloud SQL PostgreSQL server states?

Querying Cloud SQL PostgreSQL server states is limited to inspecting server-level memory settings, performance configurations, and available extensions, rather than modifying database parameters.