Supabase migration confusion

Hi I'm having a bit of confusion with the Migrations.

Is the suggested way to make changes to a Supabase table via SQL or the UI or both? If both how do I ensure my local development is always up to date with my production with multiple developers?

I feel the migration documentation is very surface level and doesn't really go into real production/development use cases unless I've missed something?
Was this page helpful?