SQLite CRUD Viewer - VS Code Extension

A professional, feature-rich SQLite database viewer and editor for Visual Studio Code. Manage your SQLite databases with an elegant, modern interface that supports all CRUD operations.

✨ Features

🔍 Database Exploration

• Browse Tables: Navigate through all tables in your SQLite database
• Table Information: View column details including types, primary keys, and constraints
• Real-time Search: Instant search across table contents
• Sortable Columns: Click any column header to sort data
• Pagination: Handle large datasets with customizable pagination

📊 Data Management

• View Records: See all row data in a clean, readable format
• Add Rows: Insert new records with intuitive forms
• Edit Rows: Update existing records with validation
• Delete Rows: Remove records with confirmation dialog
• Bulk Operations: Export data to CSV format

👁️ Advanced Viewing

• Row Details View: Complete overview of all column values
• Long Text Support: View full text content in a dedicated modal
• Text Statistics: Character count, word count, and line count for text fields
• Copy to Clipboard: Copy individual values or entire rows as JSON

⚡ SQL Interface

• SQL Query Editor: Execute custom SQL queries directly
• Query Results: View results in a formatted table
• Syntax Support: Full SQL syntax highlighting

🚀 Installation

From VS Code Marketplace

1. Open VS Code
2. Go to Extensions (Ctrl+Shift+X)
3. Search for "SQLite CRUD Viewer"
4. Click Install

Manual Installation

1. Download the .vsix file
2. Open VS Code
3. Go to Extensions → Views and More Actions (⋯) → Install from VSIX
4. Select the downloaded file

📖 Usage

Opening a Database

1. Open a SQLite database file (.db) in VS Code
2. Right-click the file in the Explorer
3. Select "Open with SQLite CRUD Viewer"
4. Or use the Command Palette (Ctrl+Shift+P) and type "SQLite: Open Database"

Basic Operations

Viewing Data

• Click any table name in the sidebar to view its contents
• Use the search box to filter results
• Click column headers to sort
• Click the eye icon (👁️) to view full row details

Adding Rows

1. Select a table
2. Click the "Add Row" button in the header
3. Fill in the form with your data
4. Click "Add Row" to save

Editing Rows

1. Click the edit icon (✏️) next to any row
2. Modify the values in the form
3. Click "Save Changes"

Deleting Rows

1. Click the trash icon (🗑️) next to any row
2. Confirm the deletion in the dialog
3. The row will be permanently removed

Viewing Long Text

• For long text fields, click the "View Full" button
• View complete content in a dedicated modal
• Copy text to clipboard with one click
• See text statistics (length, words, lines)

Exporting Data

1. Navigate to the table you want to export
2. Click the download icon (📥) in the grid header
3. Data will be exported as a CSV file

Using SQL Queries

1. Click the "SQL" button in the header
2. Enter your SQL query in the editor
3. Press Ctrl+Enter or click "Run" to execute
4. View results in the table below

🎨 Interface Overview

Sidebar

• Database Tables: List of all tables in the current database
• Refresh Button: Reload the table list
• Statistics: Shows column count and primary keys for selected table

Main Content Area

• Header: Table name, search box, and action buttons
• Data Grid: Tabular view of your data with actions column
• Pagination: Navigate through pages of data
• Row Count: Total number of records displayed

Action Buttons

• 👁️ View: See complete row details
• ✏️ Edit: Modify the selected row
• 🗑️ Delete: Remove the selected row
• 📥 Export: Download data as CSV
• 🔁 Refresh: Reload current table data

⚙️ Configuration

The extension works out of the box with default settings. No additional configuration required.

🛠️ Technical Details

Supported SQLite Features

• All standard SQLite data types
• Primary keys and constraints
• NULL values handling
• Large text/blob data
• Complex queries via SQL editor

Performance Features

• Efficient pagination for large datasets
• Debounced search (300ms delay)
• Lazy loading of table contents
• Optimized database connections

Security Features

• Read-only connections where possible
• Proper error handling
• Input validation for all forms
• Confirmation for destructive actions

❓ Frequently Asked Questions

Q: Can I edit SQLite files that are in use by other applications?

A: The extension opens files in read-only mode initially. When you perform write operations, it temporarily opens a write connection and closes it immediately after.

Q: What's the maximum file size supported?

A: The extension can handle large SQLite files, but performance may depend on your system resources. Use pagination for tables with millions of rows.

Q: Are my changes saved immediately?

A: Yes, all CRUD operations are committed to the database immediately.

Q: Can I recover deleted rows?

A: No, deletions are permanent. Always double-check before deleting.

Q: Does it support SQLite extensions?

A: The extension uses the better-sqlite3 library which supports most SQLite features, but some extensions may require specific compilation.

🐛 Troubleshooting

Common Issues

"Cannot open database" error

• Ensure the file has .db extension
• Check file permissions
• Make sure the file isn't corrupted

No tables showing

• The database might be empty
• Check if the file is a valid SQLite database
• Try refreshing with the refresh button

Slow performance

• Use pagination (50-100 rows per page)
• Add indexes to frequently searched columns
• Close other large files in VS Code

Getting Help

1. Write me.

🔧 Development

Dependencies

• better-sqlite3: SQLite database driver
• @types/vscode: VS Code API types
• TypeScript: Language compilation

📄 License

MIT License - see LICENSE file for details.

📊 Version History

• 1.0.0 (Current)
  • Initial release
  • Complete CRUD operations
  • Professional UI/UX
  • SQL query editor
  • Export functionality

Enjoy working with your SQLite databases! 🎉

Made with ❤️ for developers who love clean, efficient database management tools.# SQLiteCRUDViewerExtension