sqlite-wal-optimization
SkillDatabases & dataHigh concurrent SQLite access causing lock contention and missing indexes Keywords: sqlite, wal, indexes, performance
Available today. Use it from your connected AI after setup.
No other account needed.
Connect ahel once, and every AI you use reads what you have installed.
Then ask your AI: use the sqlite-wal-optimization skill
What this skill tells your AI
The instructions your AI receives, as published by vodailocz/kilo-kit-mcp in skills/learned/sqlite-wal-optimization/SKILL.md and read by ahel’s review.
Overview
High concurrent SQLite access causing lock contention and missing indexes
Solution Pattern & Best Practices
Apply PRAGMA journal_mode=WAL and create composite indexes on (task_mode, created_at)
Verification & Testing Strategy
Run PRAGMA integrity_check and benchmark with multi-client connections
Signals
- GitHub stars
- 26
- Forks
- 2
- Last commit
- Sep 2026
Advanced
- Catalog kind
- skill
- Gateway key
sqlite-wal-optimization- Source
- github.com/vodailocz/kilo-kit-mcp