SQLite Explorer

SQLite Explorer is a feature-rich VS Code extension that brings full database management capabilities directly into your editor. Built with a hybrid architecture combining WebAssembly (sql.js) for universal compatibility and optional native SQLite bindings for enhanced performance.

Core Architecture: The extension uses a worker-based architecture with separate threads for database operations, ensuring the UI remains responsive even with large datasets. The codebase is organized into distinct modules: database model layer, worker factory for thread management, and a platform abstraction layer for cross-environment support.

Key Features:

• Multi-format Support - Opens .sqlite, .db, .sqlite3, .db3, .sdb, .s3db, and .gpkg files natively
• Schema Browser - Hierarchical view of tables, views, and indexes in a dedicated sidebar
• Virtualized Scrolling - Handles tables with thousands of rows smoothly using virtual rendering
• Inline Editing - Double-click cells to edit, with full undo/redo support (Ctrl+Z/Y)
• Column Pinning - Keep important columns visible while scrolling horizontally
• Row Pinning - Pin rows to top for easy reference during navigation
• Batch Updates - Modify specific columns across multiple selected rows simultaneously
• VS Code Editor Integration - Edit large values (JSON, SQL) in full editor tabs
• Export Options - Export to CSV, JSON, SQL, or Excel formats
• Database Settings GUI - Configure SQLite pragmas (WAL mode, Foreign Keys, etc.)
• JSON Patching - Smart updates for JSON fields using RFC 7396 Merge Patching

Cross-Platform: Works in VS Code Desktop, VS Code for Web, and remote environments (SSH, WSL, containers). Localized in 14 languages with automatic theme integration.