Related Plugins and Tags

QGIS Python Plugins Repository

Remote DB Plugin

Plugin ID: 2905
(4) 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.

Author
Lymperis Efstathios
Maintainer
elymperis
Tags
pythondatabaseremotetunnelssh
Plugin home page
https://github.com/lymperis-e/qgis_remote_db_plugin
Tracker
Browse and report bugs
Code repository
https://github.com/lymperis-e/qgis_remote_db_plugin
Latest stable version
1.2.3
Plugin ID
2905
Version Experimental Min QGIS version Max QGIS version Downloads Uploaded by Date
1.2.3 no 3.0.0 3.99.0 542 elymperis 2024-01-14T15:42:17.332633+00:00
1.2.2 no 3.0.0 3.99.0 462 elymperis 2023-11-04T15:43:38.443035+00:00
1.2.1 no 3.0.0 3.99.0 158 elymperis 2023-10-22T15:02:48.794559+00:00
1.2 no 3.0.0 3.99.0 310 elymperis 2023-10-15T16:46:11.150447+00:00
1.1.1 no 3.0.0 3.99.0 543 elymperis 2023-04-27T16:37:22.258760+00:00
1.1 no 3.0.0 3.99.0 267 elymperis 2023-03-20T13:03:07.321330+00:00

Sustaining Members