Skip to content
Get packs

SQLite Expert

Guides the agent to design, tune, and query SQLite databases using WAL mode, indexes, FTS5 and more.

Source Download skill
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()”
Step-by-step guide: how to use SQLite ExpertInstall, first run, examples, tips and FAQs

Install in 3 steps

  1. 1

    Download the skill

    The ZIP contains the 1 original files, the Apache-2.0 licence and an attribution note.

    sqlite-expert.zip
  2. 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. 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.