SQL Viewer (SQLite)
A powerful SQLite database viewer for Visual Studio Code that lets you explore, filter, and edit your database files without leaving your editor.
✨ Features
- 📁 Open any SQLite file - Simply click on
.sqlite or .db files to open them instantly
- 🗂️ Table Explorer - Browse all tables in your database from an integrated sidebar
- 📊 Data Visualization - View table data in a clean, modern interface that adapts to your VS Code theme
- 🔍 Real-time Filtering - Filter table results on the fly without writing SQL queries
- ✏️ Row Editing - Edit database rows directly through an intuitive modal interface
- ⚡ Fast Loading - Smart pagination and background loading for large datasets
- 🎨 Theme Integration - All icons and UI elements adapt to your VS Code color theme
- 🔄 Refresh & Reset - The main toolbar refresh button now fully resets the database and reloads the table list
- #️⃣ Row Counters - Row counters show only the icon and number, styled with the theme color
- 🌐 External Links - Discord and Ko-fi icon buttons open external links securely using the VS Code API
Perfect for database inspection, quick data checks, debugging, or exploring SQLite file structures during development.
🚀 Installation
- Open VS Code
- Go to Extensions (
Ctrl+Shift+X or Cmd+Shift+X)
- Search for "SQL Viewer"
- Click Install
📖 Usage
Opening Database Files
- Open any
.sqlite or .db file in VS Code
- The SQL Viewer will automatically activate and display your database
Exploring Tables
- Table List: All tables appear in the left sidebar
- Click any table to view its contents
- First table is automatically selected when you open a database
Viewing Data
- Table data displays in a clean, sortable format
- Row numbers are shown for easy reference
- NULL values are clearly marked as NULL
- Pagination automatically handles large datasets
Filtering Data
- Use the filter input in the top-right toolbar
- Filter searches across all columns in real-time
- No SQL knowledge required - just type what you're looking for
Editing Rows
- Double-click any row to open the edit modal
- Edit multiple fields at once in a user-friendly form
- Save changes directly to the database
- Changes are immediately reflected in the table view
Refreshing Data
- Refresh & Reset database: Click the refresh icon in the main toolbar to fully reset the database and reload the table list
- Refresh sidebar: Click the refresh icon in the sidebar to reload the table list only
- External links: Use the Discord and Ko-fi icon buttons in the toolbar to open community/support links
🛠️ Requirements
- Visual Studio Code 1.60.0 or higher
- SQLite database files with
.sqlite or .db extensions
- Node.js sqlite3 module (automatically handled by the extension)
⚙️ Extension Settings
Currently, SQL Viewer works out of the box with no configuration needed. Future versions may include:
sqlViewer.maxRows: Maximum rows to display per pagesqlViewer.enableEditing: Toggle row editing functionalitysqlViewer.autoRefresh: Auto-refresh when files change
🐛 Known Issues
- Large tables (>10,000 rows) may take a moment to load initially
- Binary data (BLOBs) are displayed as
[BLOB] placeholder
- Row editing is currently limited to text-based data types
- Complex queries are not yet supported (coming in future versions)
📝 Release Notes
0.0.6
0.0.5
0.0.4
0.0.3
- Discord and Ko-fi icon buttons in the toolbar, using theme color and secure external link handling
- Row counters now show only the icon and number, styled with the theme color
- Main refresh button now resets the database and reloads the table list
- Improved error handling and user feedback for database and external link operations
- Visual polish: all icons/buttons respect the VS Code theme
0.0.2
- Performance improvements for large databases
- Better error handling and user feedback
- UI/UX refinements
0.0.1
- Initial release of SQL Viewer
- Basic SQLite file viewing and table exploration
- Real-time data filtering
- Row editing functionality
- Theme-aware interface
🤝 Contributing & Support
Found a bug or have a feature request? We'd love to hear from you!
Happy database exploring! 🗃️✨
| |
