sqlite-optimization

SKILL.md

Throughput jumps from 50 inserts/sec (autocommit) to 50,000+ inserts/sec.

Architecture pattern: Single writer thread/process + many reader connections.

| SELECT | List only needed columns | | Loop with single inserts | Batch in transaction | | Correlated subquery per row | Rewrite as JOIN | | Index on every column | Index only queried columns | | No busytimeout | Set appropriate timeout | | Rollback journal mode | Switch to WAL | | Never running ANALYZE | Run PRAGMA optimize periodically |

Optimize SQLite database performance through configuration, schema design, indexing, and query tuning. Use when users ask to improve SQLite speed, reduce latency, optimize queries, configure PRAGMAs, fix slow queries, handle concurrency, optimize writes/inserts, or tune SQLite for production. Triggers on mentions of SQLite performance, slow queries, PRAGMA settings, WAL mode, indexing strategies, bulk inserts, or database maintenance (VACUUM, ANALYZE). Source: jrajasekera/claude-skills.

View raw