I made a MCP tool for fun this spring that has memory storage in a SQLite db. At the time at least, Claude basically refused to use the memory proactively, even with prompts trying hard to push it in that direction. Having to always explicitly tell it to check its memories or remember X and Y from the conversation killed the usefulness for me.

Repo: https://github.com/mbcrawfo/KnowledgeBaseServer