sqlite-knowledge-patch
Installation
SKILL.md
SQLite Knowledge Patch
Baseline: SQLite through 3.45. Covered range: SQLite 3.46.0 through 3.53.0, plus current core scalar-function and JSON/JSONB semantics.
Reference index
| Reference | Topics |
|---|---|
| SQL language and schema | ALTER TABLE, constraints, triggers, literals, query behavior, STRICT tables |
| Core scalar functions | iif(), date/time, formatting, string/numeric functions, planner hints |
| JSON and JSONB | Validation, paths, extraction, mutation, traversal, aggregates, JSON5 |
| C APIs and configuration | Prepare flags, limits, db-config controls, hooks, status, changegroups |
| Storage, locking, and correctness | WAL, locks, indexes, VACUUM, page access, VFS and WASM storage |
| FTS5, sessions, and extensions | Tokenizers, contentless FTS5, sessions, bundled extensions |
| CLI, builds, and utilities | Shell behavior, build systems, Tcl, sqlite3_rsync, sqldiff, analyzer |