Hey there. I am building software that does not run centrally on one server, but on multiple servers with their own database. This is why I cannot deploy changes as part of a CI pipeline. What is the recommended way then to migrate a database? Do I run

npx prisma migrate deploy

on that machine when updating the piece of software? What can I do to avoid conflicts?

I don't have idea how the CI pipeline works, as far as I know if you have multiple database, you will need multiple prisma clients each with their own prisma schema pointing to their databases urls, then you could deploy respective migrations with

npx prisma migrate deploy --schema=PATH_TO_SCHEMA