PyCharm Tip: Show only tables

If you work with PyCharm or DataGrip with a database and you want to access the table data it can be pretty annoying to get to them since you have to select the Connection -> Database -> Schema -> Tables - quite a few clicks.

Here’s how you can reduce the number of clicks:

• Click on the Cog (settings icon) in top-right corner in the Database Window in Pycharm
• Uncheck: Group Data sources, Group Schema and Show Intermediary Nodes
• Click on the Filter button inside the Database window and uncheck all the Objects you don’t want to see such as Role or Access Method.

You can also watch the video below on how to do it.

Good luck!