Android studio database inspector does not show any databases

Question

I am on Android studio 4.1 beta 1 . I installed my app on my device and opened Database Inspector and nothing shows up . Am I supposed to do anything else ?

I am using room database . I can see the database on device . Why is the database not showing up in database inspector?

I thought database inspector is available in Canary 6 build! Which are you using? — kaustubhpatange, Jun 13 '20 at 07:57

score 25 · Answer 1 · answered Nov 19 '20 at 00:11

25

In my case, it showed me the same process a lot of times. And none of them worked.

The solution was Invalidating the Cache:

File -> Invalidate Caches/Restart -> Invalidate and restart

After that everything started working again.

answered Nov 19 '20 at 00:11

Jorge Casariego

21,948
6
90
97

1

Still true for Dolphin | 2021.3.1 unless: it didn't show any processes at all – lumpidu Oct 12 '22 at 22:16

score 19 · Answer 2 · answered Aug 02 '21 at 12:30

19

If you are using Android Studio Arctic Fox | 2020.3.1 then Database Inspector is under App Inspection. As below.

answered Aug 02 '21 at 12:30

Sujit

10,512
9
40
45

score 17 · Answer 3 · answered Feb 17 '21 at 13:03

17

A workaround is to restart your device. Works for me

answered Feb 17 '21 at 13:03

mujeeb

169
1
3

This worked for me. One day it suddenly stopped working and a restart fixed it. – DIRTY DAVE Mar 15 '23 at 13:20

Vahid · Answer 4 · 2020-12-21T07:10:57.437

11

I solved this problem by uninstall and then installing app again. Formerly when I had face to this issue, I could run database inspector just by close/open app but now it start working just by uninstalling

Update

after more working with database inspector I understand some times it just needs a few seconds to connect and no need to do anything else

edited Dec 21 '20 at 07:10

answered Dec 09 '20 at 06:48

Vahid

1,588
4
22
34

score 8 · Answer 5 · answered Dec 27 '20 at 17:13

8

I face 2 cases:

First time connect to my device and database does not show, then i do an action to modify database -> database will show.
After I use ADB Idea to clean app data or uninstall (or go to settings and clear cache or uninstall app) -> database does not show -> restart device -> database will show

answered Dec 27 '20 at 17:13

Robust

2,415
2
22
37

1

This is the only that worked for me on Motorola One phone – JPM Jan 08 '21 at 20:40
Can confirm that restarting the device solves the issue on a Motorola One. – Renan Ferrari Feb 01 '21 at 23:32
In the first case, SELECT query was not enough, I had to INSERT something – James121 Feb 13 '21 at 12:57

score 5 · Accepted Answer · answered Jul 04 '20 at 04:31

5

Looks like its problem with device . If you have some custom rom installed then you might run into this issue . Link to the issue tracker https://issuetracker.google.com/issues/159432618

answered Jul 04 '20 at 04:31

Manohar

22,116
9
108
144

1

I am using Android Studio4.1 stable. No database is showing . Take a look here ; https://imgur.com/RsYj5ql – xaif Oct 13 '20 at 05:08
1

I guess that's it. I have a custom ROM installed, and it just says deploy your app to a device running API level 26 or higher, or select a debuggable process to inspect. I'm running API 29 and have already selected the debuggable process; still nothing. – hamthenormal Dec 26 '20 at 05:28
restarting device worked for me – konnovdev May 23 '22 at 04:50
They should add this on docs. Or fix it – Estevanbs Jul 11 '22 at 18:40

rasulfahad · Answer 7 · 2021-06-22T11:58:26.410

Well here is what was happening with me - Android Studio wouldn't pick up my connected device at all with the message "Error initializing adb : android debug bridge not found" when I tried to use Device File Explorer.

Turned out my project level sdk wasn't set correctly. Fixing that worked.

File -> Project Structure In Project, select valid Project SDK In Modules -> myapp_android -> Dependencies, select a valid Module SDK.

You should now be able to select connected devices from the database inspector. Flush your cache and restart (File -> Invalidate Caches/Restart and select "Invalidate Caches and Restart") for good measure.

score 2 · Answer 8 · answered Jan 27 '21 at 09:44

