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.

Install to Claude Code

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