Browse Every Table
See all tables in the database with row counts, and click to view the data.
SQLite Viewer
Open a SQLite database file in your browser, browse its tables, run SQL queries, and export the results. Free, no signup, nothing uploaded.
Guide
How to view a SQLite database
1
Open Your Database
Drag and drop a .sqlite or .db file or click to choose one. It opens right in your browser.
2
Browse and Query
Click a table to see its rows, or write your own SQL query and run it with the button or Ctrl plus Enter.
3
Export Results
Download the current table or query result as a CSV file.
Open a SQLite File Without Any Software
SQLite databases are everywhere, inside apps, browsers, phones, and exports. Opening one usually means installing a database tool just to peek at a few tables. This viewer skips that. Drop in a .sqlite or .db file and it opens right in the page.
You get the list of tables with their row counts on the left. Click one to see its rows, or write your own SQL in the query box and run it. Results come back in a clean, scrollable table, with NULL values marked clearly. When you find what you need, export the table or the query result to CSV.
The whole database is read on your own device, so nothing is uploaded. That makes it a quick, private way to inspect app data, debug, or pull a table out as CSV.
Benefits
Why Use Our SQLite Viewer?
Run SQL Queries
Write and run any read query, with Ctrl plus Enter to execute and clear error messages.
Export to CSV
Download the table you are viewing or your query result as a clean CSV file.
No Install
Open .sqlite, .db, and similar files instantly without any database software.
Fullscreen
Expand the table to fill the screen when you are working with wide data.
Runs in Your Browser
The database is read on your device. Nothing is uploaded, logged, or stored.
Explore More
Similar Tools
More Developer tools you might find useful.
FAQ
Frequently Asked Questions
Common questions about viewing SQLite files.
What files can I open?
SQLite database files, including .sqlite, .sqlite3, .db, .db3, and .s3db. They all open the same way.
Can I run my own SQL queries?
Yes. Write any SQL in the query box and run it with the button or Ctrl plus Enter. Errors are shown so you can fix the query.
Can I edit the data?
This is a viewer for browsing and querying. You can run queries against the loaded copy, but changes are not saved back to the original file.
Is there a size limit?
There is no fixed limit, but very large databases use more memory since the file is loaded fully in the browser. Big tables are shown up to a row limit.
Is my database uploaded anywhere?
No. The file is read and queried entirely in your browser. Nothing is uploaded, logged, or stored on a server.
Is this SQLite viewer free?
Yes, it is completely free with no signup and no limits. Everything runs on your device.