Hi @r4881t ,
I will respond to this question You can take a look at this guide I made which is using an NGINX instance as an API gateway.
Now coming back to your original question, I notice the following:
You are running the migration during the build of the container
RUN kong migrations bootstrap -v
It will not work since the build nodes are running on Qovery instances without access to your infrastructure. So, I recommend running this command inside your Entrypoint file /docker-entrypoint.sh
. Then it will be executed at the runtime (on your infrastructure) instead of build time (our infrastructure).
I think this may solve your issue
One more thing, I would recommend not exposing your database publicly.