If you need to access an Amazon RDS instance locally you can:
- Add your IP on the RDS Security Group
- Create a tunnel to the RDS
Best chances are you have a dynamic IP address, so you already know that option 1. is a real pain.
You can create a tunnel (2.) by performing the following command on a new terminal window:
ssh -l <username> -L 33060:<ec2_rfc_ip>:3306 -N <ext_hostname>
As long as you keep this window open, you’ll be able to access the RDS by connecting to localhost on port 33060: