I have a similar project that I have built and found great success with it storing things like coding standards, decisions, etc.

One thing that is interesting during my work is that Codex and OpenCode using OpenAI models are REALLY good at using the tool, whereas new models and changes in Claude code keep making it difficult to stay on top of it's usability there. It seems like instructions and/or models are changing that cause for it to prefer the Claude Code memory tooling instead of allowing for remote memory tooling.

Opus 5 seems to have made it materially worse (or some harness change around Opus 5, I haven't dug in entirely to analyze). I had to get more in-depth setup instructions to make sure that Claude Code would consistently use my memory tooling.