High concurrent SQLite access causing lock contention and missing indexes Keywords: sqlite, wal, indexes, performance
Install
npx skills add VoDaiLocz/kilo-kit-mcp --skill sqlite-wal-optimizationnpx skills add VoDaiLocz/kilo-kit-mcp --skill sqlite-wal-optimization -a claude-code -gnpx skills add VoDaiLocz/kilo-kit-mcp --skill sqlite-wal-optimization -a codex -ggemini skills install https://github.com/VoDaiLocz/kilo-kit-mcp.git --path skills/learned/sqlite-wal-optimizationgh skill install VoDaiLocz/kilo-kit-mcp sqlite-wal-optimizationgit clone --depth 1 https://github.com/VoDaiLocz/kilo-kit-mcp /tmp/VoDaiLocz__kilo-kit-mcp
mkdir -p ~/.claude/skills ~/.agents/skills
cp -R /tmp/VoDaiLocz__kilo-kit-mcp/skills/learned/sqlite-wal-optimization ~/.claude/skills/sqlite-wal-optimization # Claude Code
cp -R /tmp/VoDaiLocz__kilo-kit-mcp/skills/learned/sqlite-wal-optimization ~/.agents/skills/sqlite-wal-optimization # Codex, Cursor, Gemini CLI, Copilot, OpenCode