Free SQLite Manager for Mac OS

Sqlite-manager is a tool that originated as a Mozilla (Thunderbird, Lightening, FireFox) plug-in for managing SQLite databases. However, over at the Kiveo website blog, I found instructions for making this plug-in a stand-alone application.

I followed the directions exactly as posted (note though, that the current version of the sqlitemanager-xr packageis now 0.5.16) and it works perfectly.

Here's a running list of the current 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

And here's a screenshot of it running happily on my Mac (OS 10.5.8)