SQLite Editor Master

Amos Mobile

About this app

Sqlite Master is the ultimate Sqlite database editor for users on Android. Using Sqlite Master you can do almost anything in a Sqlite database. Functionality includes table data browser/editor/modification, query editor, table export, CSV import and lot more and root access

Compare to other available SQLite apps, this is most light weight, compact and user friendly with most features and fastest SQLite Manager and Editor.

Why do you to want use SQLite Master

[✔] Fastest and optimized, support large SQLite databases
[✔] Easy and simple user interface
[✔] Very small footprint (installer size is 470 KB, it takes few seconds to install)
[✔] Have almost everything that android users need

The major functionality includes

[✔] Create/drop Sqlite databases
[✔] Create/drop/modify Sqlite tables
[✔] View/filter table data
[✔] Sort table data by simply tapping on the column headers (first tap - ascending, second tap - descending)
[✔] Add, delete, update table row
[✔] Copy table row to clipboard by double tapping on a row
[✔] Pre-generated SQL Select Queries for existing tables.
[✔] View/Copy table definition, triggers, views in the database.
[✔] Clone table data, clone table schema etc
[✔] Alter table schema etc
[✔] In table list page, long press has many options such as clone schema, clone data, drop/rename table etc.
[✔] History of recently opened SQLite databases.
[✔] Query Maker to build custom queries and save queries, easy to use interface
[✔] (Pro only) Export table data to CSV
[✔] (Pro only) Schedule an Export to run every night
[✔] (Pro only) Import highly configurable CSV data into Table
[✔] Delete saved queries which are not needed.
[✔] Import existing queries.
[✔] Hot System Apps - Rooted System Fix Wi-Fi tethering, Phone settings, contacts, system settings, configure app databases etc. It requires busybox installed on your android device.
[✔] Rooted System browse system files in rooted system and configure. It requires busybox installed on your android device.
[✔] (Pro only) Scheduler for data export (Schedule onetime/daily) to export results of a query into a file.

Ratings and reviews

Looks comprehensive, but unintuitive and difficult to use SQL editor that often ends up loosing code! For example, tapping the create table button wipes the existing query rather than appending where the cursor is like other buttons do. Also edit window even on a large phone screen is too small once keyboard is show, and font to large. Font size change in preferences doesn't appear to make a difference to that section. All in all frustrating to use.

I use this application for development and it is excellent. I use it with a Galaxy 9 and a Galaxy 7 edge. My phone is not rooted, I can see all files and folders, and it is easy to use. I am not sure why some of the reviews say otherwise, but this is a great tool for seeing and editing (even deleting) Sqlite db/tables .

Roughly only handling 2mb txt file. I need something that can open up to 10mb 😂 Edit: try to edit my .db file, simply by change it to .txt file which contains of 40-50k line. The size data is 15mb. I'd give it try to open the file using this app but it crash after more than a minutes of black screen. 2nd try indeed success to open it but only some data that readable because it's end i mean cut-on the 10k' line. so i assuming this app can't handle large file. Give 3⭐️ for responding the review.