skills.rest
Hainrixz
HainrixzCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

db-storage-bloat

Detect storage bloat, VACUUM effectiveness, TXID wraparound risk, and tombstone accumulation in databases.

18|4|Updated Jun 16, 2026
Search Tags:#database#database health#VACUUM#storage bloat#TXID wraparound
One-click install
npx skills add https://github.com/Hainrixz/claude-db --skill db-storage-bloat
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-storage-bloat
Source: https://github.com/Hainrixz/claude-db/tree/main/skills/db-storage-bloat
Command: npx skills add https://github.com/Hainrixz/claude-db --skill db-storage-bloat

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill addresses storage bloat and VACUUM health issues in databases, ensuring optimal performance and data integrity.

Core Features & Use Cases

  • Storage Bloat Audit: Detects bloated tables and indexes, helping maintain database efficiency.
  • VACUUM Health Check: Monitors and analyzes the effectiveness of VACUUM operations.
  • TXID Wraparound Risk Assessment: Evaluates the risk of transaction ID wraparound, a critical issue that can lead to database shutdown.
  • Tombstone Analysis: Identifies tombstone accumulation on wide-column stores, impacting read performance.
  • Use Case: Regularly running this Skill can prevent potential database performance issues by identifying and addressing bloat and health issues early.

Quick Start

Run the db-storage-bloat skill to audit your database for storage bloat and VACUUM health issues.

Frequently Asked Questions about db-storage-bloat

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

FAQPage Schema
How do I check for database storage bloat and VACUUM health issues?▼

To check for database storage bloat and VACUUM health issues, you can run a diagnostic audit that detects bloated tables and indexes while evaluating VACUUM effectiveness. This process requires runtime database access to identify and report storage inefficiencies.

What is TXID wraparound risk and how does it affect database performance?▼

TXID wraparound risk is a critical condition where transaction IDs exhaust their limit, potentially causing database shutdown. Assessing this risk evaluates transaction ID usage to prevent catastrophic data integrity loss and maintain continuous performance.

Why does tombstone accumulation impact read performance in wide-column stores?▼

Tombstone accumulation impacts read performance because deleted data markers build up over time in wide-column stores. Identifying these tombstones allows you to mitigate read latency and maintain optimal query efficiency.

Can I assess VACUUM effectiveness without direct runtime access to the database?▼

Assessing VACUUM effectiveness requires runtime access to the database for detailed analysis. Without this direct access, the Skill cannot accurately identify storage bloat, tombstone accumulation, or transaction ID wraparound risks.

When do I need to run a database storage bloat audit?▼

You need to run a database storage bloat audit regularly to prevent potential performance issues. Running it proactively identifies bloated tables, indexes, and VACUUM health issues early, ensuring continuous data integrity and optimal efficiency.

Related Skills

Explore More Software Engineering Skills→
matejformanekmatejformanek

vacuum-autovacuum

Analyze PostgreSQL VACUUM and autovacuum subsystem behavior for storage reclamation.

Community
Advanced
Mercurium-AnalyticsMercurium-Analytics

pg-repack-runbook

Rebuild bloated PostgreSQL tables online with pg_repack.

Official
Intermediate
Spectaculous-CodeSpectaculous-Code

performance_auditor

Analyze and optimize application performance across database, frontend, and AI components.

Official
Advanced
mangorocketofficialmangorocketofficial

postgres

Optimize PostgreSQL queries, indexing, and operational performance.

Community
Advanced