I’ve been playing with a DB for a personal project, and I want to start again, and sketch out some ideas on how to set it up. I only want a GUI that I can set up tables and connect them together and set their properties. Maybe add notes.
Just a simple UI tool. I don’t want it to access my db or whatever, I just want to sketch it out. What do you use for DB planning?
I use
mermaidorPlantUML, so I can write it out in text and get a visual render inside vscode (just get yourself a mermaid or PlantUML extension)draw.io aka diagrams.net
Save as .drawio or .svg and add to revision control
Note that the .svg (or .png, for that matter) contains the metadata for draw.io itself, so you can basically have a regular .png that you can also open in draw.io.
Just don’t optimize the .png for filesize - the metadata will be removed, and you won’t be able to edit the file anymore.
Same for the .svg with https://svgomg.net/
SOLD!.. to the gentlemen that recommended the electron app 😭
Good old Dia: http://dia-installer.de/
Seconding draw.io as the swiss-army-knife that’ll do this and more…
But honorable mention to graphviz if you want dead-simple, low-friction charts: https://zackees.github.io/webgraphviz/
Mysql workbench comes with diagramming tools.
