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 sql