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.
What the skill teaches
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.
Capabilities
- Read SQLite query plans and spot full scans
- Choose indexes for a query shape
- Fix database-locked and busy errors
- Apply SQLite patterns on Cloudflare D1 and libSQL
Install
The project doesn't document install steps that we could confirm. See the project's own instructions
What's inside
- assets/.gitkeep
- references/async-patterns.md
- references/concurrency-durability.md
- references/covering-index-worked-example.md
- references/d1-edge.md
- references/d1-production-patterns.md
- references/eqp-triage.md
- references/feature-modules.md
- references/hosts.md
- references/migration-patterns.md
- references/operations.md
- references/query-performance.md
- references/schema-design.md
- references/schema-patterns.md
- references/testing.md
- scripts/.gitkeep
- scripts/eqp-triage.py
- tests/run.sh
Details
| Fact | Value | Source |
|---|---|---|
| Type | Skill | |
| Tool | SQLite | |
| Publisher | 0xDarkMatter | source |
| Official status | Community (not published by the tool's vendor) | source |
| Needs an API key or sign-in | Not stated in its documentation | |
| Includes scripts | Yes | source |
| Platforms | Not stated in its documentation | |
| AI clients | Not stated in its documentation | |
| Licence | MIT | source |
| Pricing | Not stated in its documentation | |
| Activity | Last commit Nov 7, 202681 GitHub starsDownload data not available (not on npm or PyPI) | source |
| Links | Repository Website |
Sources
- Skill file (SKILL.md)github.com/0xdarkmatter/claude-modsNov 12, 2026
- Licence file (LICENSE)github.com/0xdarkmatter/claude-mods · Backs: LicenceNov 12, 2026
- GitHub repositorygithub.com/0xdarkmatter/claude-mods · Backs: Official status, Publisher, Activity, LicenceNov 11, 2026
- Folder in the repository (scripts)github.com/0xdarkmatter/claude-mods · Backs: Includes scriptsNov 12, 2026
- Skill file (SKILL.md)github.com/0xDarkMatter/claude-modsNov 10, 2026
- Folder in the repository (sqlite-ops)github.com/0xDarkMatter/claude-mods · Backs: Includes scriptsNov 10, 2026