You should manage SSH on the OS level a vast majority of the time. There is little benefit to bundling that into the tap
ssh <name>@<server_ip> -L <localPort>:<127.0.0.1 or remote host if using jumpbox>:<remotePort>
Exclusively in meltano, I would imagine a utility plugin that interpolates the shell command for the ssh invocation