Fargate is indeed not a supported environment, meaning Mendix does not test on it.
That said, in theory it should work. When you set DATABASE_ENDPOINT, you shouldn’t need any other database related setting. See the examples at: https://github.com/mendix/docker-mendix-buildpack#startup