alloydb-postgres-health

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

2|1|Updated May 25, 2026

Search Tags:#performance #database #postgresql #optimization #vacuum #alloydb

Ready to run

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

💬 Prompt for ChatGPT / Claude Chat▼

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses performance bottlenecks and maintenance overhead in AlloyDB for PostgreSQL by providing automated diagnostic tools for storage, indexing, and vacuuming.

Core Features & Use Cases

Performance Diagnostics: Identify bloated tables, invalid indexes, and inefficient sequential scans to improve query speed.
Maintenance Automation: Monitor autovacuum configurations and tablespace usage to ensure long-term database stability.
Use Case: When a database query slows down, use this Skill to list top bloated tables and invalid indexes, allowing you to perform targeted maintenance and reclaim disk space.

Quick Start

Use the alloydb-postgres-health skill to list the top bloated tables in the current database.

Frequently Asked Questions about alloydb-postgres-health

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

FAQPage Schema

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

To check AlloyDB PostgreSQL database health, you can run diagnostic scripts to identify storage bloat, invalid indexes, and inefficient table statistics. This allows you to pinpoint bloated tables and reclaim disk space.

Why does my PostgreSQL query slow down and how can I find invalid indexes?▼

PostgreSQL queries slow down due to bloated tables and invalid indexes. You can analyze database health to list top bloated tables and invalid indexes, enabling targeted maintenance to improve query speed.

What is the best way to monitor autovacuum configurations in AlloyDB?▼

The best way to monitor autovacuum configurations in AlloyDB is by using diagnostic scripts to analyze table statistics and tablespace usage. This ensures long-term database stability and automates maintenance tasks.

Do I need the @toolbox-sdk/server package to run PostgreSQL performance diagnostics?▼

Yes, you need the @toolbox-sdk/server package to execute diagnostic scripts against the PostgreSQL database engine. It provides the required environment to analyze storage bloat and inefficient sequential scans.

Can I use these diagnostic scripts to fix inefficient sequential scans in my database?▼

Yes, you can use the scripts to identify inefficient sequential scans and invalid indexes in your PostgreSQL database. By highlighting these issues, you can perform performance tuning to improve query speed.