The MCP Pattern: SQLite as the AI-Queryable Cache
Every data silo follows the same architecture: domain files as ground truth, SQLite + FTS5 as a read-only cache, MCP as the query interface. After building five of these, the pattern is clear.
Browse posts by tag
Every data silo follows the same architecture: domain files as ground truth, SQLite + FTS5 as a read-only cache, MCP as the query interface. After building five of these, the pattern is clear.
How I turned scattered data managers into navigable systems using virtual filesystems and POSIX commands.
27 image commands, one constraint: read JSON, write JSON. The closure property as a generative design principle.
A command-line implementation of relational algebra for JSONL data with full support for nested structures, schema inference, and composable pipelines.
A composable ecosystem of tools for manipulating nested data structures. From a simple helper function to a full data algebra, guided by purity, pedagogy, and the principle of least power.
Do one thing well, compose freely, use text streams. This applies to libraries and APIs, not just shell scripts.