View your SQLite database files in SQLite Database Browser or SQLiteStudio

1. Run your APP. If it is executed successfully then

2.  Go to: Tools >> Android >> Android Device Monitor, you will have another window with some tabs in the header part.

3. Select “file explorer” tab. There will be a list of directories and files.

4. Search for “data” directory and expand it.

5. Again, there will be “data” directory and expand it. There will be the number of packages, search for your application and expand it.

6. There will be databases directory containing two files:

your_database
your_database-journal

7. Now, time to finish the task: select “your_database” file.

8. There are two  arrows with pink color in the menu on R.H.S.

9. Select pull a file from the device and save in your system.

DB Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.

It is for users and developers wanting to create databases, search, and edit data. It uses a familiar spreadsheet-like interface, and you don’t need to learn complicated SQL commands.

Controls and wizards are available for users to:

>Create and compact database files
>Create, define, modify and delete tables
>Create, define and delete indexes
>Browse, edit, add and delete records
>Search records
>Import and export record as text
>Import and export tables from/to CSV files
>Import and export databases from/to SQL dump files
>Issue SQL queries and inspects the results
>Examine a log of all SQL commands issued by the application

>Portable – no need to install or uninstall. Just download, unpack and run.
>Intuitive interface,
>Powerful, yet light and fast,
>All SQLite3 and SQLite2 features wrapped within simple GUI,
>Cross-platform – runs on Windows 9x/2k/XP/2003/Vista/7, Linux, MacOS X and should work on other Unixes (not tested yet).
>Exporting to various formats (SQL statements, CSV, HTML, XML, PDF, JSON),
>Importing data from various formats (CSV, custom text files [regular expressions]),
>Configurable colors, fonts and shortcuts.

1.  Open your SQLite Database Browser or SQLiteStudio.

2. Open your database file and view do modifications.

3. Now if you want to add modified file back  to your  device. Do the same as you did for pulling the file from the device.

In step 9, you will have to select  “push a file onto the device”  and add modified database from your system.