https://keepass.info/help/v2/sync.html
https://github.com/Kunzisoft/KeePassDX/wiki/File-Manager-and-Sync#data-synchronization
I cannot find confirmation for keepassxc but they check for changes before saving (and I believe offer to merge) as confirmed in this non-issue:
https://github.com/keepassxreboot/keepassxc/issues/12690#issuecomment-3538942799
You could still get conflict files being created by the sync software and would need to watch and merge those manually. However you can mitigate that by saving on every change (this is the default I think) and synching as often as possible between devices.