Some terms make total sense when this is what you are starting thinking from, and you can’t get to them when you started somewhere else. Seems it is not only my problem but LLMs too. Supabase have AI assistant that you can ask something.
I needed to combine all the migrations into one and was wondering if there is existing tooling available, so I asked Assistant and it gave me two pages of the options how to do it. And it mostly works but it is not really that savvy with supabase CLI.
At the same time supabase CLI has a tool for doing it, and it is named perfectly well
supabase migrations squash
It does exactly what I need, merges or squashes all migrations into latest one, and update local history. It also gives you command to update remote history:
supabase migrations repair --status applied
So there is tooling already and it is named well but AI didn’t help until I sit down and explored the docs for CLI.