Switch Between Databases - Retain Saved Relationships

[andre-scheinwald]

Please describe.
After setting up a connection to a database, selecting tables, defining relationships - It would be nice to be able to set up a connection to a database on a different server while retaining the settings of the other database. Basically allow a user to switch back and forth between what database they are querying. Without having to redo the setup process each time.

Describe alternatives you've considered
I haven't really thought this through. Aside from maybe trying to create different saved instances of wrenai using the docker image.

[wwwy3y3]

@andre-scheinwald thanks for the feature request! We'll discuss internally about the possibility of switching databases.

[qdrddr]

I would expand this into be able to have different versions of DB and then switch from the "old" version to the most recently new version preserving preserving old connections (if the required connected fields still exists).

So the idea is to:

• Have a separate DB for Production with full dataset & for WrenAI, lets call it staging DB, with limited number of records,
• create schema in WrenAI,
• Then if production updates, remove or adds new fields, copy that to the Staging DB
• Review new version of DB, adjust Schema and comments in WrenAI UI
• Switch WrenAI to use the most recent new version of the DB