Skip to content

Latest commit

Β 

History

History
76 lines (50 loc) Β· 1.84 KB

File metadata and controls

76 lines (50 loc) Β· 1.84 KB

πŸ—„οΈ SQLite WEB Editor

πŸ‘‰ Try the online demo here
(Demo link goes here)


Web SQLite Editor Logo

πŸš€ Overview

Web SQLite Editor is a 100% client-side SQLite database editor that runs entirely in your browser.
No servers. No backend. No installation. No uploads.

Everything happens locally using pure JavaScript.

Your data never leaves your computer.


Web SQLite Editor Screenshot

πŸ” Security & Privacy

  • βœ… 100% browser-side execution
  • βœ… No data is sent to any server
  • βœ… Works fully offline after loading
  • βœ… Uses sql.js (SQLite compiled to WebAssembly)

If you can open a web page, you can safely edit SQLite databases.


✨ Features

  • πŸ“‚ Open any existing SQLite database (.sqlite, .db, .sqlite3)
  • πŸ†• Create new in-memory databases
  • 🧱 Create, edit, and delete tables
  • ✏️ Insert, update, and delete records
  • 🧬 Modify table structure (columns, types, constraints)
  • πŸ”‘ Full support for Primary Keys, including composite PKs
  • ⚑ Execute custom SQL queries
  • πŸ” Create and manage SQLite triggers
  • πŸ“Š Browse large tables efficiently
  • 🌐 100% web-based β€” no installation required

πŸ› οΈ How It Works

The editor uses:

  • sql.js (SQLite compiled to WebAssembly)
  • Pure JavaScript
  • HTML + CSS
  • Runs entirely in the browser memory

Databases can be:

  • Loaded from a local file
  • Created empty in memory
  • Exported back to a SQLite file

πŸ“¦ Installation

There is nothing to install.

Just clone the repository and open sqlite_editor.html:

git clone https://github.com/sysmaya/SQLite-web-Editor.git
cd web-sqlite-editor