Local to Prod DB Shift without transferring the db data

System Information
  • Strapi Version: 4.24.0
  • Operating System: Windows 11
  • Database: PostgreSQL
  • Node Version: 20 LTS
  • NPM Version: 10.2.3
  • Yarn Version: 1.22.21

I am building a blog application and I have a scenario where I’ll be making schema changes to my staging server while my main server will have the data live on it. Even in future development cycles, I’ll be making changes to schemas, permissions, configs, and other stuff. I don’t have a lot of experience with Strapi, but I have faced issues when I try to make changes in schemas in my local database and then when my Strapi connects to the server, it gives me random errors while working on the new schema. For example, I wasn’t able to update permissions to my new collection that I created on the local database and then connected the Strapi to the hosted database.

I am not sure if I have explain well. do let me know if I need to explain it further. thanks