In the console pane, you can find a database viewer under Advanced → Show built-in database viewer.
Or you can run another DBMS like SQL server and use their standard tooling.
You can use a local database (you create yourself) for storing your data f.e. postgress or MSSQL instead of the built-in db. This will make it easier to query the db.
Does answer your question?
If you’re looking to get that real PostgreSQL-db (or any kind of database you’d like) feeling in Mendix where you can have dedicated software to actually dive into the database, try following this path: https://docs.mendix.com/howto/data-models/migrating-your-mendix-database
The topic is on migrating your Mendix database, but really it offers you the possibility to set up your own database locally in the configuration. In my case for example: I run pgAdmin v4 and my PostgreSQL db on my local device and I simply put back-ups locally, so I can work with the Acceptance or even Production data to visualize it in my local development environment.
I hope this helps.
If you choose to use the built-in database, the app must be running locally.
Then, you can select “Start built-in database viewer” from the Advanced menu on the Console tab (1st screenshot below).
And the HSQL Database Manager window (2nd screenshot below) will open.
The best way to do this is to install postgresql on your laptop. Configure your app to connect to the local postgres in the setting window.
I find the easiest way to run postgres is by using docker compose. You can use the following docker-compose.yml configuration file to start postgres:
version: '3.2' services: db: image: postgres ports: - "5432:5432" environment: POSTGRES_PASSWORD: mendix POSTGRES_USER: mendix POSTGRES_DB: pgdev