skills.rest
interflownex
interflownexCOMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/interflownex/All-in-One --skill alloydb-omni-health
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
interflownexinterflownex
2

alloydb-omni-data

Explore AlloyDB Omni schemas and execute SQL queries.

Community
Intermediate
Impertio-StudioImpertio-Studio

postgres-impl-vacuum-bloat

Detect table bloat and tune autovacuum settings in PostgreSQL databases.

Official
Advanced
OmniNode-aiOmniNode-ai
3

check-database-health

Monitor PostgreSQL database health, table statistics, connection pools, and query performance.

Official
Intermediate
interflownexinterflownex
2

alloydb-postgres-health

Analyze PostgreSQL database health by detecting storage bloat and invalid indexes.

Community
Intermediate