Pycharm does not display database tables

Question

After updating PyCharm (version 2017.1), PyCharm does not display sqlite3 database tables anymore.

I've tested the connection and it's working.

In sqlite3 client I can list all tables and make queries.

Someone else has get this problem? And in this case could solve anyway?

Answer 1

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

Answer 2

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.