How to View SQLite Databases Online
- Drop your file — Drag and drop a
.db, .sqlite, .sqlite3, or .db3 file into the upload area, or click to browse.
- Browse tables — The sidebar shows all tables in your database. Click any table to preview its contents.
- Run SQL queries — Use the built-in SQL editor to write and run custom
SELECT queries. Results appear instantly.
- Export results — Click "Export CSV" to download any query result as a CSV file for use in spreadsheets or other tools.
Features
- Instant Table Browsing — Click any table name to view its first 1,000 rows with column types and row counts.
- SQL Query Editor — Full SQL support via sql.js (SQLite compiled to WebAssembly). Run any
SELECT, PRAGMA, or read-only query.
- CSV Export — Export query results to CSV with proper quoting and escaping. Ready for Excel, Google Sheets, or other tools.
- Large File Support — Handles databases up to 100MB+ depending on your device. Tables display up to 1,000 rows per query.
- 100% Client-Side — Powered by sql.js (SQLite in WebAssembly). Your database is never uploaded anywhere.
What is SQLite?
SQLite is the world's most widely deployed database engine. It's used by every smartphone, most web browsers, and countless applications. Unlike traditional databases that run as a server, SQLite stores an entire database in a single file — making it perfect for local storage, embedded systems, and data exchange.
Common SQLite files you might encounter include browser history databases, chat application data (like iMessage), app caches, scientific datasets, and development databases. This viewer lets you inspect any of them without installing database software.
Privacy & Security
Your database file is loaded directly into your browser's memory using the FileReader API and processed by sql.js, a WebAssembly port of SQLite. No data is ever transmitted to any server. This is especially important when working with databases that may contain sensitive information like user records, credentials, or personal data.
Frequently Asked Questions
Is this SQLite viewer free?
Yes, completely free. No sign-up, no hidden fees. Open and browse as many SQLite databases as you need.
Is my database uploaded to a server?
No. Your database is processed entirely in your browser using sql.js (SQLite compiled to WebAssembly). Your data never leaves your device — we never see, store, or have access to your files.
What file types are supported?
The viewer supports .db, .sqlite, .sqlite3, and .db3 files. These are all standard SQLite database file extensions.
Can I run custom SQL queries?
Yes. The built-in SQL editor lets you run any read-only query against your database, including SELECT, PRAGMA, and more. Results are displayed in a scrollable table and can be exported to CSV.
Is there a file size limit?
There is no hard limit. The tool runs in your browser, so performance depends on your device's available memory. It comfortably handles databases up to 100MB. Larger files may take longer to load.
Can I modify the database?
This viewer is read-only for safety. You can browse tables and run SELECT queries, but you cannot INSERT, UPDATE, or DELETE data. This ensures you never accidentally modify your database.