Connect Pandas to a remote PostgreSQL database via SSH
Use Pandas to execute SQL statements in a remote database such as PostgreSQL via SSH

Use Pandas to execute SQL statements in a remote database such as PostgreSQL via SSH

Setting up proper port forwarding for SSH connections, servers or just test purposes is crucial but isn't as straight forward as your connection should be. This post aims to be a quick guide for different use cases.

Port Forwarding in Virtual Box - Postgres example

A quick guide to setup a SSH-conncection to Virtual Machine Ubuntu Server 20.04
