Or search for "SQLite IntelliView" in the Extensions sidebar.
Usage
Opening a Database
Right-click any .db, .sqlite, or .sqlite3 file in the Explorer and select "Open SQLite Database".
Or run the command:
Ctrl/Cmd+Shift+O or search for Open SQLite Database in the Command Palette.
Connecting to Encrypted Databases
Run "Connect with SQLCipher Key" from the Command Palette or use Ctrl/Cmd+Shift+K.
Database Explorer
View all tables and columns in the Database Explorer side panel.
Click tables to view data and schema.
Query Editor
Write and execute SQL queries in the Monaco-powered editor.
Use Ctrl/Enter (or Cmd/Enter on Mac) to run queries.
Export Data
Run "Export Data" from the Command Palette or use Ctrl/Shift+E.
Context Menus
Right-click table cells for copy and navigation options.
Commands
Command ID
Title
Description
sqlite-intelliview-vscode.openDatabase
Open SQLite Database
Open a SQLite/SQLCipher database file
sqlite-intelliview-vscode.connectWithKey
Connect with SQLCipher Key
Open encrypted database with a password
sqlite-intelliview-vscode.refreshDatabase
Refresh Database
Refresh the database explorer/tree view
sqlite-intelliview-vscode.exportData
Export Data
Export table data (CSV/JSON, coming soon)
Configuration
Setting
Type
Default
Description
sqliteIntelliView.defaultPageSize
number
100
Default number of rows per page in data tables (10–1000)
sqliteIntelliView.enableEncryption
boolean
true
Enable SQLCipher encryption support
sqliteIntelliView.themeIntegration
boolean
true
Enable automatic theme integration for the editor UI
Keybindings
Command
Windows/Linux
macOS
When
Open SQLite Database
Ctrl+Shift+O
Cmd+Shift+O
explorerViewletVisible
Connect with SQLCipher Key
Ctrl+Shift+K
Cmd+Shift+K
Refresh Database
Ctrl+Shift+R
Cmd+Shift+R
Export Data
Ctrl+Shift+E
Cmd+Shift+E
Example: Command Palette Usage
Open SQLite Database:
Ctrl/Cmd+Shift+O or search for Open SQLite Database.
Connect with SQLCipher Key:
Ctrl/Cmd+Shift+K or search for Connect with SQLCipher Key.
Refresh Database:
Ctrl/Cmd+Shift+R or search for Refresh Database.
Export Data:
Ctrl/Cmd+Shift+E or search for Export Data.
Development
Prerequisites
Node.js 20.x or higher
VS Code 1.101.0 or higher
Build & Run
git clone https://github.com/Bowlerr/sqlite-intelliview-vscode.git
cd sqlite-intelliview-vscode
npm install
npm run compile
# For development mode:
npm run watch
Test
npm test
Lint
npm run lint
Changelog
See CHANGELOG.md for release notes and version history.
