What is the best practice to deploy migrations to production on AWS RDS?

Hey!

So I am using Prisma ORM and I was wondering what are the best practices regarding Prisma to deploy database migrations to production when using AWS RDS within a private subnet.
There are some possible solutions but they all feel quite engineered so I was wonder if there was a straightforward best approach that you would recommend.

Thanks!