I am trying to access my private rds instance from my local machine so that I can view its data using gui tools. I have read you can use a ec2 instance as a bastion host to access. For my application setup, I am using an ec2 instance for my backend which is already in the same VPC as my rds and I have set up the proper security group.
Rather than launch a new ec2 instance, could I just use the existing ec2 instance that I am using for my backend? Since I am seeking to launch this application into production mode, is this a bad idea?
I am new to RDS and VPCs in general so I would just like to know.