I am looking for a database documentation software where I want to incorporate the output in LaTeX. I want to show the table structures, primary keys and other related information.

I found pst-dbicons (http://www.ctan.org/tex-archive/graphics/pstricks/contrib/pst-dbicons) at CTAN. I will forced to use this if I don't find an alternative. But I am not exactly looking for an ER diagram software.


Based on the comments and web search, eventually I came up with a working framework for my purpose which might be useful for others.

enter image description here

sqlt-graph --show-datatypes -l dot -n record -f MySQL -t png --graphattr center,margin="0.0,0.0",overlap=false,sep=10,size="20.0,14,0",orientation=landscape --nodeattr fontsize=24,fontname=Helvetica --edgeattr weight=0.05,len=2.0 -o output.png input.sql

  • This produces a .png file which can be used in LaTeX or anywhere else.

  • When included in LaTeX, the output looks something like this (partially smudged out to preserve confidentiality).

Sample output from real life

  • 1
    For better results, I suggest to use PS or SVG(Z) format. – Paul Gaborit Mar 13 '13 at 0:37
  • @PaulGaborit Thanks. Yes, in that case we will have to use -t ps or -t svg instead of -t png. – Masroor Mar 15 '13 at 8: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.