Which tools are available to reverse engineer a sqlite database?

Question

I would like to obtain the diagram design of a sqlite DB by reverse engineering it, so I can avoid the study of the schema by myself and have an approximate idea of what I am dealing with quite quickly.

Do you know of some tool that has this feature?

EDIT:

I was already using SQLite Database Browser but I really need the DB diagram and, like the DB is likely to change, I would like to have a tool that generates this diagram from the DB automatically.

I have been searching but I did not found any tool that does exactly that for sqlite (maybe does not exist?). In that case, recommendations of good tools for drawing diagrams (BD diagram, Class diagram...), specially for Mac OS, are also appreciated.

Answer 1

I use the SQLite Database Browser however it has no GUI for getting a diagram, but it shows all tables and lets you search and view contents

Answer 2

One of the easier utilities for viewing an SQLite database is Firefox's SQLite Manager add-on. Unless the database in question was created with a modified source base for SQLite, any normal SQLite database will include the schema in the sqlite_master table. No need for any special reverse-engineering effort.

Answer 3

SchemaCrawler for SQLite will allow you to reverse-engineer your SQLite database, including finding implied foreign keys, and generating database diagrams with the help of GraphViz. The download link is http://sourceforge.net/projects/schemacrawler/files/