Hi Abhishek Bhardwaj,
Use OQL to query data from your application (entity) database. Refer this below Doc,
https://docs.mendix.com/refguide/oql/
Thanks & Regards,
Manikandan K
You can restore your application data from a production Mendix database to a local instance. This document gives you details on how to do this.
https://docs.mendix.com/developerportal/operate/restore-backup-locally/
Once restored, you can query it locally.