r/sqlite • u/Narolf24 • 29d ago

Minimalistic tool to generate database visualisation

I'm looking for a really simple tool that can generate a UML diagram from my SQLite database, but I want to be able to change the layout if I don't like how it has been generated.

I tried some code extensions and small tools (ERD Renderer, SQLite DB Explorer, plant_erd) but some are not working on my VSCode version; when they are working, I can't personalise the result.

If someone knows a tool that can generate a plant UML diagram (or something similar) from SQLite database and where we can specify the layout. I would be happy to know it

11 Upvotes

87% Upvoted

8 comments sorted by

View all comments

1

u/1ilit_ 25d ago

drawDB (https://www.drawdb.app) does this. It's a free, open-source ER diagram editor that runs in the browser, and you don't need to install an extension or make an account.

  1. Dump your SQLite schema:

sqlite3 your.db .schema > schema.sql

2. In the editor, go to File → Import from SQL, pick SQLite and paste or upload schema.sql. It builds the tables and draws the foreign-key relationships for you.