How to connect to remote AWS/RDS database

so how would one connect a gitpod workspace to through AWS security groups to connect to an RDS database if the security group doesn’t have ports open on the public internet and there is no static IP for gitpod?

the RDS instance has to be connected to the VPC using subnets.
Best regards