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.
Setup the connection. The following example shows a connection to Postgres.
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.