sqlite-knowledge-patch

Installation

SKILL.md

SQLite 3.46+ Knowledge Patch

Claude's baseline knowledge covers SQLite through 3.45. This skill provides changes from 3.46.0 (2024-05-23) onwards.

Function	Version	Description
`json_pretty(X)` / `json_pretty(X,indent)`	3.46.0	Pretty-print JSON with optional indent string
`unistr(X)`	3.50.0	Convert string with `\uXXXX` Unicode escapes to characters
`unistr_quote(X)`	3.50.0	Quote string using Unicode escape syntax
`jsonb_each(X)`	3.51.0	Like `json_each()` but returns JSONB for array/object values
`jsonb_tree(X)`	3.51.0	Like `json_tree()` but returns JSONB for array/object values
`median(X)`	3.47.0	Median aggregate (CLI extension)
`percentile(X,P)`	3.47.0	Percentile aggregate (CLI extension)
`percentile_cont(X,P)`	3.47.0	Continuous percentile (CLI extension)
`percentile_disc(X,P)`	3.47.0	Discrete percentile (CLI extension)

Related skills