Hey 👋 I am just integrating Prisma in our workflow and have a question about the CLI commands and where in our CI/CD to run them.

npx prisma db pull

for example needs to connect to the database which is running inside of our Kubernetes cluster. As we are using TLS certificates to authenticate the client (node app in this example) with the database, we don’t have access to those certificates in our build process. Where should I run those commands? Am I missing something here? Similar question about

npx prisma migrate deploy

. Thank you for your help!

Hey Oscar! Usually it’s a good idea to run it after the build process because your build could fail and in that case you would probably not want to have any database changes applied

Hey Joël, thanks for the quick reply! You are talking about

prisma migrate

right? My idea here is to use an initContainer so that the migration happens on pod startup. Does

prisma migrate deploy

write to the file system?

Right I was talking about

prisma migrate deploy

@Oscar Stahlberg @Joël are you running it similar to this workaround? there's no programmatic way of doing this right?

@Danily

there’s no programmatic way of doing this right?

No, though technically yes but it’s not a supported API nor documented and we will break it in the future. But we’re very interested in your use case, if you can share it here or in the issue! 📝 So we can have all the feedback we can to design it properly.