Backend database management

[chriskapp]

Currently at Fusio it is not possible to manage a database (change the schema), we only provide a readonly view with our connection inspection feature, there you can see all tables and columns s.

This means a user needs to either use an external database client like the mysql workbench or install i.e. an app like phpMyAdmin. In the past we have argued, that Fusio is not a database management tool and it should focus on the API management part. Also if you use Fusio as framework you use migrations to manage the schema and there is no need to manage the schema at the backend.

On the other side if users use Fusio in the cloud it would really help them having a direct way to change the schema. For example if you look at providers like Supabase they also provide a database management tool s.

In general we could also integrate such a management tool directly into the Fusio backend so that every user can manage the schema at the backend. Maybe we can also add a config flag to indicate whether this feature is active.