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

Sidebar Navigation

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

1. Install the extension
2. Open any .db, .sqlite, .sqlite3, or .s3db file in VS Code
3. 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