Live Database Maintenance

Use when cleaning up, compacting, backing up, or restoring a SQLite database that a running service still holds open, or when one reports "database disk image is malformed". Covers measuring compaction cost before taking a lock, distinguishing a torn copy from real corruption, locating which table is damaged, and designing a retention policy. Prevents a maintenance window that takes down live traffic, and prevents a health check that reports ok on a broken file.

TechNickAI Updated 0 repo stars

File contents

TechNickAI/hermes-skills commit 97d45b745d

Frequently asked questions

npx get-skill add technickai/live-database-maintenance