SQLite Workbench

Get answers from a SQLite database on your phone. Open a .db, .sqlite or .sqlite3 file, browse its tables and run a read-only query to find the rows you need. Work from a private copy SQLite Workbench copies the database into app-private storage before opening it. Queries, checks and edits use that copy. The original file is not opened for writing. Useful without upgrading Browse tables, views, indexes and triggers. Read rows in pages and filter a column by contains, is null or is not null. Run one supported read-only SQL statement at a time. Check database integrity and export a table, filtered view or query result as CSV or JSON Lines. Free exports include up to 1,000 rows. Keep track of recent transactions Some SQLite databases keep recent changes in a separate write-ahead log. If Android has not granted access to that log, the app explains what may be missing before showing rows. Grant folder access to include an accessible log, or continue from the last checkpoint with a visible warning. More tools with one-time Pro Back up the working copy, preview a row change and keep or discard it in the copy. Save queries for another database. Export without the free 1,000-row app cap. Available storage, your chosen provider and cancellation still limit exports. No subscription. Restore purchases is available in the app. Google Play supplies the current localized price. Your database stays yours No ads or mandatory account. Database files, queries and rows are not uploaded to the developer. Exports and backups go to the Android document-provider destination you choose. Purchases and restoration contact Google Play. Edits stay in the private copy. This version does not write changes back over the file you opened. No root or broad-storage access is required.