Can I connect to a DB through ssh tunnel?

Insights
1

Is it possible to connect to mysql DB via ssh tunnel? My DB is not exposed publicly

2

You can try using ssh as a proxy. For example using the following will allow you to connect to MariaDB via local app like DBeaver using localhost as the server field.

ssh frappe@10.1.22.26 -L 3306:localhost:3306

Then you can use any client software to connect using servername:port# like
localhost:3306

Many client apps also have tunnel mode which will allow you to save the ssh info and there will be no need to run the above command in terminal first. Both DBeaver and SQLElectron have ssh tunnel settings.

3

@volkswagner Thanks for the reply, Current i am using the SSH tunneling to connect to DB from my local machine, I was interested to know can the same tunneling happen in frappe insights so as I can build dashboard