To debug and inspect your database instance you can install Onyx Database Browser. This desktop application can connect to a local database or a remote database endpoint. Use it as a development companion and to inspect your data.
When starting the application, use the dialog to connect to either a local or remote database. Connect to a remote database by specifying the location as a server:port value. For Example 192.168.3.2:8080
Your schema is displayed using the left navigation panel. There are 2 tabs, Schema and Queries. Select the schema tab.
Double click on an item within the tree to view entity properties such as relationships, indexes, attributes, and partitions
Select the query tab in the left navigation panel. By default there is a Kotlin and a Java query for example.
You can create a new Query by either right clicking on the tree or clicking the New Query link. After doing so, you will be prompted to define the type as either Kotlin or Java.
Execute the selected query by clicking the Execute button.
The Query results is divided into 3 sections including Results, Tree, and Console
To view the results within a table excluding relationship information select the Result tab
To view the result object graph including relationships select the Tree tab
To view script output and potential compile or runtime errors select the Console tab
Update records by double clicking within the Result view table.
Save the record by clicking the Save Record link.
You can also delete entities by using the right click context menu.