View sqflite table contents for debugging

Question

I am integrating a Database into my flutter app with sqflite. Since I am a visual understander in terms of problems, I would like to be able to see table contents for debugging.

Is there a possibility to view/read the table contents on the phone via some kind of UI or via debug? I am using visual studio code.

Answer 1

1. Android Studio , Use Database Inspector as Code Poet Said

2. IntelliJ IDEA / DataGrip. you can choose Android SQLITE db, and it detect your connected devices. IntelliJ Screenshot

*dont have enough reputation to post img

Answer 2

You can use Database Inspector at bottom bar of Android Studio to view