If you replace sqlite with a remote DB like Postgres, can you federate the agents and have multiple pointing at the same central knowledge store?

Yes that a goal on my roadmap. Thanks, if you have more ideas or proposal add it on the repo too