DATABASE_URL=“mongodb://root:prisma@localhost:27017/groovy_db?authSource=admin&retryWrites=true&w=majority”

Your AWS DB is probably not localhost? Also, cloud dbs tend to have additional security measuers, e.g. SSL using certificates. I suggest trying to find the relevant DB URL for the service you use.

I created a EC2 instance and setup mongodb there and have a nodejs app running in the instance.