Why don't you download a backup and run it locally? This will give you exactly what you are looking for.
https://docs.mendix.com/developerportal/operate/restore-backup-locally/
Hi Jeroen,
According to this post: https://community.mendix.com/link/space/app-development/questions/94737
It is not possible to directly connect to the database of mendix cloud, and it is advised you use OData. Also, because of the older version I don't think the Bizzomate devtools is an option: https://bizzomate.com/bizzomate-introduces-devtool-to-safely-build-mendix-applications/
OData might be the fastest option: https://docs.mendix.com/refguide/published-odata-services/
If it's just to read data, I would look to download the database to a local instance of Postgres, and then run a local copy of the Mx7 app. There should be no need to modify the application or make a deployment in this case.