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.
A walkthrough of Chartfold, a Python tool that loads your medical records into SQLite and exposes them to Claude via MCP for structured analysis, visit prep, and ad-hoc queries.
A metadata index that gives LLM tools like Claude Code awareness of your entire repository collection.
EBK is a comprehensive eBook metadata management tool with AI-powered enrichment, semantic search, and knowledge graphs. Part of the Long Echo toolkit.
A plugin-based toolkit for managing AI conversations from multiple providers. Import, store, search, and export conversations in a unified tree format. Built for the Long Echo project.