Skip to content
lazierthanthou edited this page Feb 28, 2015 · 4 revisions

SQLite Manager is a lightweight extension for firefox, thunderbird, seamonkey, komodo etc. to help you manage all your sqlite databases

Downloads

  • SQLite Manager is available as a XULRunner application too. The file with XR in its name is the zip of the XULRunner application. Read More...
  • You can also download from Mozilla Addons site.

SQLite Manager for other applications

Features

  • dialogs for creation, deletion of tables, indexes, views and triggers
  • ability to rename, copy, reindex tables
  • ability to add and drop columns
  • create new db, open any existing db, copy an existing db
  • supports writing your own queries (single or multiple)
  • supports saving the queries with a name
  • a tab for database settings (no need to write the pragma statements) where you can view and change the sqlite library settings
  • export tables/views as csv, sql or xml files
  • import tables from csv, sql or xml files
  • a dropdown menu showing all profile db (.sqlite)
  • an intuitive heirarchical tree showing all tables, indexes, views and triggers
  • ability to see the master tables
  • ability to see the temporary tables, indexes, views and triggers
  • ability to browse data from any table/view
  • dialogs to allow searching in a table/view
  • allows editing and deleting selected record while browsing a table's data
  • allows adding, saving and changing blob data
  • an extensive menu that helps with writing sql by hand and then executing it
  • remembers the last used db, table and the tab (structure, browse & search, etc.) across sessions