alloydb-omni-health

Audit PostgreSQL database health in AlloyDB Omni environments.

2|1|Updated May 25, 2026

Search Tags:#performance #database #postgresql #maintenance #bloat #alloydb

Ready to run

npx skills add https://github.com/interflownex/All-in-One --skill alloydb-omni-health

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: alloydb-omni-health
Source: https://github.com/interflownex/All-in-One/tree/main/.gemini/skills/alloydb-omni-health
Command: npx skills add https://github.com/interflownex/All-in-One --skill alloydb-omni-health

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill addresses the difficulty of maintaining database performance by automating the identification of storage bloat, invalid indexes, and suboptimal maintenance configurations in AlloyDB Omni environments.

Core Features & Use Cases

Database Health Monitoring: Quickly retrieve server uptime, connection metrics, and replica status.
Performance Optimization: Identify bloated tables and invalid indexes that consume unnecessary disk space and degrade query performance.
Maintenance Auditing: Review autovacuum settings and tablespace configurations to ensure database operations are running efficiently.

Quick Start

Use the alloydb-omni-health skill to list the top ten most bloated tables in the current database.

Frequently Asked Questions about alloydb-omni-health

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

FAQPage Schema

How do I check PostgreSQL database health and identify storage bloat?▼

To check PostgreSQL database health, you can audit storage bloat, index validity, and maintenance configurations to find performance bottlenecks. This skill automates identifying bloated tables and invalid indexes consuming unnecessary disk space.

What is the best way to find invalid indexes in an AlloyDB Omni environment?▼

The best way to find invalid indexes in AlloyDB Omni is to run a diagnostic audit script. This process reviews index validity to pinpoint indexes that degrade query performance and waste disk space.

How do I audit autovacuum settings and tablespace configurations for PostgreSQL?▼

You audit PostgreSQL autovacuum settings and tablespace configurations by executing maintenance auditing scripts. This reviews your maintenance configurations to ensure database operations run efficiently without performance degradation.

Can I retrieve server uptime and replica status metrics for AlloyDB Omni?▼

Yes, you can retrieve server uptime, connection metrics, and replica status for AlloyDB Omni. Database health monitoring scripts quickly gather these metrics to provide actionable insights into resource utilization.

Do I need the @toolbox-sdk/server package to execute database diagnostic scripts?▼

Yes, you need the @toolbox-sdk/server package to execute diagnostic scripts against the database instance. This dependency is required to operate the performance auditing scripts within your environment.