How to generate SQLite entity relationship diagram from database file

Question

I am trying to reverse engineering to a database file that an android application generates. It gives me a SQLite file in .db extension. I tried pass it through SQLite Browser and it gets me the tables, but no relationships also every table givesme "id" for primary key. Any help or suggestions on how to approach this would be great, thanks!

freshpasta · Answer 1 · 2021-12-08T03:20:42.423

After extensive search, I found that you can do it without running a server using DBVisualizer. After you install DBVisualizer, import your database, then expand the database connection which is on the left under Connections, expand schema then double click Tables. Switch to References tab in the pane on the right and you'll have your diagram.

I have also found about SchemaCrawler which is free and open source unlike DBVisualizer and also doesn't require running a server, but have yet to get it to work. You can follow this guide if you wish to use this instead.

Example of ER diagram generated by DBVisualizer

score 3 · Answer 2 · answered Dec 08 '21 at 12:38

3

The quickest way to do this is by using the SchemaCrawler web application. If you need to keep your database private, you can use the approach suggested by @freshpasta

answered Dec 08 '21 at 12:38

Sualeh Fatehi

31
2

That link gives a 404 ... – tink Mar 11 '23 at 21:14

score 1 · Accepted Answer · edited Jan 09 '20 at 05:58

1

In the MySQL workbench select Database option from the menus available on the top of the screen,there you will get reverse engineer option. Click on it then select your server and database on which you want to create ER diagram and click next.

edited Jan 09 '20 at 05:58

Tek Nath Acharya

1,676
2
20
35

answered Jan 09 '20 at 04:24

Payal

44
2

Thanks for the reply. so I have to install something like Xampp to run a server? – jvargas Jan 09 '20 at 21:54
Yes, Xampp is required. – Payal Jan 11 '20 at 17:05

score 1 · Answer 4 · edited Feb 02 '23 at 21:49

A bit late but if you got IntelliJ IDE product you can connect to your "Database" and generate a diagram for it.

https://www.jetbrains.com/help/pycharm/creating-diagrams.html

Note: IntelliJ is paid tool,so you may need a paid version for this trick Or just enable free trial till you do this task.

References https://www.jetbrains.com/products/compare/?product=idea&product=idea-ce https://www.jetbrains.com/datagrip/features/

How to generate SQLite entity relationship diagram from database file

4 Answers4