Hi Ashirbad,
You can restore a cloud back up to a postgres database on your computer. Here is a link to a blog post that walks you through all the steps to do that.
http://www.nolanramsey.com/blog/2015/5/29/how-to-use-your-mendix-cloud-database-locally
The blog post is a little old but I can confirm that you can use a newer version of the postgres server and the latest version of pgadmin.
Hope this helps!
Hi Ashirwad,
When running locally, you have the option of picking your own runtime configuration. This includes picking which database you want to point to. You can set up any of the supported database types and run that locally. Set up one of these databases and point your app at it and you will be able to control your own data without worrying about messing up the team server database snapshot.
If you want to take a backup from the cloud and use it locally, here are some instructions on how to do that:
https://www.mendix.com/blog/using-cloud-db-backups-local-development-environment/