sqlite-ops

スキルの内容

A community skill for working with SQLite whatever the host: the sqlite3 command line, Python, Node.js drivers, Bun, Cloudflare D1 or libSQL and Turso. It starts by telling the agent to measure before optimising, then explains how to read EXPLAIN QUERY PLAN output, which query shapes an index can serve and what to build for each, and how to fix locking errors with busy timeouts, immediate transactions and WAL mode. It also covers schema pitfalls, feature modules such as full-text search and JSON, maintenance and D1 migrations. A bundled Python script helps sort query plans, and reference files hold the detail.

できること

詳細