SQLite Expert
Guides the agent to design, tune, and query SQLite databases using WAL mode, indexes, FTS5 and more.
- Repository
- RightNow-AI/openfang
- Stars
- 18,243
- Licence
- Apache-2.0
- Files
- 1 file
What it does
Once installed, the agent answers SQLite questions with expert-level guidance: it recommends settings such as WAL mode and busy timeouts, suggests indexes and checks query plans with EXPLAIN QUERY PLAN, and writes advanced SQL like full-text search (FTS5), JSON queries, recursive CTEs and window functions. It also warns when SQLite is the wrong choice, such as for many simultaneous writers. The skill is a written guide only; it contains no scripts.
Great for
- Developers building mobile, desktop or embedded apps that store data in SQLite
- Engineers tuning a slow SQLite query or database file
- Data analysts who want SQL help with window functions, CTEs or JSON in SQLite
Skip it if
- Teams running high-concurrency, multi-writer systems: the skill itself says SQLite is a poor fit there, so use a client-server database like PostgreSQL instead
- People expecting the agent to inspect or change their actual database: the file is guidance text only and does not connect to anything
Try asking
- “Set up a SQLite database for my mobile app with sensible WAL and busy_timeout settings”
- “Why is this SQLite query doing a full table scan? Help me add a covering index”
- “Write a recursive CTE to walk a category tree stored in SQLite”
- “Add full-text search with FTS5 to my notes table and rank results with bm25()”
Install in 3 steps
- 1
Download the skill
The ZIP contains the 1 original files, the Apache-2.0 licence and an attribution note.
sqlite-expert.zip - 2
Add it to your agent
Claude Code (all projects)
mkdir -p ~/.claude/skills && unzip sqlite-expert.zip -d ~/.claude/skills/Claude Code / Agent SDK (this project only)
mkdir -p .claude/skills && unzip sqlite-expert.zip -d .claude/skills/Claude apps (web/desktop): Settings → Capabilities → Skills → Upload skill, and choose the ZIP.
- 3
Ask for the task
No special command needed — the agent reads the skill's description and loads it when your request matches. Try one of the prompts above.
Get better results
- Give the agent your schema and the exact query so it can check indexes against the EXPLAIN QUERY PLAN output rather than guessing.
- Verify any PRAGMA values, such as cache_size or mmap_size, against your SQLite version and workload before applying them in production.
- Ask for the trade-offs when the agent recommends a change, since the guidance is general and does not know your data volumes.
What's inside
- SKILL.md
Redistributed unmodified from RightNow-AI/openfang under the Apache-2.0 licence. The assessment was drafted with AI from the skill's files on 2026-10-29. Skills can instruct your agent to run code — read SKILL.md and any scripts before installing.