Manage Connections

Table of contents

• Edit a connection
• Apply changed settings by reconnecting
• Control connections
  • Connect to a database
  • Disconnect from a database
  • Disconnect all connections
  • Invalidate and reconnect a stale session
• Manage saved connections
  • Rename a connection
  • Copy a connection
  • Delete a connection
  • Organize connections in folders

This article describes how to update saved connection settings, manage connection state, and organize saved connections.

Edit a connection

1. Right-click the connection in Connections and select Edit connection.

   

2. Update the required connection settings.

3. Select Test Connection to verify the updated configuration.

4. Select OK to save the changes, or Cancel to discard them.

Note: If an active connection's saved settings change, reconnect to apply the new settings to the active session.

Tip: You can change the current database user's password. Learn more.

Apply changed settings by reconnecting

Reconnect after saving changed settings for an active connection.

1. Edit an active connection and save the changed settings.
2. When DBeaver asks whether to reconnect, choose to reconnect and apply the new settings.

Note: If the connection has an open transaction, choose whether to commit, roll it back, or cancel before reconnecting. For information on transaction handling, see Auto and manual commit modes.

Control connections

Connect to a database

1. Select a connection in Connections.

2. Choose Connect () from the toolbar.

   Alternatively, choose Connect from the Database menu or the connection's context menu.

Disconnect from a database

1. Select an active connection in Connections.

2. Choose Disconnect () from the toolbar.

   Alternatively, choose Disconnect from the Database menu or the connection's context menu.

Note: If the connection has an active transaction, choose whether to commit, roll it back, or cancel the action. For information on transaction handling, see Auto and manual commit modes.

Disconnect all connections

1. Open the Database menu.
2. Select Disconnect All.

Invalidate and reconnect a stale session

Use Invalidate/Reconnect to replace a stale session without changing the saved connection configuration. This action is different from reconnecting after changing settings.

1. Select the active connection in Connections.

2. Choose Invalidate/Reconnect () from the toolbar.

   Alternatively, choose Invalidate/Reconnect from the Database menu or the connection's context menu.

Manage saved connections

Rename a connection

1. In Connections, right-click the connection and choose Rename. Alternatively, select the connection and press F2 on Windows/Linux or macOS.
2. Enter the new name and complete the dialog.

Copy a connection

1. In Connections, right-click the connection and choose Copy.
2. Select the destination folder or node, right-click it, and choose Paste.

Delete a connection

1. In Connections, right-click the connection and choose Delete.
2. Confirm the deletion by choosing Yes, or choose Cancel to keep the connection.

For information on connection actions, see Connections.

Organize connections in folders

1. In Connections, right-click the location where you want the folder and choose Create -> New Folder. Alternatively, use Alt+Insert on Windows/Linux or ⌘+N on macOS to open the creation choices, then select New Folder.
2. Drag connections into the folder.
3. To create a subfolder, right-click an existing folder and choose Create -> New Folder, then drag connections into the new subfolder.

For information on organizing connections in folders, see Connections.