A powerful SQLite database viewer and editor with SQL execution support for Visual Studio Code.
Features
Database Browsing
- Auto Detection - Automatically recognizes
.db, .sqlite, .sqlite3, .db3 files
- Database Overview - View database information, file size, table statistics
- Table Navigation - Quick browse through all tables with type and row count
Data Viewing & Editing
- Table Data Viewer - Display data in tabular format with pagination (10/20/50/100 rows)
- Schema Inspector - View field definitions, data types, primary keys, constraints, defaults
- Index Information - Show table index details
- CREATE Statements - View complete CREATE SQL statements for tables
SQL Execution
- SQL Editor - Integrated Monaco Editor with syntax highlighting
- Execution Control - Execute all SQL or selected portions
- Results Display - Console output for query results
- Formatting - SQL statement formatting support
User Interface
- Native VSCode Integration - Seamlessly blends with VSCode themes
- Responsive Design - Adapts to different window sizes
- Efficient Layout - High-density content display
- Convenient Operations - Refresh button, quick navigation, fixed pagination
Installation
From VSCode Marketplace
- Open VSCode
- Press
Ctrl+Shift+X to open Extensions panel
- Search for
SQLite Tool
- Click Install
Manual Installation
- Download the
.vsix file
- Press
Ctrl+Shift+P in VSCode
- Type
Extensions: Install from VSIX
- Select the downloaded file
Usage
Basic Usage
- Open a project containing SQLite database files in VSCode
- Click on any SQLite database file (
.db, .sqlite, .sqlite3, .db3)
- The extension will automatically open the database viewer
Viewing Data
- Left Panel - Shows database table list
- Right Content Area - Use tabs to switch between "Table Content" and "Table Structure"
- Pagination - Use bottom paginator to browse large tables
Executing SQL
- Expand the SQL execution area
- Type SQL queries in the editor
- Execute all SQL or selected portions
- View results in the bottom console
.db.sqlite.sqlite3.db3
Version History
Requirements
- VSCode >= 1.106.1
- Node.js >= 14.x (for development)
Development
Setup
# Clone the repository
git clone https://github.com/yourusername/sqlite-tool.git
cd sqlite-tool
# Install dependencies
pnpm install
Development Mode
# Start watch mode (recommended)
pnpm run watch
# Start debugging
# 1. Press F5 to launch Extension Development Host
# 2. Test features in the new window
Build
# Production build
pnpm run package
FAQ
Q: Code not updated after F5 debugging?
A: Ensure pnpm run watch is running, then press Ctrl+R in the debug window to reload
Q: No results from SQL execution?
A: Check SQL syntax and view console output at the bottom
Q: Slow loading for large databases?
A: The extension loads data in batches, use pagination for large tables
License
MIT License
Contributing
Issues and Pull Requests are welcome!
- Fork the project
- Create your feature branch (
git checkout -b feature/AmazingFeature)
- Commit your changes (
git commit -m 'Add some AmazingFeature')
- Push to the branch (
git push origin feature/AmazingFeature)
- Open a Pull Request
Acknowledgments
- sql.js - SQLite to JavaScript compiler
- Monaco Editor - The code editor that powers VS Code
- VSCode Extension API
P If this extension helps you, please give it a star!
-��c | -� README
