I have automated this long ago and publish a script for that. Download here: https://github.com/appronto/scripts
drop these 3 files in the root of your project, changes your environment vars and user/pass and drag a backup of the cloud (full backup) onto the .bat file and it will do all the magic (backup db, delete db, create db en restore) π
For the built-in hsqldb something similar to what you are looking for is available:
More info here: https://docs.mendix.com/howto/collaboration-project-management/sharing-the-development-database
There is a way to initialize your PostgreSQL database using the data-snapshot:
Not sure what you mean by '...it working this way'
I know that there are indeed a lot of similar issues related to setting up a specific work environment. Usually there is a solution to automate these tasks, but that depends on your specific requirements,
In your case you could just setup a script to update that DB.
Checkout the second and third tip of this set of productivity-tips. With a bit of luck and a bit of effort you can get the restore-script to restore any database you download.
I have no idea how DB's work,
but from my non-technical perspective I can imagine having next to the commit button, a "commit DB" and "download DB" buttons.