How to open .SQLite files

SQLite is database engine, .sqlite or .db should be a database. If you don't need to program anything, you can use a GUI like sqlitebrowser or anything like that to view the database contents.

  • Website: http://sqlitebrowser.org/
  • Project: https://github.com/sqlitebrowser/sqlitebrowser

There is also spatialite, https://www.gaia-gis.it/fossil/spatialite_gui/index


If you just want to see what's in the database without installing anything extra, you might already have SQLite CLI on your system. To check, open a command prompt and try:

sqlite3 database.sqlite

Replace database.sqlite with your database file. Then, if the database is small enough, you can view the entire contents with:

sqlite> .dump

Or you can list the tables:

sqlite> .tables

Regular SQL works here as well:

sqlite> select * from some_table;

Replace some_table as appropriate.


My favorite:

https://inloop.github.io/sqlite-viewer/

No installation needed. Just drop the file.