⭐ Enjoying eSqlLite? Please take a moment to rate it on the VS Code Marketplace! Your feedback helps shape future updates and improvements.
eSqlLite is a dependable, full-featured SQLite client built for Visual Studio Code. It offers smooth database exploration, reliable performance, and bundled binaries for seamless use across macOS, Windows, and Linux - including remote and SSH environments.
Core Features
Serialized access via sqlite3 prevents race conditions and SQLITE_BUSY errors.
WAL (Write-Ahead Logging) enabled by default for enhanced concurrency (configurable).
Automatic configuration for foreign_keys=ON and busy_timeout.
Schema Explorer to browse tables and columns effortlessly.
Connections Memory View remembers recently opened databases with quick open/close and tooltips.
Run Query / Run Selection commands with paginated results.
CSV and JSON export for the most recent query results.
Bundled sqlite3 binaries for all major platforms (macOS, Windows, Linux glibc & musl).
Inline editing for simple SELECT * FROM table grids — add, edit, duplicate, or delete rows instantly.
Commands
eSQLite: Open Database
eSQLite: Close Database
eSQLite: Run Query
eSQLite: Run Selection
eSQLite: Export Last Results
eSQLite: Open From Memory
eSQLite: Close Connection
eSQLite: Forget Connection
Connections View
Accessed via the SQLite activity bar panel:
Displays the active database and up to 15 recent connections.
Each entry shows the database name and a shortened path (hover for the full path).
Click a recent database to reopen it instantly.
Close or forget connections directly without affecting files on disk.
Configuration Options
Setting
Default
Description
eSqlLite.journalMode
WAL
Defines the journal mode for concurrency and data integrity.
eSqlLite.busyTimeoutMs
5000
Time in milliseconds SQLite waits when the database is busy.
eSqlLite.defaultPageSize
100
Sets pagination size for long query results.
Reliability and Performance
All operations route through a single DatabaseManager running in serialized mode for stability.
Long-running queries are automatically paginated; COUNT(*) failures are non-fatal.
Clear error reporting via VS Code notifications.
Upcoming Features
Parameter form UI for ? bindings.
Query cancellation via SQLite interrupt.
Saved connections and per-connection query history.
Explain Query Plan and Index Analysis tools for performance insights.
