About

OpenSQLite is a free SQLite viewer that runs entirely in your browser. Open a .db, .sqliteor .sqlite3 file and browse its tables and views: sort by any column, search the rows, page through large tables and open any row to see every field in full. It works on phones too.

Why it exists

SQLite files are everywhere: app data, browser history, exported datasets, coursework, the database behind a side project. Sometimes you just want to look inside one without installing anything. Many online viewers do that by uploading your file to their server, and database files often hold exactly the kind of data you shouldn't hand to a stranger: customer records, messages, logs.

OpenSQLite never needs to see your file, so it never does.

How it works

  • SQLite itself, compiled to WebAssembly by the sql.js project, runs in a background worker inside your browser tab.
  • Your browser reads the file from your device into memory and SQLite opens it read-only.
  • The viewer runs on its own origin, separate from the rest of the site, with no ads, analytics or third-party scripts, and it isn't allowed to connect anywhere except its own origin.
  • After the page has loaded, you can go offline and the viewer keeps working.

The privacy page explains the details and shows how to check them in your browser's developer tools.

What it doesn't do

OpenSQLite is a viewer: it never changes your file. There's no signup and no install, and nothing to pay. The size of file you can open depends on your device's memory: a few hundred megabytes opens comfortably on most laptops. Encrypted databases (such as SQLCipher files) can't be opened without their key, and the viewer will tell you when a file looks encrypted.

Who makes it

OpenSQLite is built and run by Romesh Kosme, an independent developer based in India. Bug reports, questions and suggestions are welcome at hello@opensqlite.com.

Credits

OpenSQLite is an independent tool and is not affiliated with or endorsed by the SQLite project.