Open SQLite File Online: Free SQLite Viewer

How to open a SQLite file in 3 steps

You don't need to know SQL, and you don't need to install anything. If you can open a web page, you can open a SQLite file.

1. 1

   Pick your file

   Click Choose file or drag your database onto the purple box at the top of this page. Most SQLite files end in .db, .sqlite, .sqlite3 or .db3, but some have no extension at all.

2. 2

   Browse the tables

   Every table and view shows up on the left with its row count. Click one to see its rows. Sort any column with a click, or type in the search box to filter the rows.

3. 3

   Query or export

   Open the Run SQL tab if you want to ask a specific question. When you find what you need, export it as CSV for Excel or Google Sheets, or as JSON for code.

That's it. The file opens straight from your disk into the browser tab. When you close the tab, it's gone. Nothing is stored on our server because nothing was ever sent to it.

No file handy? Hit Try a sample database in the viewer. It loads a small shop database with customers, products and orders so you can click around first.

What is a SQLite file?

A SQLite file is a complete database packed into one ordinary file. There's no database server behind it. The tables, rows, indexes and settings all live inside that single file, which is why apps love it. Your phone, your web browser and many desktop programs keep their data this way.

Because it's a binary format, double-clicking a SQLite file usually doesn't help. Notepad shows gibberish, and Windows asks which app to use. To read a SQLite file properly, you need a SQLite file opener: a program that understands the format and turns it back into readable tables. That's what the viewer on this page does.

Why do so many apps use SQLite in the first place? It's tiny, it's free, it needs no setup, and it's extremely reliable. An app can save thousands of records into one file and read them back in milliseconds. It's also why the same file works on Windows, Mac, Linux, Android and iPhone without any conversion. Copy the file to another device and it opens exactly the same.

One quick way to confirm you have a real SQLite database: every SQLite 3 file starts with the text SQLite format 3 in its first bytes. The viewer checks this for you. If the check fails, it tells you the file is probably encrypted, compressed, or a different format.

SQLite file extensions you can open

Tip: if your file picker hides a file with an odd extension, switch the file type filter to "All files" and select it anyway.

How to view a SQLite database on Windows, Mac, Linux or your phone

The fastest way to view a SQLite database online is the same on every device: open this page and drop the file in. But if you'd like to know the other ways, here they are.

Using the sqlite3 command line (for the curious)

If you like the terminal, these five commands cover most of what you need to read a SQLite file:

sqlite3 mydata.db          # open the file
.tables                    # list all tables
.schema customers          # show how a table is built
.headers on
.mode column
SELECT * FROM customers LIMIT 10;
.quit

It works, but you're reading data in a terminal window, one query at a time. The online viewer shows the same information as sortable tables you can click through, which is easier for most people.

Simple SQL queries to read your data

You never have to write SQL to use the viewer. But a few short queries can answer questions that clicking around can't. Paste any of these into the Run SQL tab and swap in your own table names.

SELECT name FROM sqlite_master
WHERE type = 'table';

SELECT * FROM orders
LIMIT 20;

SELECT * FROM messages
WHERE text LIKE '%invoice%';

SELECT country, COUNT(*) AS customers
FROM customers
GROUP BY country
ORDER BY customers DESC;

Press Ctrl + Enter (or ⌘ + Enter on a Mac) to run a query. If you get something wrong, the error shows up in red. Nothing breaks and you can try again. Once the result looks right, click Export CSV to take it into a spreadsheet.