How to access RDS from private subnet for both Linux and Windows

You should never expose your database outside of your private network.

Let’s use RDS as an example, if you want to access RDS instance, you will need to have a bastion (also called jumpbox). It can be as simple as an EC2 instance has a public interface.

The way you could do it is just use a SSH tunnel.

ssh ec2-user@ -i ~/keys/jumpbox.pem

If you don’t familiar with Linux, you could just create a windows box in a public subnet. and RDP into the Windows jumpbox. Install whatever client you need to access it from there.