Multiple remote environments

[olirice]

Feature request

AO version 0.15.16

Currently one remote is allowed, set with

supabase db remote set <connection_string>

Could this be extended to support multiple environments?
ex (copying git):

supabase db remote add staging <connection_string>
# or
supabase db remote add production <connection_string>

with a selectable remote for supabase db push
ex:

supabase db push staging

?

[joshuaheslin]

+1

Having the ability to configure different remote contexts would be amazing. I suppose, similar to how kubectl context or git remote works.
I am always reading supabase help very carefully before making any call. i.e will this call impact local, or staging or prod?