[Django]-Pycharm does not display database tables

I am using PyCharm Professional v2017.3.

In Database pane, click the plus button and add Data Source -> Sqlite (Xerial). Data Sources and Drivers settings will open up where you will see Driver: Sqlite (Xerial). This does not mean drivers are fully installed. Look at the bottom-left of the pain for a message. If it has a warning sign about missing files, install missing files. Otherwise it will say no objects.

Yeah, Pycharm seems stupid on that, I’ve stubled upon the solution with a bunch of luck:

1. Make sure you have all schemas shown: db->Schemas
2. Still, the tables do not show..until you select the db and hit Reload: Cmd+R or Context menu

After clicking on the View => Tools => Window => Database click on the green plus icon and then on Data Source => Sqlite (Xerial). Then, on the window that opens install the driver (it’s underneath the Test Connection button) that is proposing (Sqlite (Xerial)).

That should do it both for db.sqlite3 and identifier.sqlite. I have never any problem with Sqlite database, showing on PyCharm IDE.

It might be stupid thing but consider that you have to connect actual DB and not only indentifier.

The fastest way is to double tap on the DB file in the file explorer and Pycharm will automatically suggests everything.

Pycharm screen

UPDATE:

I am using Pycharm 2022.3.2 Version. I was trying the hit and try method for hours now and it seemed to work for me.

1. View-> Tool Windows-> Databases
2. Once Databases Open on the left side pane.
   Click on the + button and choose `Data source from Path
3. Then choose the path of your db.sqlite3 file and click open
4. After that Choose the drive from the drop down and choose sqlite and click OK
   
5. The db should work fine now and tables should be populated as per the data. Atleast mine did. Try this and let me know if that works!!!