Recommended way to interact with Aurora Serverless v2 without public access

Question

Aurora Serverless V2 doesn't yet support the built in SQL editor. I cannot connect to it from PGadmin or other IDEs. how do I run my DDL's against it? when I first need to create schemas and tables?

I'm using postgres flavour of this.

Answer

You can create a bastion host (EC2 in same VPC as Aurora Serverless v2) and use SSH [tunneling](https://www.google.com/search?q=pg+admin+ssh+tunnel&rlz=1C5GCEM_enUS1011US1011&oq=pg+admin+ssh+tunnel&aqs=chrome..69i57.2180j0j7&sourceid=chrome&ie=UTF-8) in PgAdmin or any other client tool for connection and running queries.

Answer

You can also create a client vpn then you are able to use PgAdmin or other tools to access the RDS instance over the VPN.

Recommended way to interact with Aurora Serverless v2 without public access

Relevanter Inhalt