SQLite viewer

SQLite Viewer and Editor Online

Drop one or more database files here, or click to browse.

Your files stay in this browser and are never uploaded.
Try the sample database
Open or add database
No database loaded
Databases
Results

Private browser-based database workspace

Inspect and edit SQLite files without uploading your data

SQLite Viewer runs directly in your browser. Open a local .db, .sqlite, .sqlite3 or .db3 file, explore its schema and rows, run SQL, make changes and download the latest database—all without sending the file to a server.

Browse and search tables

Navigate large schemas, sort the table list by name, rows, cells or estimated size, and pin important result columns.

Edit real database rows

Add, update and delete rows with primary-key-aware controls. Write changes stay in the in-browser database until you download it.

Use a multi-tab SQL workspace

Open a fresh tab for each table or query, switch between multiple databases and keep each result connected to its query.

Generate an ER diagram

Visualize entities, columns, data types, primary keys and foreign-key relationships, then fit the diagram to the window.

Export schema and results

Export ER schemas as SQL DDL, DBML, Mermaid or GraphQL SDL, and export query results in common data formats.

Save the modified SQLite file

Changes are applied locally. Choose Save DB whenever you want to download the current database as a usable SQLite file.

How it works

From database file to useful answer in three steps

  1. Open a database.Drop a supported SQLite file onto the page or use the file picker.
  2. Explore or query it.Select a table, inspect columns, edit rows or execute your own SQL.
  3. Export what you need.Download results, schema definitions or the complete modified database.

Practical SQLite guides

Learn the workflow or open a specialized tool

How to open a SQLite file onlineA safe step-by-step browser workflow. SQLite editor onlineEdit rows and save a modified database. SQLite ER diagram generatorUnderstand tables, keys and relationships. SQLite to SQL DDLExport portable schema definitions. SQLite to DBMLMove a schema into database design tools. SQLite to MermaidCreate a text-based ER diagram. SQLite to GraphQL SDLGenerate a useful GraphQL schema starting point. View an Android SQLite databaseInspect an exported app database safely. SQLite browser without installationKnow when a local browser tool is the right choice. Useful SQLite queriesInspect tables, keys, duplicates and query plans.

Common questions

SQLite Viewer FAQ

Is my SQLite database uploaded?

No. The database is opened and processed locally by JavaScript in your browser. The tool does not need to upload the file to inspect it.

Can I edit and save a SQLite database?

Yes. You can edit supported table rows or execute write queries, then use Save DB to download the latest database state.

Which SQLite file extensions are supported?

The file picker accepts .db, .sqlite, .sqlite3 and .db3. A valid SQLite database may use another extension, but it may need to be renamed before selection.

Does it work with large databases?

Large files depend on available browser memory. The viewer limits rendered result rows and samples expensive table metadata to remain responsive.