2

In My Case, I forgot to open the database view inside the Database Inspector window as mentioned in the screenshot. Click on the database menu option as highlighted in yellow.

answered Jan 27 '21 at 09:44

Zeeshan Akhtar

441
1
4
9

score 2 · Answer 9 · answered Jan 12 '22 at 04:20

2

Follow these steps,

View -> Tool Windows -> App Inspection
Run the project
Then you can see the "Database Inspection"

Database Inspection in android studio arctic fox 2020.3.1 patch 3

answered Jan 12 '22 at 04:20

Amal

261
4
9

score 2 · Answer 10 · answered May 30 '22 at 15:03

In my case I was using an emulator and I came to know that its mentioned and configured storage was about full.

So I just wiped all data of emulator and restarted the app inspection tab now this time I was able to view the db tables in the inspector window.

score 1 · Answer 11 · answered Feb 08 '21 at 11:00

Still so many problems with this how did it make it into stable? open the database inspector close your app reopen your app, app crashes,

Start your app open the database inspector restart your app, database inspector is gone cannot be brought back without uninstalling and reinstalling your app

Great

score 1 · Answer 12 · answered Apr 15 '21 at 12:05

1

Enable the "keep database connection open". I think its not showing because of .close(). See the image for your reference.

See image

answered Apr 15 '21 at 12:05

Jim

39
2

Akshay Raiyani · Answer 13 · 2021-04-20T09:34:20.393

1

I faced the same problem, I Open the Layout inspector and after that, I open the Database inspector, It works for me. seems like a bug of android studio

edited Apr 20 '21 at 09:34

answered Apr 20 '21 at 09:08

Akshay Raiyani

1,243
9
21

score 1 · Answer 14 · answered Jan 19 '23 at 14:08

1

had to restart emulator and started working again

answered Jan 19 '23 at 14:08

nGL

333
3
12

score 0 · Answer 15 · answered Nov 24 '20 at 07:33

0

I face this issue on many devices. Kill the app process and run again. The application should be in the foreground.

answered Nov 24 '20 at 07:33

Amirhosein

4,266
4
22
35

score 0 · Answer 16 · answered Dec 15 '20 at 11:01

0

Every time I faced with this issue, I'd unplugged the usb cable, then plugged it again. Then make sure the database inspector window is open. After that, every time the database is accessed, it'd appear in the window

answered Dec 15 '20 at 11:01

Irfandi D. Vendy

894
12
20

score 0 · Answer 17 · answered Jan 07 '21 at 15:14

In my case, I had two databases in assets under the same directory and only one was showing on the inspector no mater how many times I killed and restarted the process. In the end I found that it was not showing up because I needed to store the second database file in a separate folder

structure assets > folder > db_file.db assets > other_folder.db > other_db_file.db

such that the folder and the database file had the same name.

Example assets > my_database.db > my_database.db

After that, both databases showed up on the database inspector

score 0 · Answer 18 · edited Sep 18 '21 at 14:35

0

I was emptying the cache (cache and code_cache) at each startup of my application.

When I did comment the line and stop deleting the cache, and unplug/plug back the phone, I got the database inspector showing my tables back again.

edited Sep 18 '21 at 14:35

Dharman

30,962
25
85
135

answered Sep 18 '21 at 14:29

Antoine Driot

46
1
1
5

score 0 · Answer 19 · answered Jan 08 '22 at 07:11

0

Select debug build variant.
Keep the device connected and deploy the app on the device.

answered Jan 08 '22 at 07:11

Bruce

793
8
17

score 0 · Answer 20 · answered Sep 28 '22 at 17:47

0

Deleting app cache in simulator worked for me ;)

answered Sep 28 '22 at 17:47

Johan Ordenes Galleguillos

720
5
11

score 0 · Answer 21 · answered Jul 12 '23 at 07:48

0

New Way to see Database Inspector

In new android studio versions, "Database Inspector" is display inside "App Inspector" in bottom bar options, Just expend App Inspector:

answered Jul 12 '23 at 07:48

Abdul Waheed

562
6
14

Android studio database inspector does not show any databases

21 Answers21

Linked