Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a (non-trivial) sqlite2 database that I would like to view graphically through a tool similar to the SQLite manager for Firefox or PHPMyAdmin for MySQL.

Problem is everything I find is (understandably) for SQLite 3. Does anyone know of such a freeware tool for SQLite 2?

share|improve this question
btw I wanted to tag this sqlite2 but don't have the reputation to do that – dtech Feb 11 '12 at 10:45
up vote 0 down vote accepted

Does SQuirreL work?

screenshot table definition screenshot table diagram

Wikipedia's comparison of SQL tools has a column for SQLite. It doesn't specify version but it might make a useful shortlist to check.

A 2007 blog article mentions SQLite (unspecified version but presumably 2007 vintage) and SQuirreL and JDBC.

share|improve this answer
It doesn't explicitely list support but I'll try to get it to work with a sqlite2 JBDC driver – dtech Feb 11 '12 at 16:50

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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