A powerful VSCode extension for viewing and managing SQLite database files.
Key Features
Database Browsing
- Auto Recognition - Supports
.db, .sqlite, .sqlite3, .db3 format database files
- Database Overview - View basic database information, file size, and table count statistics
- Table List Navigation - Quickly browse all tables, displaying table types and row counts
Data Viewing and Editing
- Table Data View - Display data in tabular format with pagination support (10/20/50/100 rows)
- Data Query - Search by field name
- Table Structure Analysis - View field definitions, data types, primary keys, not-null constraints, default values
- Index Information - Display table index details
- Create Statements - View complete CREATE SQL statements for tables
SQL Execution
- SQL Editor - Integrated Monaco Editor with syntax highlighting
- Execution Control - Support for executing all SQL or selected portions
- Result Display - Bottom console shows execution results
- Formatting - SQL statement formatting functionality
More Features
- JSON Formatting - Field values that conform to JSON format can be viewed as formatted JSON data
- Foreign Key Fields - Display foreign key associated tables, click to quickly jump to related tables
Documentation
Suggestions & Feedback
If you have any usage issues or suggestions, you can:
| |
