SQLite Local Browser

Your SQLite database. Your browser. No server needed.

User Manual

Overview

SQLite Local Browser is a browser-based SQLite database editor and viewer. It works entirely offline — your database file is opened locally and never uploaded anywhere. It supports .db, .sqlite, .sqlite3, and .db3 files.

Getting Started

Opening a Database

• Drag and drop a SQLite file onto the main area, or
• Click 📂 Open .db in the toolbar to browse for a file.

Creating a New Table

Click 🆕 New Table in the toolbar to define a new table from scratch.

Saving Your Work

• ⬇ Save As — saves the database to a new file on your computer.
• 💾 Save in place — overwrites the original file you opened.
• Autosave — enable the autosave toggle to have changes persisted automatically.

The Sidebar

The left sidebar lists all Tables and Views in your database. Click any item to select it and work with it in the main panel.

Main Tabs

Browse

Displays the rows of the selected table in a paginated grid.

• Use the rows/page dropdown (50 / 100 / 250 / 500) to control how many rows are shown.
• Navigate pages with the ⏮ ◀ ▶ ⏭ controls.
• ➕ Add row — insert a new empty row.
• 🔁 Replace — replace the contents of a row.
• 🔧 Alter table — modify the table's column definitions.
• 🎲 Generate data — populate the table with sample/test data.
• Stage changes / 📋 Review & Apply — changes are staged before being committed. Review the pending changes (count shown in the button) and apply them when ready.
• Export CSV / Export JSON — download the current table data in either format.

SQL

A full SQL editor for writing and running arbitrary queries.

• Press Ctrl+Enter (or click ▶ Run) to execute the query.
• Run selection — runs only the highlighted portion of your SQL.
• Explain — shows the query execution plan.
• Templates… — insert pre-built query templates.
• Saved… / ★ Save — save frequently-used queries for later.
• Begin / Commit / Rollback — manual transaction control.
• 📊 Chart — visualize query results as a chart (see Charts below).
• Export CSV / Export JSON — export query results.

Query Builder

A visual, no-code interface for constructing SQL queries.

• Select a table, choose columns, set filters and ordering.
• Click Generate SQL to preview the SQL the builder will run.
• Click ▶ Run to execute directly, or Send to SQL tab to move it to the SQL editor for further editing.

Schema / DDL

Shows the raw DDL (CREATE TABLE statements and friends) for the selected table or the entire database.

• Copy all — copies the full DDL to the clipboard.
• Export .sql — downloads the DDL as a .sql file.

Indexes

Lists all indexes on the selected table. Click ➕ New index to create one.

Relationships

Displays the foreign key relationships defined in the schema. Click Export SVG to save the diagram.

ERD

An interactive Entity-Relationship Diagram of your entire database. Click a table to highlight its connections. Export as SVG or PNG.

Statistics

Database-wide statistics — table sizes, row counts, and more. Click Refresh to update.

Profile

Column-level profiling for the selected table: value distributions, null counts, unique counts, and other per-column stats. Click Profile current table to run the analysis.

Search

A global full-text search across all tables in the database.

• Toggle case-sensitive and exact match options.
• Set a limit/table to cap results per table.
• Click Search to run.

Integrity

Runs SQLite's built-in integrity check on the database and reports any errors or corruption.

Compare

Opens a second SQLite database alongside the current one and compares schemas and data between them. Click Open second DB… to load the comparison database.

Snapshots

SQLite Local Browser automatically takes snapshots before any write operation (at most one per 5 seconds, keeping up to 15).

• 📸 Take snapshot — manually capture the current state.
• 💾 Persist workspace now — save the current workspace to browser storage so it survives a page refresh.
• Clear stored workspace — remove the persisted workspace.
• Restore / Discard — restore or discard the last snapshot.

Log

An audit log of all SQL statements executed in the current session, including auto-generated ones.

• Export audit .sql — download the full log as a .sql file.
• Clear log — clear the current session's history.
• Saved queries are also accessible from this tab.

Charts

After running a query in the SQL tab, click 📊 Chart to visualize the results.

Click Draw to render. Export as SVG or PNG with the respective buttons.

Keyboard Shortcuts

Privacy

SQLite Local Browser processes everything locally in your browser. No data is transmitted to any server. Your database file stays on your machine at all times.

Supported File Types

.db · .sqlite · .sqlite3 · .db3