PyCharm Community Edition and Database Navigator

For the Community Editition there is a plugin that allows to edit or query databases directly from PyCharm. Currently MySQL, Oracle and Postgres are supported. The benefit, You as a tester (or developer) need to use no other tools.

Preparation

  • PyCharm is installed
  • Running Postgres server
  • Download latest JDBC driver (PostgreSQL)

Instructions

Search and install the “Database Navigator”. Restart PyCharm after installation.

PyCharm Database Navigator

Setup the connection. The following example shows a connection to Postgres.

Postgres connection

Insert all needed values. As driver library select the JDBC jar file. The URL should follow the syntax like:

jdbc:postgresql://host:port/database

To verify your settings, use the test button.

Now you can query, just select the schema and insert your SQL statements.

Database Navigator usage