Skip to content

Lightweight, secure, and WebAssembly-powered SQLite viewer and editor. works entirely in your browser

License

Notifications You must be signed in to change notification settings

vwh/sqlite-online

Repository files navigation

SQLite Online Logo

SQLite Online

A fast, secure, and client-side SQLite editor that runs entirely in your browser—no server required. Built with WebAssembly, sql.js, and ReactJS, brings the full power of SQLite database management right to your browser.

LicenseFormat CheckLint

Overview

  • Create database files
  • Define, modify, and delete tables and indexes
  • Browse, edit, add, and delete records
  • Sort and search through data effortlessly

SQLite Online provides a powerful yet accessible platform that requires zero installation. All processing is done within your client browser, ensuring your data remains private and secure.

Features

  • Client Browser Processing:
    • No installation required – work directly in your browser
    • All operations run on the client side – your data never leaves your device

  • Lightning Fast:
    • Powered by WebAssembly and enhanced with Web Workers for threading
    • Efficient handling of large databases and heavy operations

  • Offline & PWA Support:
    • Fully functional without an internet connection
    • Install as a desktop app on your mobile or desktop device

  • Comprehensive Database Management:
    • Create, compact, and manage database files
    • Define, modify, and delete tables, indexes, and records
    • Sort and search records with ease
    • Import and export data (CSV, SQL dumps)
    • Full SQL query support with command logging

Keyboard Shortcuts (Hotkeys)

Streamline your workflow with these built-in hotkeys:

ShortcutAction
Ctrl + sDownload the database
Ctrl + ArrowRightGo to the next page
Ctrl + ArrowUpJump to the first page
Ctrl + ArrowDownJump to the last page
Ctrl + ArrowLeftGo to the previous page
Ctrl + `Close the edit panel
Ctrl + iTrigger insert panel
Ctrl + ISubmit an insert edit
Ctrl + uSubmit an update edit
Ctrl + dSubmit a delete edit
Ctrl + qExecute the SQL query

License

SQLite Online is released under the MIT License.

Contributors 8