Managing connection sessions

Last modified: 13 September 2021

Professional feature: download PyCharm Professional to try.

In the Services tool window, you can view data sources (1), connection sessions (2), and session clients (3).

The Services tool window

When you connect to a database server from the IDE, PyCharm and the server establish a session to exchange information. The session is a wrapper that stores information about the connection (connected or disconnected), transaction control (automatic or manual), the DBMS_OUTPUT state for Oracle (enabled or disabled), and other settings.

A session has two states: connected and disconnected. When you run a query to a database or refresh an object state, the session connects. A small green circle indicates that communication between the IDE and a data source is active.

If you close PyCharm and open it again, all your sessions will be available in the Services tool window, but they will be disconnected.

A session node may include a different number of session clients. A session client is any entity that needs to communicate with a database. It can be a query console; an SQL file; a table, a view or any other object opened in the data editor.

The following table includes basic actions that you can use to work with sessions.