SQL 데이터베이스
SQLite as a Knowledge Store
Patterns for using SQLite as a knowledge store or memory database — schema design, FTS5 full-text search (content-sync tables, triggers, bm25 ranking, query syntax), migrations without an ORM, WAL mode, connection management, and future-proofing for sqlite-vec embeddings. Use this skill whenever you're working with SQLite for document storage, building search functionality over a local database, designing schemas for AI memory or knowledge bases, writing FTS5 queries, or planning to add vector/semantic search to an existing SQLite database. Also trigger when you see `sqlite3` imports combined with `CREATE VIRTUAL TABLE ... USING fts5`, or the user mentions "full-text search", "document indexing", or "memory database".