Related Plugins and Tags

QGIS Python Plugins Repository

Remote DB Plugin Plugin icon

(1) votes 

Manage and open SSH connections to remote database servers

Manage and open ssh connections to remote database servers. This plugin aims to make it easier to connect to firewall protected databases, without using an external ssh tunnel software.
All your connections are listed in the UI, allowing you to easily setup ssh tunnels to an arbitrary number of remote computers, with just a few clicks. Each connection displays the mapping between remote & local ports for convenience.
Currently, you can setup the following parameters:
-name: A name for you top identify the connection (must be unique)
-host: host computer (IP or domain name)
-ssh_port: port on which the remote ssh server is listening
-remote_port: port on which the remote database/service is listening
-local_port: local port to use for forwarding
-username: remote computer username (must have ssh access)
-password (optional): remote computer password
-id_file (optional): an ssh identity file to use instead of password
-pkey_password (optional): the passphrase to the key in the id file
-ssh_proxy (optional): proxy server to use, to connect to the remote host
-ssh_proxy_enabled (optional): wether to use the proxy server

It is recommended to choose a different local port for each connection, in order to be able to open many connections simultaneously. Also, ensure that each connection name is unique.
You can manage your connections via the UI, or you can use the button Settings Folder to open the plugin folder, where the settings live. There, you will find a connections.json, which you can edit or replace in bulk. This is where your connections are stored.
Attention: in connections.json, your credentials are stored in PLAIN TEXT. You 've been warned...

Depends on paramiko and sshtunnel. The latter, developed by Pavel White has been hard-coded into the plugin to simplify the installation process. Its own dependencies though have to be installed when installing the plugin. You will be automatically prompted to install them.

Version Experimental Min QGIS version Max QGIS version Downloads Uploaded by Date
1.2.2 no 3.0.0 3.99.0 190 elymperis 2023-11-04T15:43:38.443035+00:00
1.2.1 no 3.0.0 3.99.0 131 elymperis 2023-10-22T15:02:48.794559+00:00
1.2 no 3.0.0 3.99.0 149 elymperis 2023-10-15T16:46:11.150447+00:00
1.1.1 no 3.0.0 3.99.0 520 elymperis 2023-04-27T16:37:22.258760+00:00
1.1 no 3.0.0 3.99.0 243 elymperis 2023-03-20T13:03:07.321330+00:00

Sustaining Members