SQLite DB Explorer

Browse, edit, and visualize SQLite databases directly in VS Code. No external tools required.

Features

Data Grid

View table data with sorting, filtering, and pagination. Edit cells inline by double-clicking, add new rows, or select and delete existing ones. All changes are batched — review before committing.

Sort by any column (click header)
Filter rows with operators: equals, not equals, greater/less than, like, is null
Paginate large tables (50 / 100 / 500 / 1000 rows per page)
Inline cell editing with visual diff highlighting
Batch save or discard all pending changes

Editing requires a primary key on the table. Views are read-only.

SQL Editor

Write and execute raw SQL queries with full result display. Supports SELECT, INSERT, UPDATE, DELETE, and PRAGMA statements. Query history is preserved during the session.

Execute with Ctrl+Enter (Cmd+Enter on macOS)
Query history dropdown for quick re-execution
Execution time displayed per query

Schema Manager

Inspect and modify your database schema through a visual interface.

View all tables, views, and indexes with column details
See column types, constraints (PK, NOT NULL, UNIQUE, FK), and defaults
Foreign key relationships displayed per table
Create new tables with a visual column editor
Drop tables, views, and indexes

ER Diagram

Interactive entity-relationship diagram powered by React Flow with automatic layout.

Auto-positioned nodes using dagre graph layout
Foreign key edges with animated arrows and labels
Drag nodes to rearrange
Click a table to navigate to its data
Zoom, pan, and fit-to-view controls

Quick access to all database objects.

Tables with row counts
Views
Indexes with table and column details on hover
Keyboard accessible (Tab, Enter)

Import & Export

Export query results or table data to CSV, JSON, or SQL INSERT statements. Import data from CSV or JSON files into existing tables.

Supported File Types

Opens automatically when you click on:

Extension	Description
`.db`	Generic SQLite database
`.sqlite`	SQLite database
`.sqlite3`	SQLite 3 database
`.s3db`	SQLite 3 database

Or use the Command Palette: SQLite: Open Database

Getting Started

Install the extension
Open any .db, .sqlite, .sqlite3, or .s3db file in VS Code
The database opens in a custom editor with four views: Data, SQL, Schema, and ER Diagram

Requirements

VS Code 1.85.0 or later
No additional software required (SQLite engine is bundled)

Known Limitations

Editing is only available for tables with a primary key
Views are read-only
BLOB values are displayed as [BLOB] (not editable)
Large databases (100K+ rows) may have slower COUNT queries on unindexed tables

Contributing

Contributions welcome! See the GitHub repository for source code and issue tracking.

# Clone and install
git clone https://github.com/DmytroHnatiuk/sqlite-db-explorer.git
cd sqlite-db-explorer
npm install

# Build
npm run build

# Watch mode (separate terminals)
npm run watch:ext
npm run watch:webview

# Run tests
npm test

# Package .vsix
npm run package

License

MIT

SQLite DB Explorer