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.

License Format Check Lint

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:

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

License

SQLite Online is released under the MIT License.