Edit an SQLite database in your browser

edit_sqlite is a browser-based tool for opening SQLite databases, SQL dumps from SQLite, MySQL or PostgreSQL, and CSV files. Users can edit cells and rows in a spreadsheet-style grid, change table structures, or run SQL to select and modify data. It can export a new SQLite file, SQL dump in several dialects, or CSV, and can convert between these formats. CSV columns can be assigned types before a table is created. The editor works offline after loading, requires no account, and keeps files and saved queries on the user’s device.

Its central safety choice is to leave the original file untouched and rebuild exports from the edited data, rather than modify database bytes in place. The generated SQLite files are checked with SQLite’s own integrity test. The tool focuses on data, not full database structure: indexes, views and triggers are provided as a recreation script, while foreign-key and CHECK constraints are not modeled. Its built-in SQL console handles SELECT, UPDATE, DELETE and INSERT; more complex read-only analysis uses SQLite’s engine. Large databases and rows over roughly 4 KB are declined, and binary values can be preserved but not edited in the grid. The intended workflow for server databases is to edit exported dumps locally, then load the result back into the server.