SMEStorage looks like what I need and I've paid for the Android app.
I use KeePass to store my passwords and for syncing the KeePass file between my PCs, I use Windows Live Mesh. Note the sync is setup for syncing only, the password file is never stored on Microsoft's SkyDrive.
I'd like to do the same, have sync only to keep the KeePass file sync'd both ways between my PC and the smart phone (android in this case) without actually storing the sensitive file in the cloud. Does SMEStorage do sync only with no cloud storage?