From studio pro, on the bottom panel in the "console" tab, you will find the "advanced" menu and the "Start built-in database viewer" item. You can then run some SELECT query and see the content of your DB. Is it what you were looking for?
We have an OfflineDebug boolean on the Account entity. When switched on, the native app shows an additional option. That opens a menu with basic listview pages to browse the offline data. Tapping a listview item opens a detail page. Can be a little time consuming to make but quite useful.
Also, my NanoflowCommonsITvisors module has a GetOfflineStats JavaScript action that will return a list of entities and their record counts. We put that on that menu as an option as well.