You can install a copy of Postgres locally, and either download and restore a copy your database there, or tell your local modeller to use your local Postgres. If you want to query the database outside Mendix, you can just connect to this database and use SQL. Here’s a link to the instructions on how to do this.
https://docs.mendix.com/developerportal/operate/restore-backup-locally
Hope this helps.