FeatureFuel
13

Restrict database schema changes in web UI

Source: supabase/supabase#20738 · opened by @Magnuti
In my team we are developing locally using migrations. These migrations are added to Git and we use GitHub Actions to deploy the migrations to our Supabase instance. This workflow works excellent for us as it is robust and allows us to track database changes.

However, we find it "too easy" to accidentally modify the database schema in our remote Supabase instance. Since we use the web UI locally to make database schema changes, once or twice we have accidentally changed our remote Supabase instance instead of our local Supabase instance.

Could it be possible to disable the "Insert column" button in settings, so that the only way to change the schema is through migrations or by SQL queries?

<img width="254" alt="image" src="

This is especially important for production instances, where we often want to view or update data, but we never want to make schema changes directly in production.

No pledges yet. Be the first to back this.

Make a pledge

Pledge your monetary support if this feature is added.

$

Comments

No comments yet.

Replying to

Add a comment

What do you think about this feature request?


Similar requests