11

I have a SQLite database that I have created. In order to document it, I hope to create an ER diagram. Is there a free tool out there that will import the database and spit out an er diagram? Any platform is fine, though Windows I guess is the slight preference.

3 Answers 3

11

One tool is Schema Crawler (along with a graphics add-on) which is open source. It is java based, so should run on windows (or almost any other OS).

5
  • 1
    It works pretty well out of the box. I just need to do a few minor tweaks and I have it. Thanks for the suggestion
    – demongolem
    Mar 25, 2014 at 21:55
  • 3
    Really? It seems to have a bunch of 3rd party dependiences - downloadable, but not bundled. I'm getting "Graphviz was not available to create the requested graph (...)" when attempting on a clean install
    – Nilzor
    Apr 22, 2015 at 12:27
  • 3
    It seems slightly cumbersome to use. Rather than just invoking something like creatediagram mydbfile.sqlite after adding the installation directory to the path, it seems one has to run some script for starting a db server and then run the application with a long chain of parameters, which will then somehow access the runinng server. Apr 25, 2015 at 9:58
  • A solution which involves opening your Sqlite Db in a tool, exporting it & then importing into MySql Workbench, is slightly less trouble. It's what I am doing - until I can find a simpler, free, solution. See stackoverflow.com/questions/10972916/…
    – Mawg
    Jul 9, 2015 at 7:09
  • 2
    On Linux, with package graphviz installed, for sqlite databases, the command to generate a schema diagram is ./schemacrawler.sh -server sqlite -database $db -password="" -infolevel=standard -command=schema -outputformat=png -outputfile=mydb--diagram.png where $db is just a string with the absolute path to the .sqlite file.
    – knb
    Dec 17, 2017 at 12:10
1

I have recently discovered this tool which has an ER Diagram capability based on SQLite datatbase (in actual fact, I use geopackages - a GIS implementation of sqlite databases.

DBeaver

The only issue I had was the software itself needed the sqlite.jdbc drivers installed and configured manually - It didn't pick them up automatically You just need to configure the application to look for the sqlite.jdbc drivers (download them first obviously, set in classpath, then configure DBeaver to look for that folder for drivers).

enter image description here

0

There is a handy homemade tool: sqlite3todot. Very tiny that only includes a 191-line C file, and renders with dot/graphviz.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.