SQLite Viewer
Browse tables, view schema, run SQL queries, and export data from a SQLite database.
Free & unlimited
Uses sql.js loaded from a CDN. Your file stays in your browser.
All processing happens in your browser. No data is sent to any server.
About this tool
- 1
Upload SQLite database
Select a .sqlite, .db, or .sqlite3 database file from your computer.
- 2
Browse tables
See all tables, views, and indexes in the database. Click a table to view its data and schema.
- 3
Run SQL queries
Write and execute SQL queries in the built-in editor. Results are displayed in a sortable table.
- 4
Export results
Export query results or entire tables as CSV files.
- Use "SELECT * FROM sqlite_master" to see the full database schema including create statements.
- The database is loaded entirely in your browser - large databases (100MB+) may be slow to open.
- All operations are read-only by default to prevent accidental data modification.
- Click column headers in the table view to sort data without writing SQL.
- Full SQL query editor with syntax highlighting
- Table browser with schema inspection (columns, types, constraints)
- Sortable and filterable data grid for table contents
- Index and view listing
- Export query results and tables to CSV
- Inspecting SQLite databases from mobile app development (Android, iOS)
- Browsing browser history or bookmark databases (which use SQLite)
- Querying data from IoT devices or embedded systems that use SQLite
- Quick data exploration of SQLite files without installing database management software