aSQLiteManger is my SQLite manager for Android.
You can:
Open databases from within aSQLiteManager and from a number of file managers.
List tables, views and indexes.
Display data, structure and definitions SQL for tables and views.
Execute any SQL including 'Drop' / 'Create' statements (simple SQL builder included).
Add and edit records from data browser (Add button at title / Edit button at each row).
Copy the content of any cell to the clip board by clicking at it
Store all executed statements in the opened database (in a table called aSQLiteManager).
Select SQL history from query form.
Begin transaction, Commit and Rollback.
Export database to SQL script and restore databases from script.
Export to ASCII file of query results.
Execute SQL scripts, full script or single lines.
SQLite does not validate data types during data entry but aSQLiteManager set the Android input mode reflecting the field types.
You cannot:
This version aSQLiteManger does not support rootet phones (working on that). You cannot view and edit databases in system catalogues like '/data' and '/dbdata'.