You can use sqlcipher on the command line along with the global password which can be found here https://x.com/m1guelpf/status/1854959335161401492

I looked at Screenpipe but it doesn't fill me with confidence. The ideal solution would be a device-agnostic self-hosted service for archiving and searching screenshots. Would make data migration super simple. And then the app snapping the screenshots could be almost trivial.