(Please consider sponsoring us on Patreon 😄)
Windows
Our latest release (3.13.1) for Windows:
- DB Browser for SQLite — Standard installer for 32-bit Windows
- DB Browser for SQLite — .zip (no installer) for 32-bit Windows
- DB Browser for SQLite — Standard installer for 64-bit Windows
- DB Browser for SQLite — .zip (no installer) for 64-bit Windows
Free code signing provided by SignPath.io, certificate by SignPath Foundation.
Windows PortableApp
Our latest release (3.13.1) for Windows:
- DB Browser for SQLite — PortableApp
Note — If for any reason the standard Windows release does not work
(e.g. gives an error), try a nightly build (below).
Nightly builds often fix bugs reported after the last release. 😄
macOS
Our latest release (3.13.1) for macOS:
- DB Browser for SQLite (Universal)
Homebrew
If you prefer using Homebrew for macOS, our latest release can be installed via:
brew install db-browser-for-sqlite
Nightly builds
Download nightly builds for Windows, macOS, and Linux are here:
- https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/nightly
Linux
Our latest release is available as an AppImage, Snap packages, and distribution specific packages:
AppImage
- DB.Browser.for.SQLite-v3.13.1-x86.64-v2.AppImage
Remember to change its permission bits to be executable before you run it. 😄
Snap packages
Snap Release build
snap install sqlitebrowser
Snap Nightly builds
snap install sqlitebrowser --devmode
Other distribution specific instructions:
Arch Linux
Arch Linux provides an up to date version
Install with the following command:
sudo pacman -S sqlitebrowser
Fedora
Install for Fedora (i386 and x86_64) by issuing the following command:
sudo dnf install sqlitebrowser
openSUSE
sudo zypper install sqlitebrowser
Debian
Note that Debian focuses more on stability rather than newest features. Therefore packages will typically contain some older version, compared to the latest release.
Update the cache using:
sudo apt-get update
Install the package using:
sudo apt-get install sqlitebrowser
Ubuntu and Derivatives
Stable release
For Ubuntu and derivatives, @deepsidhu1313
provides a PPA with the latest release here:
- https://launchpad.net/~linuxgndu/+archive/ubuntu/sqlitebrowser
To add this ppa just type in these commands in terminal:
sudo add-apt-repository -y ppa:linuxgndu/sqlitebrowser
Then update the cache using:
sudo apt-get update
Install the package using:
sudo apt-get install sqlitebrowser
Ubuntu 14.04.X, 15.04.X, 15.10.X and 16.04.X are supported for now (until
Launchpad decides to discontinue building for any series).
Ubuntu Precise (12.04) and Utopic (14.10) are not supported:
- Precise does not have a new enough Qt package in its repository by default,
which is a dependency - Launchpad does not support Utopic any more, which has reached its End of
Life
Nightly builds
Nightly builds are available here:
- https://launchpad.net/~linuxgndu/+archive/ubuntu/sqlitebrowser-testing
To add this ppa, type these commands into the terminal:
sudo add-apt-repository -y ppa:linuxgndu/sqlitebrowser-testing
Then update the cache using:
sudo apt-get update
Install the package using:
sudo apt-get install sqlitebrowser
Other Linux
On others, compile DB4S using the instructions
in BUILDING.md.
FreeBSD
DB Browser for SQLite works well on FreeBSD, and there is a port for it (thanks
to lbartoletti 😄). DB4S can be installed
using either this command:
make -C /usr/ports/databases/sqlitebrowser install
or this command:
pkg install sqlitebrowser
News
2017-09-28 — Added PortableApp version of 3.10.1. Thanks John. 
2017-09-20 — DB Browser for SQLite 3.10.1 has been released! 
2017-09-08 — Removed the continuous AppImage builds for Linux due to problems with the upload script.
Screenshot
What it is
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 records as text
- Import and export tables from/to CSV files
- Import and export databases from/to SQL dump files
- Issue SQL queries and inspect the results
- Examine a log of all SQL commands issued by the application
What it is not
This program is not a visual shell for the sqlite command line tool. It does not require familiarity with SQL commands. It is a tool to be used both by developers and by end users, and it must remain as simple to use as possible in order to achieve its goals.
Nightly builds
Nightly builds for Windows and OSX can be downloaded here:
- https://nightlies.sqlitebrowser.org/latest
Windows
Windows releases can be downloaded here:
- https://github.com/sqlitebrowser/sqlitebrowser/releases
Note — If for some reason the standard Windows release doesn’t work
for you (eg it gives an error), try a nightly build. They often fix bugs
reported after the last release.
MacOS X / macOS
DB Browser for SQLite works well on MacOS X / macOS.
- OSX 10.8 (Mountain Lion) — 10.13 (High Sierra) are tested and known to work
OSX releases can be downloaded here:
- https://github.com/sqlitebrowser/sqlitebrowser/releases
Or installed via Homebrew Cask:
brew cask install db-browser-for-sqlite
Linux
DB Browser for SQLite works well on Linux.
Arch Linux
Arch Linux provides a package through pacman.
Fedora
For Fedora (i386 and x86_64) you can install by issuing:
$ sudo dnf install sqlitebrowser
Debian
Note that Debian focuses more on stability rather than newest features. Therefore packages will typically contain some older (but well tested) version, compared to the latest release.
Update the cache using:
sudo apt-get update
Install the package using:
sudo apt-get install sqlitebrowser
Ubuntu and Derivatives
Stable release
For Ubuntu and derivaties, @deepsidhu1313
provides a PPA with our latest release here:
- https://launchpad.net/~linuxgndu/+archive/ubuntu/sqlitebrowser
To add this ppa just type in these commands in terminal:
sudo add-apt-repository -y ppa:linuxgndu/sqlitebrowser
Then update the cache using:
sudo apt-get update
Install the package using:
sudo apt-get install sqlitebrowser
Ubuntu 14.04.X, 15.04.X, 15.10.X and 16.04.X are supported for now (until
Launchpad decides to discontinue building for any series).
Ubuntu Precise (12.04) and Utopic (14.10) are not supported:
- Precise doesn’t have a new enough Qt package in its repository by default,
which is a dependency - Launchpad doesn’t support Utopic any more, as that has reached its End of
Life
Nightly builds
Nightly builds are available here:
- https://launchpad.net/~linuxgndu/+archive/ubuntu/sqlitebrowser-testing
To add this ppa just type in these commands in terminal:
sudo add-apt-repository -y ppa:linuxgndu/sqlitebrowser-testing
Then update the cache using:
sudo apt-get update
Install the package using:
sudo apt-get install sqlitebrowser
Other Linux
On others you’ll need to compile it yourself using the (simple) instructions
in BUILDING.md.
FreeBSD
DB Browser for SQLite works well on FreeBSD, and there is a port for it (thanks to lbartoletti).
It can be installed using either this:
# make -C /usr/ports/databases/sqlitebrowser install
or this:
# pkg install sqlitebrowser
Developer mailing list
For development related discussion about DB4S and DBHub.io:
- https://lists.sqlitebrowser.org/mailman/listinfo/db4s-dev
Follow us on Twitter: https://twitter.com/sqlitebrowser
Website
- http://sqlitebrowser.org
Old project pages
- http://sqlitebrowser.sourceforge.net
- https://sourceforge.net/projects/sqlitebrowser
Releases
- Version 3.10.1 released — 2017-09-20
- Version 3.10.0 released — 2017-08-20
- Version 3.9.1 released — 2016-10-03
- Version 3.9.0 released — 2016-08-24
- Version 3.8.0 released — 2015-12-25
- Version 3.7.0 released — 2015-06-14
- Version 3.6.0 released — 2015-04-27
- Version 3.5.1 released — 2015-02-08
- Version 3.5.0 released — 2015-01-31
- Version 3.4.0 released — 2014-10-29
- Version 3.3.1 released — 2014-08-31 — Project renamed from «SQLite Database Browser»
- Version 3.3.0 released — 2014-08-24
- Version 3.2.0 released — 2014-07-06
- Version 3.1.0 released — 2014-05-17
- Version 3.0.3 released — 2014-04-28
- Version 3.0.2 released — 2014-02-12
- Version 3.0.1 released — 2013-12-02
- Version 3.0 released — 2013-09-15
- Version 3.0rc1 released — 2013-09-09 — Project now on GitHub
- Version 2.0b1 released — 2009-12-10 — Based on Qt4.6
- Version 1.2 released — 2005-04-05
- Version 1.1 released — 2004-07-20
- Version 1.01 released — 2003-10-02
- Version 1.0 released to public domain — 2003-08-19
History
This program was developed originally by Mauricio Piacentini (@piacentini) from Tabuleiro Producoes, as the Arca Database Browser. The original version was used as a free companion tool to the Arca Database Xtra, a commercial product that embeds SQLite databases with some additional extensions to handle compressed and binary data.
The original code was trimmed and adjusted to be compatible with standard SQLite 2.x databases. The resulting program was renamed SQLite Database Browser, and released into the Public Domain by Mauricio. Icons were contributed by Raquel Ravanini, also from Tabuleiro. Jens Miltner (@jmiltner) contributed the code to support SQLite 3.x databases for the 1.2 release.
Pete Morgan (@daffodil) created an initial project on GitHub with the code in 2012, where several contributors fixed and improved pieces over the years. René Peinthor (@rp-) and Martin Kleusberg (@MKleusberg) then became involved, and have been the main driving force from that point. Justin Clift (@justinclift) helps out with testing on OSX, and started the new github.com/sqlitebrowser organisation on GitHub.
John T. Haller, of PortableApps.com fame, created the new logo. He based it on the Tango icon set (public domain).
In August 2014, the project was renamed to «Database Browser for SQLite» at the request of Richard Hipp (creator of SQLite), as the previous name was creating unintended support issues.
In September 2014, the project was renamed to «DB Browser for SQLite», to avoid confusion with an existing application called «Database Browser».
License
DB Browser for SQLite is bi-licensed under the Mozilla Public License
Version 2, as well as the GNU General Public License Version 3 or later.
You can modify or redistribute it under the conditions of these
licenses.
DB Browser for SQLite
Table of Contents
- DB Browser for SQLite
- Table of Contents
- What it is
- What it is not
- Wiki
- Continuous, Nightly builds
- Windows
- Continuous, Nightly builds
- macOS
- Stable release
- Continuous, Nightly builds
- Linux
- Arch Linux
- Debian
- Fedora
- openSUSE
- Ubuntu and Derivatives
- Stable release
- Nightly builds
- Other Linux
- FreeBSD
- Snap packages
- Snap Nightlies
- Snap Stable
- Nix Packages
- Flox
- Compiling
- X (Known as Twitter)
- Website
- Old project page
- Releases
- History
- Contributors
- License
What it is
DB Browser for SQLite (DB4S) is a high quality, visual, open source tool to
create, design, and edit database files compatible with SQLite.
DB4S is for users and developers who want to create, search, and edit
databases. DB4S uses a familiar spreadsheet-like interface, so complicated SQL commands do not have to be learned.
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 records as text
- Import and export tables from/to CSV files
- Import and export databases from/to SQL dump files
- Issue SQL queries and inspect the results
- Examine a log of all SQL commands issued by the application
- Plot simple graphs based on table or query data
What it is not
Even though DB4S comes with a spreadsheet-like interface, it is not meant to replace your spreadsheet application.
We implement a few convenience functions which go beyond a simple database frontend but do not add them when they
do not make sense in a database context or are so complex to implement that they will only ever be a poor
replacement for your favorite spreadsheet application. We are a small team with limited time after all. Thanks
for your understanding
Wiki
For user and developer documentation, check out our Wiki at:
https://github.com/sqlitebrowser/sqlitebrowser/wiki.
Continuous, Nightly builds
Download continuous builds for AppImage, macOS and Windows here:
- https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/continuous
Note: A continuous build is generated when a new commit is added to the
masterbranch.
Download nightly builds for Windows and macOS here:
- https://nightlies.sqlitebrowser.org/latest
Windows
Download Windows releases here:
- https://sqlitebrowser.org/dl/#windows
Or use Chocolatey:
choco install sqlitebrowser
Or use winget:
winget install -e --id DBBrowserForSQLite.DBBrowserForSQLite
Or use scoop:
scoop install sqlitebrowser
Continuous, Nightly builds
Continuous builds are available here:
- https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/continuous
Nightly builds are available here:
- https://nightlies.sqlitebrowser.org/latest
macOS
DB Browser for SQLite works well on macOS.
- macOS 10.15 (Catalina) — 14.0 (Sonoma) are tested and known to work.
Stable release
Download macOS releases here:
- https://sqlitebrowser.org/dl/#macos
The latest macOS binary can be installed via Homebrew Cask:
brew install --cask db-browser-for-sqlite
Continuous, Nightly builds
Continuous builds are available here:
- https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/continuous
Nightly builds are available here:
- https://nightlies.sqlitebrowser.org/latest
and also you can be installed via Homebrew Cask:
brew tap homebrew/cask-versions
# for the version without SQLCipher support
brew install --cask db-browser-for-sqlite-nightly
# for the version with SQLCipher support
brew install --cask db-browser-for-sqlcipher-nightly
It also has its own Homebrew tap the include Cask for older version.
For more information, see the following: https://github.com/sqlitebrowser/homebrew-tap
Linux
DB Browser for SQLite works well on Linux.
Arch Linux
Arch Linux provides an up to date version
Install with the following command:
sudo pacman -S sqlitebrowser
Debian
Debian focuses more on stability rather than newest features.
Therefore packages will typically contain an older (but well tested) version, compared to the latest release.
Update the cache using:
Install the package using:
sudo apt-get install sqlitebrowser
Fedora
Install for Fedora (i386 and x86_64) by issuing the following command:
sudo dnf install sqlitebrowser
openSUSE
sudo zypper install sqlitebrowser
Ubuntu and Derivatives
Stable release
For Ubuntu and derivatives, @deepsidhu1313
provides a PPA with the latest release here:
- https://launchpad.net/~linuxgndu/+archive/ubuntu/sqlitebrowser
To add this PPA just type in this command in terminal:
sudo add-apt-repository -y ppa:linuxgndu/sqlitebrowser
Then update the cache using:
Install the package using:
sudo apt-get install sqlitebrowser
Packages for Older Ubuntu releases are supported while launchpad keeps building those or if Older Ubuntu release has dependency packages that are required to build the latest version of Sqlitebrowser. We don’t remove builds from our ppa repos, so users can still install older version of sqlitebrowser if they like. Alternatively Linux users can also switch to Snap packages if Snap packages are supported by the distro they are using.
Nightly builds
Nightly builds are available here:
- https://launchpad.net/~linuxgndu/+archive/ubuntu/sqlitebrowser-testing
To add this PPA, type these commands into the terminal:
sudo add-apt-repository -y ppa:linuxgndu/sqlitebrowser-testing
Then update the cache using:
Install the package using:
sudo apt-get install sqlitebrowser
Other Linux
On others, compile DB4S using the instructions in BUILDING.md.
FreeBSD
DB Browser for SQLite works well on FreeBSD, and there is a port for it (thanks
to lbartoletti 😄).
DB4S can be installed
using either this command:
make -C /usr/ports/databases/sqlitebrowser install
or this command:
pkg install sqlitebrowser
Snap packages
Snap Nightlies
snap install sqlitebrowser --edge
Snap Stable
snap install sqlitebrowser
Nix Packages
sqlitebrowser is packaged and available in nixpkgs.
It can be used with the experimental flakes and nix-command features with:
nix profile install nixpkgs#sqlitebrowser
Or with the nix-env or nix-shell commands:
nix-shell -p sqlitebrowser
Flox
sqlitebrowser can be installed into a Flox environment with.
flox install sqlitebrowser
Compiling
Instructions for compiling on Windows, macOS, Linux, and FreeBSD are
in BUILDING.
X (Known as Twitter)
Follow us on X: https://x.com/sqlitebrowser
Website
- https://sqlitebrowser.org
Old project page
- https://sourceforge.net/projects/sqlitebrowser
Releases
- Version 3.13.1 released — 2024-10-16
- Version 3.13.0 released — 2024-07-23
- Version 3.12.2 released — 2021-05-18
- Version 3.12.1 released — 2020-11-09
- Version 3.12.0 released — 2020-06-16
- Version 3.11.2 released — 2019-04-03
- Version 3.11.1 released — 2019-02-18
- Version 3.11.0 released — 2019-02-07
- Version 3.10.1 released — 2017-09-20
- Version 3.10.0 released — 2017-08-20
- Version 3.9.1 released — 2016-10-03
- Version 3.9.0 released — 2016-08-24
- Version 3.8.0 released — 2015-12-25
- Version 3.7.0 released — 2015-06-14
- Version 3.6.0 released — 2015-04-27
- Version 3.5.1 released — 2015-02-08
- Version 3.5.0 released — 2015-01-31
- Version 3.4.0 released — 2014-10-29
- Version 3.3.1 released — 2014-08-31 — Project renamed from «SQLite Database Browser»
- Version 3.3.0 released — 2014-08-24
- Version 3.2.0 released — 2014-07-06
- Version 3.1.0 released — 2014-05-17
- Version 3.0.3 released — 2014-04-28
- Version 3.0.2 released — 2014-02-12
- Version 3.0.1 released — 2013-12-02
- Version 3.0 released — 2013-09-15
- Version 3.0rc1 released — 2013-09-09 — Project now on GitHub
- Version 2.0b1 released — 2009-12-10 — Based on Qt4.6
- Version 1.2 released — 2005-04-05
- Version 1.1 released — 2004-07-20
- Version 1.01 released — 2003-10-02
- Version 1.0 released to public domain — 2003-08-19
History
This program was developed originally by Mauricio Piacentini
(@piacentini) from Tabuleiro Producoes as
the Arca Database Browser. The original version was used as a free companion
tool to the Arca Database Xtra, a commercial product that embeds SQLite
databases with some additional extensions to handle compressed and binary data.
The original code was trimmed and adjusted to be compatible with standard
SQLite 2.x databases. The resulting program was renamed SQLite Database
Browser, and released into the Public Domain by Mauricio. Icons were
contributed by Raquel Ravanini, also from
Tabuleiro. Jens Miltner (@jmiltner) contributed
the code to support SQLite 3.x databases for the 1.2 release.
Pete Morgan (@daffodil) created an initial
project on GitHub with the code in 2012, where several contributors fixed and
improved pieces over the years. René Peinthor (@rp-)
and Martin Kleusberg (@MKleusberg) then
became involved, and have been the main driving force from that point. Justin
Clift (@justinclift) helps out with testing
on OSX, and started the new github.com/sqlitebrowser organisation on GitHub.
John T. Haller, of
PortableApps.com fame, created the new logo. He
based it on the Tango icon set (public domain).
In August 2014, the project was renamed to «Database Browser for SQLite» at
the request of Richard Hipp (creator of
SQLite), as the previous name was creating unintended
support issues.
In September 2014, the project was renamed to «DB Browser for SQLite», to
avoid confusion with an existing application called «Database Browser».
Contributors
View the list by going to the Contributors tab.
License
See the LICENSE file for licensing information.
- Step 1: Firstly, Download and Run SQLite DB Browser Tool.
- Step 2: Click on Add File to browse SQLite database File .
- Step 3: Select on Tabular to Open and View SQLite Tables Data.
- Step 4: Option to Open Deleted Records SQLite File items Easily
Follow below-mentioned instructions to read SQLite database file with help of this Free Utility :
Yes, you can browse multiple SQLite DB files in the individual panel of the SQLite reader. This will enable you to easily draw a comparison between several processed files.
No, There is no SQLite database file size restriction imposed by SQLite Reader while browsing. No matter whether the size is in GB or TB, the tool will support file of any size without any interruption.
Yes, the software is programmed with scanning algorithms, which removes corruption from the file. This means that you can even browse a corrupted SQLite file in our software and there is no additional cost for this kind of working in the tool.
Yes, the free SQLite DB Browser is a Windows-based product that is workable upon all version of it. This means that you can run this free SQLite file viewer on Windows 10, 8.1, 8, and all the below versions.
No, the tool is a standalone utility that does not require any supportive application to work with it. It is capable enough to independently open and read SQLite database files.
Yes, The SQLite File Viewer tool provides 4 different categories for SQLite file data, namely deleted, active, unrelated, and protected. SQLite data can be easily organized using one of these categories.
Here is a list of best free SQLite file viewer software for Windows. An SQLite file carries a database and all its data such as tables, database objects, values, IDs, and more. This file is mainly created by SQLite-based software to store data used by specific applications. To view all the data present in an SQLite file, users need SQLite file viewer software. In these software, users can load one SQLite file at a time and view all their database objects. Some viewers also show the total number of records present in each database object. After selecting a database object, users can view all its records in the form of an organized table. Each table carries multiple headings on the top. Just below each heading, users can view their values. Besides this, some software also allows users to view a hexadecimal view of the existing data, foreign keys, indices, etc.
Through some of these SQLite viewers, users can also edit the tables and values of an SQLite file. To do that, users just need to select and replace an existing table value. After editing, users can save it in CSV, XML, SQL, etc., formats. Some software also come with additional tools like file integrity check, foreign key check, export tools, SQL Log, and more. Go through the list to know more about these software.
My Favorite SQLite File Viewer Software For Windows:
SQLite Studio is my favorite viewer because it offers all the essential SQLite file viewing tools. Plus, it also allows users to edit data and retrieve desired data using custom SQL queries.
You can also check out lists of best free Database Schema Designer, CALS Viewer, and Open Source XML Viewer software for Windows.
SQLite Studio
SQLite Studio is a free open source SQLite file viewer software for Windows, Linux, BSD, macOS, and Solaris. In this software, users can view all the database objects along with all the tables present on them. Plus, it also lets users edit the data of tables, unlike most other similar software. Various fields to show different types of SQLite data are also present in it. Now, check out the main features of this viewer.
Main Features:
- Database Browser: It shows all the database objects along with their schema and type present in an SQLite file.
- Browse Data: It allows users to select a table from various available ones to view all the data and records present in it.
- SQL Log: Use it to view all the SQL queries submitted by both users and applications.
- Export: Through this software, users can also export SQLite file data in CSV and SQL file format.
Additional Features:
- Table Editing Tools: Using table editing tools, users can add a new row, delete existing rows, enter new values of a table, delete records, and more.
- Execute SQL: In this area, users can write and execute custom SQL queries to retrieve desired data from an SQLite file.
Final Thoughts:
It is one of the best free SQLite file viewer software in which users can view all the SQLite data, execute SQL queries, and edit records & tables with ease.
SysInfo Tools SQLite File Viewer
SysInfo Tools SQLite File Viewer is a free SQLite file viewer software for Windows. In this software, users can load and view one SQLite file at a time. As soon as they load an SQLite file, users can view all the table structure on the left side of its interface. By selecting elements of a table, users can view all the data present in it. Now, check out the main features of this software.
Main Features:
- SQLite Database Objects: In this section, users can view a list of all the database objects present in an SQLite file.
- Objects Data Viewer: By selecting an object, users can view all its data on the right side of the interface.
- Output: It shows all the Table and Index headings present on all the Database Objects.
Limitations:
- In the free version of this software, users cannot preview corrupt SQLite DB files and nor export or save any data. To remove all the limitations, users need to upgrade to its premium version.
Final Thoughts:
It is another good SQLite file viewer software that offers all the essential tools to view SQLite file data.
Sqliteman
Sqliteman is another free open source SQLite file viewer software for Windows, macOS, BSD, and Linux. It is another standard SQLite viewer in which users can load and view the data of one SQLite file at a time. Plus, an SQL editor to write and run custom SQL commands is also provided by this viewer. Now, check its main features.
Main Features:
- Schema: In this section, users can view the names of all the database objects along with the number of records they got.
- Full View: It shows all the records and items present in a database object.
- Item View: Use it to view all the items of individual rows of a record.
- Pragmas: Using it, users can view and edit the operation of an SQLite library.
Additional Features:
- SQL Editor: Use it to edit or add new SQL code to change the behavior of SQLite file data.
- Export Data: Through this feature, users can export the data in CSV, HTML, XLS, etc., file formats.
Final Thoughts:
It is another simple to use SQLite file viewer software that offers all the necessary tools to view SQLite file data.
SQLite Forensic Explorer
SQLite Forensic Explorer is another free SQLite file viewer software for Windows. In this software, users can easily view all the database objects along with data and values present in each element of the database object. Besides this, a hexadecimal view of database objects can also be viewed in this viewer. Now, check out the primary features of this viewer.
Main Features:
- Database Objects: On the upper left panel of this software, users can scan and view all the database objects present in an SQLite file.
- Tabular: After selecting a database object, users can view all its data and values in the tabular tab of this software.
- Table Properties: Use it to view table properties such as table name, constraints, primary key, table syntax, etc.
Additional Feature:
- SQL Editor: It is an advanced tool through which users can enter and execute custom queries over the input data.
Limitation:
- The free version of this software doesn’t allow users to export SQLite file values. To remove this limitation, users need to purchase its premium version.
Final Thoughts:
It is another good SQLite file viewer software in which users can view all the SQLite file data in a structured format.
SQLite Viewer
SQLite Viewer is a free open source SQLite file viewer software for Windows. It is mainly web-based software that needs a web browser to run. In this software, users can drag and drop an SQLite file to view all its data. Plus, users can also execute SQL queries in this software to search for specific data or values present in the file. Now, take a look at the primary features of this software.
Main Features:
- Database Objects Menu: In this menu, users can view the names of all the database objects present in an SQLite file.
- Main Data: After selecting a database object users can view all the data rows present in it along with all the values.
Additional feature:
- Execute Queries: In this software, users can enter custom SQL queries and execute them to search specific sets of data.
Final Thoughts:
It is a simple and lightweight SQLite viewer software in which users can easily view all the data of a SQLite file.
SQLite Query
SQLite Query is another free SQLite file viewer software for Windows. In this software, users cannot only view database objects, tables, and values, but also view Foreign keys, Indices, and Triggers. An inbuilt SQL editor to edit SQL scripts are also present in it. Let’s take a look at the primary features of this software.
Main Features:
- Object Explorer: In this section, users can view a list of all the database objects along with the number of records they store.
- Data: By selecting an object, users can view all the records present in it.
- Foreign Keys, Indices, and Triggers: Unlike other similar viewers, this one also shows foreign keys, indices, and triggers present in an SQLite file.
Additional Features:
- SQL Editor: As its name suggests, it is used to edit the SQL code or add new code to edit the behavior of the record.
- Repair Database: Use it to repair corrupt database files.
- Integrity Check: It helps users check the integrity of an SQLite file.
Final Thoughts:
It is another capable SQLite file viewer software that also shows foreign keys, indices, and triggers.
DB Browser for SQLite
DB Browser for SQLite is yet another free open source SQLite file viewer software for Windows, macOS, and Linux. It is a beautifully designed SQLite file viewer in which users can easily view all the database objects, records, and values. Plus, it also lets users edit the data of an SQLite file. Now, check out the main features of this software.
Main Features:
- Database Structure: It shows the names of all the primary database structures that carry various records.
- Browse Data: After selecting a database structure, users can view all its record by going to this section. It also lets users manually select and edit all the data manually.
- View: It helps users enable and disable various viewing features like Plot, DB Schema, DB Toolbar, Project Toolbar, and more.
Additional Features:
- Foreign Key Check: It is a handy tool through which users can quickly check whether their SQLite file carries a foreign key or not.
- Edit Tools: Using these tools, users can create, modify, and delete tables.
- Export: After viewing and editing an SQLite file, users can export it in SQL, CSV, and JSON file formats.
Final Thoughts:
It is a feature-rich SQLite file viewer software that offers all the essential SQLite file viewing and editing tools.
SQLiteExplorer
SQLiteExplorer is the next free open source SQLite file explorer software for Windows. It is a simple viewer in which users can view database objects, table names, and table data. Besides this, it doesn’t offer any other feature. Let’s take a look at the main features of this software.
Main Features:
- Open Database: Use it to browse and load an SQLite file into this viewer.
- Table Name: Using it users can switch between multiple tables and database objects present in this software.
- Data Viewer: By selecting a specific table, users can view all the data present in it.
Limitation:
- In my testing, this software sometimes failed to launch due to an unhandled exception error.
Final Thoughts:
It is another straightforward SQLite viewer software in which users can view all the SQLite file data.
SysTools SQLite Viewer
SysTools SQLite Viewer is another free SQLite file viewer software for Windows. In this software, users can load one SQLite file at a time. After loading an SQLite file, users can view all the database objects on the left panel of this software. Just below it, users can view various database properties. Now, check out the main features of this viewer
Main Features:
- SQLite Database Objects: It shows the names of all the database objects present in the loaded SQLite file.
- Database Properties: Use it to view database properties like database size, file change counter, number of pages, number of tables, and more.
- Objects Data Viewer: By selecting a database object, users can view all its data in the form of a table.
- Hex: It shows the hexadecimal view of the data of the database object.
Limitations:
- This software lacks export, data type mapping, scan database file, etc., features. To get all the features, users need to upgrade to its premium version.
Final Thoughts:
It is another good SQLite file viewer software that comes with various features to view multiple aspects of an SQLite file.