A client-side SQLite editor built with React, TypeScript, Vite, and sql.js.
It runs in the browser, initializes a demo database by default, and can open
local SQLite files without a backend.
- Open local
.db,.sqlite, and.sqlite3files - Create and modify tables, views, and indexes with SQL
- Browse, filter, sort, paginate, add, edit, and delete rows
- Run custom SQL and export results as CSV
Most database work runs locally in the browser through WebAssembly and a web worker. Optional features such as URL loading, the CORS proxy fallback, Google Fonts, and Gemini-powered query generation use network requests.
- Local-first database editing: open files from disk, drag and drop a
database into the page, and download the current database as
database.sqlite. - Schema and data workflows: inspect schema, browse table data, edit rows, insert new rows, delete rows, and execute custom SQL statements.
- CSV export paths: export an entire table, the current table page, or the current custom query result set as CSV.
- Additional UX features: dark mode, high-contrast mode, keyboard shortcuts, skip links, and live regions for accessibility.
- Optional integrations: load a database from a
?url=query parameter and generate SQL from/ai ...prompts after configuring a Gemini API key.
npm install
npm run devUseful project commands:
npm run buildnpm run build:pagesnpm run typechecknpm run checknpm run previewnpm run preview:pagesnpm run lintnpm run formatnpm run format:checknpm run knip
Streamline your workflow with these built-in hotkeys:
| Shortcut | Action |
|---|---|
| Ctrl + s | Download the database |
| Ctrl + ArrowRight | Go to the next page |
| Ctrl + ArrowUp | Jump to the first page |
| Ctrl + ArrowDown | Jump to the last page |
| Ctrl + ArrowLeft | Go to the previous page |
| Ctrl + ` | Close the edit panel |
| Ctrl + i | Trigger insert panel |
| Ctrl + I | Submit an insert edit |
| Ctrl + u | Submit an update edit |
| Ctrl + d | Submit a delete edit |
| Ctrl + q | Execute the SQL query |
SQLite Online is released under the GNU GPL v3.0.