Or you could just use a great agent/harness like Shelley that already uses sqlite to store converians is searchable from the UI as well.
The idea is that even with native recall from Shelley, ctx results are more accurate, ergonomic, and token efficient
For example search can retrieve a specific message and then window for trailing and leading N messages, in just a few hundred tokens