I think this is mostly being overengineered. At this stage, a curated MEMORY.md is enough: short, readable at session start, and easy to correct when it becomes stale.

The session history is another database like any other database, can be used or invoked by agent like one.