I use KeePassXC, but am assuming KeePass is very similar.

You’ll have a single file on your machine that is your encrypted password database. Syncing is not handled by the app and is your responsibility.

If you want to sync only when you get home, as long as your app to manage that is fine with it, KeePass won’t know or care.

Keep in mind if you make changes on two devices without keeping them in sync, one will probably get overwritten unless you take special care to handle it. (My sync app warns me, then I take both conflicting files and in the KeePass app, I can merge them to solve the conflict without data loss.)