A powerful VS Code extension for viewing and managing SQLite databases with advanced features like inline editing, auto-refresh, and intelligent database discovery.
Features
Database Viewing
Browse SQLite databases directly in VS Code
Schema explorer with tables, columns, types, and constraints
Paginated data viewing for large datasets
Primary key and foreign key visualization
Virtual scrolling for smooth performance with 100k+ rows
Data Editing
Double-click cells to edit values inline
Automatic primary key detection
Safe updates with WHERE clause validation
Visual feedback for editable vs read-only columns
SQL Runner
Execute custom SQL queries
Syntax highlighting and validation
Read-only mode for safe exploration
Edit mode for data modifications
Paginated query results
Auto-Refresh
Monitor database file for external changes
Automatic UI updates when data changes
500ms debouncing to prevent excessive reloads
Toggle on/off with header button
Database Discovery
Recursively search workspace for SQLite files
Verify files by SQLite header signature
QuickPick interface for easy database selection
Support for .sqlite, .db, and .sqlite3 extensions
Safety Features
Read-only by default
Explicit edit mode activation required
Visual warning banner when edit mode is active
Primary key required for inline editing
Query classification (READ/WRITE/SCHEMA)
Parameterized queries prevent SQL injection
Usage
Opening a Database
Method 1: Find Databases Command
Open Command Palette (Ctrl+Shift+P / Cmd+Shift+P)
Type "SQLite: Find SQLite Databases"
Select a database from the list
Method 2: File Explorer
Right-click any .sqlite, .db, or .sqlite3 file
Select "Open with SQLite Viewer"
Viewing Data
Select a table from the Schema Explorer sidebar
Browse data in the main panel
Use pagination controls to navigate large tables
Editing Data
Click the "Edit Mode" toggle button in the header
Read the warning and confirm
Double-click any cell to edit (except primary keys)
Press Enter to save or Escape to cancel
Running Queries
Switch to the "SQL Runner" tab
Write your SQL query
Click "Execute" or press Ctrl+Enter
View results in the data grid below
Auto-Refresh
Click the "Auto-Refresh" toggle button
When another app or process modifies the database, the UI updates automatically
Perfect for monitoring databases that change frequently
