[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) mainly provides cross-sectional support for the infrastructure of our media services, improving existing services, launching new ones, contributing to OSS, etc.
This article describes the feature update to CloudShell that 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, the CloudShell functionality was updated to enable 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 about the 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, it is now possible to use CloudShell in the same environment as the VPC in which RDS is running.
This means that you can connect to RDS on a private subnet.
In addition, you can 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 those.
This is a major update, as until now it was not possible to connect to the database without setting up a bastion server.
Connecting to RDS (Aurora) using CloudShell VPC environment
Start 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 click "Create".

The CloudShell environment will start up, so all you have to do is connect to Aurora MySQL.
The client was MariaDB 10.5.23 installed.
Conclusion
Until now, it was necessary to set up a staging 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 addresses the issues we've been looking for.
SRG is looking for people to work with us. If you are interested, please contact us here.