[Joy] You can now connect to RDS (Aurora) on a private subnet in a CloudShell VPC environment
This is Onkai Yuta (@fat47) from the Service Reliability Group (SRG) of the Media Headquarters.
#SRG(Service Reliability Group) is a group that mainly provides cross-sectional support for the infrastructure of our media services, improving existing services, launching new ones, and contributing to OSS.
This article describes the feature update to CloudShell, which now allows you to connect to RDS (Aurora) from CloudShell.
I hope this helps in some way.
CloudShell VPC environment feature updateConnecting to RDS (Aurora) using CloudShell VPC environmentConclusion
CloudShell VPC environment feature update
On June 13, 2024, CloudShell's functionality was updated to allow it to be launched in any VPC environment (specifying a subnet).
For more information, please see the Classmethod article.
The AWS CloudShell User Guide provides initial information about the update, including an announcement of new features.
Until now, CloudShell could only be created in public environments, so it was not possible to access resources in private VPCs.
With this CloudShell VPC environment feature, you can now use CloudShell in the same environment as the VPC in which RDS is running.
This means you can connect to RDS on a private subnet.
You can also assign up to five security groups to a CloudShell environment, so you can assign security groups that can connect to Aurora MySQL.
There are some restrictions, such as the inability to use persistent storage, so you need to be careful about them.
This is a major update, as until now it was not possible to connect to the database without setting up a jump server.
Connecting to RDS (Aurora) using CloudShell VPC environment
Launch CloudShell and select "Actions" in the upper right corner → "Create VPC environment (max 2)"

Name: [any environment name]
Virtual private cloud (VPC): [Select the VPC you want to launch]
Subnet: [Select the subnet you want to start]
Security group: [Security group to assign (up to 5)]
Enter the information and press "Create".

The CloudShell environment will start up, and all you have to do is connect to Aurora MySQL.
The client had MariaDB 10.5.23 installed.
Conclusion
Until now, it was necessary to set up a stepping stone environment just to perform simple database operations.
With this latest feature update, you can now perform simple operations without having to prepare these environments!
It's nice to see an update that hits the spot.
SRG is looking for people to work with us.
If you're interested, please contact us here.