Mendix 10.24 – Is there a built-in way to view and delete runtime entity data without external DB tools?

0
Hi,I am using Mendix Studio Pro 10.24.14 (LTS).I can see entity data in a DataGrid2 (for example from MyFirstModule.work). I would like to directly view all records of an entity and manually delete some of them.Is there any built-in way in Mendix 10.24 to inspect and manage runtime entity data (like a database viewer) from within Studio Pro?Or is using external database tools the only option?Thanks.
asked
3 answers
0

After running the project, you can open the HyperSQL database viewer from Studio Pro by going to Console → Advanced → Start built-in database viewer to inspect the database.

answered
0

In the MyFirstModulemodule, go to domain model and right click workentity and click "Create Overview Pages" which will create 2 pages: Work_Overview and Work_NewEdit

Afterwards you can give spesific user role (ie: Administrator) access permission to these pages and add Work_Overview to the App->Navigation

By accesing the Work overview page with the administrator account you can now view records and delete whichever you need to.

answered
0

hi,


In Mendix Studio Pro 10.24, there is no built-in UI inside Studio Pro that lets you browse and delete runtime entity data for a deployed app. Studio Pro is a development/modeling tool, not a database management tool.

What is possible

Local App (running in Studio Pro)

When you run your app locally inside Studio Pro, you can inspect and manage the database for that local runtime:

  1. Click Run to start the app locally.
  2. In the Console pane, go to Advanced → Start built-in database viewer.
  3. This opens the embedded database viewer where you can view tables and delete records.

This works only for the local built-in database (HSQLDB) during development.


Cloud / Hosted Environments (ACCP / Prod)

For environments deployed in Mendix Cloud:

  • There is no way to open or browse the database from within Studio Pro.
  • You cannot directly delete data in Studio Pro for deployed environments.
  • The database in Mendix Cloud (PostgreSQL, etc.) must be accessed using an external database tool after downloading a backup from the Mendix Portal.

There is no built-in Mendix Cloud database viewer. External tools like pgAdmin or DBeaver are required.

Recom­mended Mendix practice (safe & supported)

Instead of direct DB deletion, Mendix best practice is to build an Admin Management page inside your app:

1.Create a DataGrid2 for the entity

2.Enable Delete/Action buttons

3.Restrict access to a special admin role

This ensures:

  • Business logic runs
  • Access rules are respected
  • Referential integrity is maintained

This is the supported Mendix way to manage runtime data.

What is not available

Studio Pro does not provide runtime “data view” or “entity viewer” for deployed environments.

You cannot edit/delete records in cloud databases directly from Studio Pro.

answered