Hello! I’m trying to run migration in an AWS RDS instance that’s inside a VPC with prisma2. Here’s what I’ve tried: I have set my current

PRISMA_DATABASE_URL

to be

<mysql://root>:<mailto:password@database.zone.rds.amazonaws.com|password@database.zone.rds.amazonaws.com>:3306/databasename

Then I run

prisma generate up --experimental

. And then I got:

Error: P1001: Can't reach database server at `<mysql://root:password@database.zone.rds.amazonaws.com:3306/databasename`:`3306>` 

Please make sure your database server is running at `<mysql://root:password@database.zone.rds.amazonaws.com:3306/databasename`:`3306>`.

Which I think is expected… I don’t think I’m supposed to be able to run arbitrary things against my db from anywhere. FWIW, I have a EC2 instance where I can use to SSH into the database so I know it’s there. I’ve seen others making the RDS publicly accessible but I’m not sure if that’s secured enough? Has anyone able to run migrations for RDS inside VPCs ? What if I want to do this from Github Actions CI/CD? Any help is appreciated 🙏