Devops and migration schemas management for production

Anyone has suggestions on migration management with appwrite

I am going to have one app that will have different isolated deployment. So I need to have updated changes for example script or whatever to apply to different appwrite database projects.

One option is manual updating on console but if i have many more it will be painful.

Something generated script to click to apply production appwrite schema to different projects

Can you use the cli tool and the appwrite.json file?

yes that is very helpful tool. if in production we have production data. and there is changes in schema. is it safe to use appwrite push to datababae?

I think it should be fine, but it doesn't look like it uses transacations so I guess you could get into an instance where some items deploy but not everything.

if it already production, and you have alot of changes need to deploy like V2 . what step are you taking into actions? if it were to be raw sql, I generate changed script to apply. but i cannot find pratical way in appwrite document mentioned