8

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.

10

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).

  • 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 '14 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 '15 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. – O. R. Mapper Apr 25 '15 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 '15 at 7:09
  • 1
    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 '17 at 12:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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