Schema Import with dbdiagram

💬 Feature Requests
1

I’m creating an app and of course things are becoming much bigger and more complex than anticipated so I thought it would be amazing to have a feature where we could create a full DB schema visualization using tools like dbdiagram.io and then export the sql export function.

I haven’t fully tested it yet, but if someone know if it is compatible would be amazing.

Conversely, given I’ve already started creating tables and quite a few relationships would be amazing to be able to export the sql code from Retool that leads to that schema, so I could import back into dbdiagram and keep working there as it is much easier to visualize relationships and data connections.

Point is… visual tools are awesome.

My ¢2 :slight_smile:

3

Sounds like the schema migration tool may help here, at least to export your schema. If you create a schema migration to a fresh environment, then just view the SQL rather than the GUI you have what is basically a dump of the schema. I’m not familiar with dbdiagram.io, but as long as it exports the visual schemas into a common format, you should be able to do the same process in reverse to import it into Retool. Start a schema migration, switch to SQL from GUI, delete what’s there and put in the export from dbdiagram.

2 Likes