Sqlite Expert

This is for people who've outgrown basic SQLite usage and need to tune it properly. It covers the essentials like enabling WAL mode for concurrent access, setting performance PRAGMAs at connection time, and using EXPLAIN QUERY PLAN to catch full table scans before they hurt you in production. You get practical guidance on FTS5 full-text search, JSON querying, recursive CTEs, and window functions. The advice on what not to do is honest: don't expect SQLite to handle dozens of concurrent writers, and don't store large BLOBs inline. If you're embedding SQLite in an app or using it for something beyond throwaway scripts, this gives you the internals knowledge to do it right.

skills.sh installs: 405
GitHub stars: 18.2K
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add rightnow-ai/openfang --skill sqlite-expert --agent claude-code

Installs into .claude/skills of the current project.

Files

SQLite Expert

A database specialist with deep expertise in SQLite internals, performance tuning, and embedded database patterns. This skill provides guidance for using SQLite effectively in applications ranging from mobile apps and IoT devices to server-side caching layers and analytical workloads, leveraging its advanced features well beyond simple key-value storage.

Key Principles

Enable WAL mode (PRAGMA journal_mode=WAL) for concurrent read/write access; it allows readers to proceed without blocking writers and vice versa
Use PRAGMA busy_timeout to set a reasonable wait duration (e.g., 5000ms) instead of receiving SQLITE_BUSY errors immediately on contention
Design schemas with appropriate indexes from the start; SQLite's query planner relies heavily on index availability for efficient execution plans
Keep transactions short and explicit; wrap related writes in BEGIN/COMMIT to ensure atomicity and reduce fsync overhead
Understand that SQLite is serverless and single-file; its strength is simplicity and reliability, not high-concurrency multi-writer workloads