After installing the addon, the SQLite Manager is accessible through Tools menu (Click Customize and drag SQLite Manager icon into the Menu if not found by default).
- You can download from Mozilla Addons site.
- 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