SQLite Viewer

View SQLite database files online — entirely in your browser, with no upload.

Tiếng Việt

SQLite Viewer is a lightweight, static web app for browsing .sqlite / .db / .db3 files: explore tables, inspect schema and indexes, run SQL queries, and export data — all processed locally on your device.

Features

• Open any SQLite file — drag & drop or file picker (.sqlite, .sqlite3, .db, .db3, .s3db)
• 100% local — the file is parsed with a WebAssembly build of SQLite in your browser; nothing is ever sent to a server
• Browse data — paginated, sortable, searchable table grid with type-aware formatting (NULL, numbers, BLOBs)
• Structure view — columns, types, constraints, primary keys, indexes, and the original CREATE statement
• SQL query editor — write and run arbitrary SQL, with query history and a basic formatter
• Database info — file size, table/view/index counts, total rows, encoding, page size, and a per-table row distribution overview
• Export — download a table (or query result) as CSV, JSON, or SQL insert statements
• Bilingual UI — English and Vietnamese, switchable at any time
• Light / dark / system themes
• Remembers your preferences — language, theme, and query history are saved in localStorage
• Installable PWA — add it to your home screen / desktop and use it offline
• Responsive — works well on desktop, tablet, and mobile
• Accessible — keyboard navigable, visible focus states, semantic roles, reduced-motion aware

Getting started

This is a static site — no build step, no backend.

1. Download or clone this repository
2. Serve the folder with any static file server, for example:

   npx serve .
   # or
   python3 -m http.server 8080

3. Open the served URL in your browser

Opening index.html directly via file:// may block the WebAssembly module or service worker in some browsers — a local server is recommended.

No dependencies to install for end users. All required libraries (SQLite compiled to WebAssembly via sql.js) are bundled in vendor/.

Project structure

sqlite-viewer/
├── index.html          Application shell and markup
├── manifest.json        PWA manifest
├── sw.js                 Service worker (offline caching)
├── css/style.css        Styles, design tokens, themes, responsive rules
├── js/
│   ├── i18n.js           English / Vietnamese translation strings
│   ├── db.js             sql.js wrapper: open file, schema, queries
│   └── app.js            UI logic and state management
├── vendor/               Bundled sql.js (WebAssembly SQLite engine)
├── icons/                App icons and favicons
└── gen_icons.py          Script used to generate the icon set

Browser support

Any modern browser with WebAssembly support: recent versions of Chrome, Edge, Firefox, and Safari, on desktop and mobile.

Privacy

Your database file is read with the browser's File API and processed entirely in memory on your device. The app makes no network requests involving your data — the only external requests are for the UI font, and those can be removed by self-hosting the font if you need a fully offline build.

Credits

• Author: gnort67
• Built with the assistance of Claude (Anthropic)
• SQLite-in-the-browser powered by sql.js
• UI typeface: Be Vietnam Pro

License

You're free to use, modify, and redistribute this project for personal or commercial purposes.