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.
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.
Comments
Similar requests
Retrieve list of users by ID
1 vote · 0 comments
Default schema for Foreign Keys
1 vote · 0 comments
Allow selecting a schema in database connection string settings
4 votes · 0 comments
Reorder Schema Visualizer
2 votes · 0 comments
Show schema of function in database triggers list
2 votes · 0 comments
No comments yet.