How to View a SQLite DB File (No Install Needed)

Someone sent you a .db file. Or you found one inside an app folder and you’re curious what’s in it. You don’t want to install software, learn SQL, or hand the file to a random website. You just want to look inside.

This guide shows you how to view a SQLite DB file in a few clicks, with nothing to install. You’ll also learn how to find the right table fast, read tricky columns like dates, and pull the data out when you’re done.

What you need

Only two things:

• The .db file itself (or .sqlite, .sqlite3, .db3)
• A modern web browser such as Chrome, Edge, Firefox or Safari

That’s the full list. You don’t need admin rights, a database server, or any coding skills.

Where .db files usually come from

It helps to know where your file came from, because that tells you what to expect inside. Here are the most common sources:

• Phone apps. Android and iPhone apps store notes, settings and messages in local databases.
• Web browsers. Chrome, Firefox and Safari keep history, bookmarks and cookies in SQLite files.
• Desktop software. Photo managers, study apps and media players often use SQLite for their libraries.
• Developer projects. Frameworks like Django create a db.sqlite3 file by default.
• Data exports. Some services send you a .db file instead of a spreadsheet.

Knowing the source helps you guess table names and date formats before you even open the file.

Step 1: Make a copy of the file

Before you open anything, copy the file to a safe spot like your Desktop. Work on the copy.

Why bother? Apps often keep their database open while they run. If you open the live file, you might get a “locked” error or see stale data. A copy avoids both problems. It also protects the original if you decide to experiment later.

If you see files next to the database with the same name plus -wal or -shm, close the app that owns them before you copy. Recent changes sometimes wait in the -wal file until the app writes them back.

Step 2: Open the file in the online viewer

1. Go to our free online SQLite viewer.
2. Click Choose file, or drag the .db file onto the drop zone.
3. Give it a second.

The viewer reads the file inside your browser. It doesn’t upload it. You’ll see the file name at the top, along with its size and how many tables it holds.

Can’t pick the file because it has no extension or an odd one? In the file dialog, switch the type filter to “All files” and select it anyway. The viewer checks the file’s contents, not its name.

Step 3: Look at the list of tables

The left sidebar lists every table and view. Next to each name is a row count. This is your map of the database.

A few tips for reading that list:

• Big row counts usually mean main data. A table with 50,000 rows is more interesting than one with 3.
• Names give strong hints. Tables called messages, users, orders or urls tell you what they hold.
• Ignore system tables. Names starting with sqlite_ or android_metadata are internal bookkeeping.
• Views are saved queries. They show combined data from other tables and can be handy shortcuts.

Want a deeper look at how to explore unfamiliar tables? Our guide on viewing the contents of a SQLite database goes further.

Step 4: Browse rows, sort and search

Click any table name. Its rows appear in a grid with 100 rows per page.

• Sort: click a column header. Click again to reverse the order.
• Search: type in the search box above the grid. The viewer checks every column in that table at once.
• Page through: use the arrows at the bottom to move between pages.
• See a full value: click any cell. Long text opens in a pop-up. JSON gets formatted so you can read it.

This is usually enough to find what you came for. Most people never need to write a single line of SQL.

Step 5: Check the table structure

Switch to the Structure tab to see how a table is built. You’ll find:

• Column names and their data types
• Which column is the primary key
• Foreign keys that link to other tables
• Indexes
• The original CREATE TABLE statement

This helps when two tables seem related. A foreign key tells you exactly how they connect. For more on this, read how to list all tables in SQLite, which also covers the schema commands.

Reading tricky columns

Some data looks strange at first. Here’s how to make sense of it.

Dates that look like huge numbers

SQLite has no special date type. Apps store dates in different ways:

You can convert Unix seconds with a quick query in the Run SQL tab:

SELECT datetime(created_at, 'unixepoch') FROM orders LIMIT 10;

For milliseconds, divide by 1000 first. Chrome’s format is different again, and our Chrome history guide shows the exact formula.

BLOB columns

A BLOB is raw binary data. It might be an image, a thumbnail, a file, or packed app data. The viewer labels these as BLOB and shows the size. Click one to see its bytes in hex.

NULL values

NULL means “no value.” It’s not the same as zero or an empty string. The viewer shows NULL in grey italics so you can spot it.

Step 6: Ask a specific question with SQL (optional)

If clicking around doesn’t answer your question, the Run SQL tab will. You don’t need to be an expert. These three patterns cover most needs:

SELECT * FROM contacts WHERE name LIKE '%smith%';

SELECT COUNT(*) FROM orders;

SELECT status, COUNT(*) FROM orders GROUP BY status;

The first finds rows containing a word. The second counts rows. The third counts rows per group. Press Ctrl and Enter (or Cmd and Enter on a Mac) to run.

Step 7: Export what you found

When you have the rows you need, get them out:

• Export CSV opens cleanly in Excel, Google Sheets or Numbers.
• Export JSON is handy for developers.
• Download .db saves a copy of the whole database, including any changes you made.

For a full walkthrough, see how to convert SQLite to CSV or how to open SQLite data in Excel.

Other ways to view a SQLite DB file

The browser method fits most people. Still, it’s good to know the alternatives.

DB Browser for SQLite

A free desktop app for Windows, Mac and Linux. It’s excellent for very large files and heavy editing. You’ll need to install it. Our DB Browser for SQLite online article explains when the browser approach is enough and when the desktop app is better.

The sqlite3 command line

On a Mac, it’s already installed. Open Terminal and type:

sqlite3 ~/Desktop/myfile.db
.tables
SELECT * FROM tablename LIMIT 5;

It’s powerful but less friendly for browsing. You see one query result at a time in plain text.

Other apps

SQLiteStudio, TablePlus and many IDEs can also open SQLite files. Our roundup of the best SQLite viewers compares them.

Troubleshooting

The viewer says the file is not a database

Every SQLite 3 file begins with the text “SQLite format 3.” If that header is missing, the file is encrypted, zipped, or not SQLite at all. See our fix guide for the file is not a database error.

Tables are there but empty

Check for a -wal file next to the database. If the app never wrote its changes back, the main file can look empty or out of date. Close the app completely, then copy both files again.

The page slows down

Very large files use a lot of memory. Close other tabs, or use a desktop app for files over a gigabyte. A few hundred megabytes is normally fine on a laptop.

Want the technical detail? See the official SQLite command-line shell documentation.

Frequently asked questions

Do I need to know SQL to view a .db file?

No. You can browse, sort, search and export without writing any SQL. The Run SQL tab is there if you want it.

Is my file uploaded when I use the viewer?

No. The file is read by your browser and stays on your device. Close the tab and it’s gone from memory.

Can I view a SQLite DB file on my phone?

Yes. Open the viewer in your phone’s browser, tap Choose file, and pick the database from your Files app. Our Android guide has the details.

Will viewing the file change it?

No. Browsing and searching never change your file. Even if you edit data with SQL, you’re changing an in-memory copy. You only get a new file if you choose to download it.

Summary

To view a SQLite DB file, copy it, drop it into our online SQLite viewer, and click through the tables. Sort and search to find rows, check the Structure tab to understand how tables connect, and export to CSV when you’re done. No install, no upload, and no SQL required.