How to use SQLite Database Studio
Inspect SQLite or SQLCipher schema and rows, edit cells visually or run bounded SQL, undo changes, and download a new local database.
What to provide
Drop a local SQLite 3 or SQLCipher database. Encrypted files need their password and optional compatibility version; neither the file nor SQL leaves the tab.
- Choose or drop a local SQLite or SQLCipher database. Add an optional SQLCipher password only when the database is encrypted.
- Browse schema objects and bounded table pages. Select the pencil beside a row to change ordinary text, number, or NULL values without writing SQL.
- For advanced work, run one bounded statement at a time. Explicitly allow a write statement for one run, review the result, undo if needed, then download a new database file. The original disk file is never overwritten.
What the result means
Browse schema and paged rows, edit one row through safe typed fields, export bounded query results as JSON or CSV, or download the transactionally modified SQLite or SQLCipher database as a new file.
Privacy and safety
This utility is loaded as browser code and processes your input only in this tab. OmniCastConverter has no upload endpoint and never stores your content, filenames, tokens, or secrets. Generated markup and code are shown as inert text and are never executed.
Limitations
- Visual editing requires a table row that can be identified uniquely; BLOB cells and views stay read-only. The browser engine cannot attach external databases, load native extensions, access filesystem paths, or stream a retained cursor. Files are limited to 1 GiB and receive a memory warning above 250 MiB.
Try the included example
Select “Load sample database” to create and open the tested project-tracker SQLite fixture in a local worker.
Included real sample: a projects table with IDs, owners, statuses, budgets, and ISO timestamps.