I have a PostgreSQL database running on AWS RDS. The cluster isn't publically available but requires a bastion host. I am able to connect to the db through the bastion host using the DBVisualizer
tool.
Now, I'd like to set up a project using Prisma as an ORM, but I can't figure out how to connect to AWS using bastion host. From the documentation I've managed to construct my URL string like this:
DATABASE_URL="postgresql://<username>:<password>@<cluster-endpoint>.ca-central-1.rds.amazonaws.com:5432/postgres?schema=<schemaname>&sslcert=my-cert.pem&ssl_mode=require"
but of course this won't work, since nowhere am I specifying the bastion host URL. How to formulate the connection string using the bastion host?