🗄️ SQLite Viewer
Open SQLite database files in your browser: browse tables, preview data, and run SQL queries.
Drop a .sqlite or .db file here, or click to browse
About this tool
This tool lets you open SQLite database files directly in your browser — no server, upload, or install needed. You can browse tables and views, preview their contents with column headers and row counts, and run custom SQL queries. The database file stays on your device; the entire engine runs in your browser via sql.js compiled to WebAssembly.
It's useful for inspecting SQLite databases from development projects, analyzing app databases (Chrome history, iOS backups, etc.), debugging ORM-generated schemas, or quickly querying a downloaded dataset without installing a database client.
Example: open a database with a users table and an orders table. Click users in the sidebar to see all columns, the first 200 rows, and the total row count. Switch to the SQL Query tab and run SELECT users.name, COUNT(orders.id) FROM users LEFT JOIN orders ON users.id = orders.user_id GROUP BY users.id to see the aggregated result.
FAQ
Does this tool upload my database? ›
No. The entire SQLite engine runs in your browser via WebAssembly. Your database file is read from disk and processed locally — it never leaves your device. No data is sent to any server.
What SQL operations are supported? ›
The sql.js engine supports most SQLite features: SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, indexes, JOINs, aggregations, subqueries, and common table expressions. Write operations modify the in-memory copy — the original file is not changed unless you manually export the modified database.
Is there a file size limit? ›
The practical limit depends on your browser and available memory. Most browsers can handle databases up to a few hundred megabytes. Very large databases (1GB+) may cause performance issues or exhaust memory. For those, consider using a native SQLite client or the sqlite3 CLI.
Can I export the modified database? ›
Currently this tool is read-only for simplicity. If you need to save changes, you can modify the SQL queries to INSERT/UPDATE/DELETE data in memory and use <code>db.export()</code> to download the modified file — but that would require extending the tool with a download button.
Do you support other data formats like Parquet? ›
No — this tool is for SQLite databases only. For Apache Parquet files, see the <a href="/tools/parquet-viewer/">Parquet Viewer</a> which handles columnar data with schema browsing, column statistics, and row preview. Each tool is designed for a specific format: SQLite for relational databases, Parquet for columnar data engineering formats.