SQLitePilot
A powerful SQLite database editor for Visual Studio Code
BLOB image preview (auto-renders photos and images from binary columns), auto-open support (shows first table's editable data grid immediately), full CRUD on editable grids, raw SQL with live filter & column sorting, export (JSON/CSV/XLSX/HTML/SQL), query history, tree explorer, and more.
Made with ❤️ by Anand Shah for the developer community.
See CHANGELOG.md for a detailed history of changes.
✨ Features
- 🖼️ Automatic BLOB Image Rendering — PNG, JPEG, BMP and other images from BLOB columns display as inline responsive images in the data grid
- 📊 Instant Editable Grids — Click any table (or auto-open first table on DB connection) to view and interact with full data
- 🔧 Complete CRUD Support — Double-click to edit cells, + Add Row, per-row delete (intelligently handles primary keys and AUTOINCREMENT columns)
- 🔍 Live Filtering & Sorting — Real-time client-side row filter + clickable column headers for asc/desc sort (current page)
- 📝 Powerful SQL Editor — Execute full scripts or selected text only (
Ctrl/Cmd+Enter supported), with rich result grids
- 📜 Query History — Persistent tab showing all previous queries with timestamps and details for easy reuse
- 📤 Rich Export Options — Export any result set to JSON, CSV, XLSX, HTML (images embedded as base64), or SQL INSERT statements
- 🌲 Database Explorer — Sidebar tree view with live row counts, column metadata, and convenient context menus
- ⚡ Smart Auto-Open — Seamlessly handles
.db, .sqlite, .sqlite3, .db3 files — connects DB, opens Query Panel, closes binary preview
- 🎨 Polished UI/UX — Modern webview with full dark/light theme support, responsive design, status bar integration
📸 Screenshots & Demo
(Add screenshots and GIF demonstrations to the media/ folder for the best Marketplace experience. Community contributions of visuals are welcome!)
1. Database Explorer View
2. Editable Data Grid with BLOB Image Preview
3. SQL Editor, Live Filter, and Export
4. Query History & CRUD Operations
🚀 Quick Start / Installation
- Install SQLitePilot from the VS Code Marketplace (search for "SQLitePilot" in Extensions sidebar:
Ctrl+Shift+X).
- Open any SQLite database file (
.db, .sqlite, etc.) — it auto-connects and displays the first table.
- Use the SQLitePilot icon in the Activity Bar for the database explorer.
Pro tip: Right-click database files in the Explorer for quick "Open Database with SQLitePilot" access.
📖 How to Use the Extension
Connect to a Database
- Auto-open: Double-click or open any
.sqlite, .db, .sqlite3, or .db3 file. The sidebar tree populates, Query Panel opens with the first table's full editable grid, and binary views are closed automatically.
- Use sidebar Open Database File... command or Create New Database....
- Explorer context menu: Right-click → "Open Database with SQLitePilot".
- Sidebar Tree: Expand to see tables (with live row counts) and columns.
- View/Edit Data: Click a table name to load its data in the editable grid.
- BLOB Images: Automatically rendered inline.
- Filter: Use the "Filter rows..." toolbar input for instant client-side search.
- Sort: Click column headers to toggle ascending/descending on current page.
- Edit Cell: Double-click any non-image cell (requires primary key on table).
- Add Row: Click + Add Row button (skips AUTOINCREMENT PK columns intelligently).
- Delete Row: Use the ✕ button next to each row.
- Table Management:
- Right-click database → Create Table... (pre-fills SQL template).
- Right-click table → Drop Table.
SQL Editor & Advanced Features
- Write and run SQL in the dedicated editor panel.
- Run button (full script) or Run Selected (highlighted text only). Also supports
Ctrl/Cmd + Enter.
- Use
ORDER BY / WHERE in SQL for server-side sorting/filtering on large datasets.
- Export results via the toolbar (JSON/CSV/XLSX/HTML/SQL). Images export as base64 where supported.
- Switch to History tab to browse, review, and re-run previous queries with full metadata.
Note: Simple single-table SELECT queries (from manual SQL) also support full CRUD and "Add Row" thanks to automatic table context detection.
This guide, combined with the interactive UI, makes managing SQLite databases in VS Code fast and delightful.
🤝 Contributing
We welcome contributions from the developer community! Please see CONTRIBUTING.md for detailed guidelines, development setup, and how to submit Pull Requests.
Made with ❤️ by Anand Shah for the developer community.
📄 License
Distributed under the MIT License. See LICENSE for more information.
🔗 Links
Thank you for using SQLitePilot! 🗄️✨ Happy querying and happy coding!
