SQLite Viewer

A sqlite viewer and sqlite editor that stays offline: open any .db, .sqlite or .sqlite3 and write sql with autocomplete.

🗂 SQLite Viewer is a sqlite viewer and sqlite editor that lives in your browser. Open a database file, read it, change it, and write sql against it without installing a desktop tool first. Nothing is uploaded and no account is needed. Drop in a .db, .sqlite or .sqlite3 file and it is open a second later, running entirely offline on WebAssembly SQLite. 📂 What you can do with this sqlite database viewer 1. Open any .db, .sqlite or .sqlite3 file by clicking or dragging it into the panel 2. Browse every table and view, sort columns and filter rows as you type 3. Edit a cell and the change goes straight back to your original file 4. Add rows, add tables, and delete what you no longer need 5. Write sql in a console that autocompletes your own schema 6. Create a table from a simple form, no SQL required 7. Export to CSV or JSON, or import them back into a table 8. Keep several databases open, each in its own tab ⌨️ A sql console that knows your schema Most sqlite tools hand you an empty text box and wish you luck. This one reads your database first: 1️⃣ Autocomplete offers your own table and column names as you type 2️⃣ It understands aliases, so c. after from Customers c lists Customer columns 3️⃣ It covers 137 sqlite keywords and functions, json and window functions included 4️⃣ Select results take over the grid, full width, instead of a cramped box 5️⃣ Insert, update and delete tell you how many rows actually changed 6️⃣ The up arrow brings back a query you ran before 7️⃣ A .sql script file opens in the editor, so you can read it before running it Get a name wrong and this sqlite editor does not just say no such table. It names the object you probably meant and lists what the database actually contains. 🔍 Why choose this sqlite viewer online Plenty of sqlite db viewer tools show ads, push you to a separate website to open your own file, or quietly lose your edits on update. This one does none of that: ▸ No ads, no redirects, no third-party site between you and your database ▸ Autosave writes every change back to the file while you work ▸ A tabbed interface, so two databases sit side by side ▸ Tables, views, indexes and triggers, not just rows ▸ One undo, for the cell you just got wrong 💡 Built for developers, QA engineers and data analysts Debugging a mobile database, checking an exported sqlite database, opening a .db, .sqlite or .sqlite3 file a client sent over — none of it needs setup: - Drag the database in and it opens - Click a column header to sort, type in the filter box to narrow - Click a cell to edit, click away to save - Open the schema view to read views, indexes and triggers 📤 Imports that cannot corrupt your data ➤ Each import runs in a transaction, so one bad row writes nothing at all ➤ Quoted line breaks, commas and escaped quotes in CSV parse correctly ➤ Leading zeros in codes and IDs come back the way they went in ➤ NULL reads as NULL, never as a blank you cannot tell from an empty string 🧩 Built for messy real-world data • JSON in a text column is detected and opens formatted, with one-click copy • A blob downloads under its real type, so an image saves as an image • A blob can be swapped for a file from disk • Big tables arrive page by page instead of freezing the tab ✨ Optional on-device AI Where Chrome built-in AI is available, an Explain button appears next to Run. It reads your schema and tells you what a query does or what an error means, entirely on your machine. Nothing is sent anywhere, and if the model is not there the button is not either. 🌙 Small things that add up Light or dark follows your system. Recent files reopen in a click. Long operations show progress instead of looking frozen. The interface speaks 52 languages. None of it needs configuring, which is how a sqlite viewer chrome extension should behave in 2026. 🔐 Your data stays yours No backend, no analytics reading your files, no request that carries your data anywhere. That matters when the database holds customer records, app state, or anything else you would rather not hand to a website. ❓ Frequently asked questions Does this sqlite editor work offline? Yes. After install, opening and editing a sqlite file needs no connection at all. Can I open more than one database at once? Yes. Each gets a tab, so you can compare or copy between them. Will editing overwrite my original file? Only if you grant write access when you open it. Otherwise, export a copy whenever you like. Does it support views, indexes and triggers? Yes. The schema panel lists every one with its full definition. Can I import CSV or JSON? Yes, into any existing table, and all-or-nothing, so a bad row cannot leave a table half filled. 📥 Install this sqlite viewer and editor, and open your first .db, .sqlite or .sqlite3 file straight from the toolbar.