SQLite Fast Migration Skill

High-speed cross-machine SQLite database migration — use SQLite's built-in dump + gzip compression + local rebuild instead of rsync. Solves slow transfers and file corruption for GB-sized databases.

✨ Features

• 🚀 14× compression — strip index redundancy, measured 3.4 GB → 240 MB
• 🔒 Data integrity — dump produces a static snapshot, immune to write corruption during transfer
• 🛠️ Zero dependencies — only needs sqlite3 CLI + gzip, no extra plugins or services
• 📋 Complete rebuild — auto-creates tables, inserts data, rebuilds indexes — identical to source
• 🔄 Snapshot backup — perfect for scheduled remote SQLite backup tasks

📦 Installation

Via gh skill (recommended)

gh skill install AkatQuas/sqlite-fast-migration-skill

Via npx skills

npx skills add AkatQuas/sqlite-fast-migration-skill

Manual clone

git clone https://github.com/AkatQuas/sqlite-fast-migration-skill.git

🚀 Quick Start

# Remote dump + compress → pull → rebuild
ssh user@server "sqlite3 my.db .dump | gzip -c > my.db.txt.gz"
rsync user@server:my.db.txt.gz .
gunzip my.db.txt.gz
cat my.db.txt | sqlite3 my.db
rm my.db.txt

Full usage with 3 real-world scenarios (production analytics migration, scheduled backup, corruption recovery) — see examples/demo-usage.md.

📌 Compatible Platforms

• Cline
• Cursor Agent
• Claude Code
• Windsurf
• OpenClaw
• Any platform supporting the Agent Skills specification

📄 License

MIT

📖 References

• A faster way to copy SQLite databases between computers
• SQLite CLI documentation