supabase-database-hygiene
CommunityEfficiently manage disk space and retention in Supabase databases.
AuthorNewEarthAI
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill provides a comprehensive solution for managing disk space, data retention, and operational hygiene in Supabase PostgreSQL databases, addressing issues like disk bloat, index hygiene, and automated cleanup.
Core Features & Use Cases
- Disk Management: Diagnose disk bloat, unused indexes, and dead archives.
- Retention Policies: Design tiered retention policies for hot, warm, and cold data.
- Batched Cleanup Jobs: Build and schedule batched pg_cron retention jobs.
- Index Audit: Verify stats_reset dates before dropping unused indexes.
- Autovacuum Tuning: Optimize autovacuum for high-churn tables.
- pg_repack: Reclaim space over VACUUM FULL.
- Supabase Auto-Scaling: Handle disk auto-scaling gotchas in Supabase.
- Safety Checklists: Ensure pre-flight safety before destructive operations.
- Use Case: Ideal for database administrators or developers managing Supabase databases, especially when dealing with disk space issues, retention policy implementation, or index auditing.
Quick Start
Run the supabase-database-hygiene skill to perform a comprehensive hygiene check on your Supabase database.
Dependency Matrix
Required Modules
None requiredComponents
scriptsreferencesassets
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: supabase-database-hygiene Download link: https://github.com/NewEarthAI/vibecode-project-template/archive/main.zip#supabase-database-hygiene Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 620,000+ vetted skills library on demand.