sqlite-wal-safe-ops
CommunityBack up and move SQLite WAL DBs safely.
Authorsaintgo7
Version1.0.0
Installs0
System Documentation
What problem does it solve?
SQLite WAL mode can silently corrupt or roll back your latest state when you back up or move only the main .db file, or when you mishandle the related -wal/-shm sidecar files during operations like shutdown, deployment, or recovery.
Core Features & Use Cases
- Safe WAL-aware backup: Checkpoint WAL into the main database and copy all three files (.db, .db-wal, .db-shm) with integrity verification.
- Operational guardrails: Avoid forbidden actions like moving/removing active WAL/SHM files and “.db-only” backups that omit recent transactions.
- Troubleshooting and recovery playbook: Provide an incident flow for WAL/SHM-related errors such as disk I/O errors, malformed DB images, and locked databases, including data reinitialization guidance.
Quick Start
Ask your AI to run the SQLite WAL safe backup by executing safe-backup.sh on your live WAL-mode database file to produce a verified backup in a target directory.
Dependency Matrix
Required Modules
sqlite3
Components
scripts
💻 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: sqlite-wal-safe-ops Download link: https://github.com/saintgo7/claude-skills/archive/main.zip#sqlite-wal-safe-ops 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 471,000+ vetted skills library on demand.