A powerful VS Code extension for viewing, filtering, and exploring SQLite and MongoDB databases with an intuitive interface and smart filtering capabilities.
- SQLite Support: Connect to SQLite database files (.db, .sqlite, .sqlite3)
- MongoDB Support: Connect to MongoDB instances using connection strings
- Smart Filters:
- Numbers: Use operators like
>100,<50,>=10,<=20,10-20(range) - Dates: Filter with
>2024-01-01,<2024-12-31,2024-01-01 to 2024-12-31(range) - Text: Simple substring matching
- Numbers: Use operators like
- Interactive Data Grid:
- Click column headers to sort
- Per-column filtering with search icon
- Pagination for large datasets
- Syntax-highlighted values (numbers, strings, booleans, null)
- Tree View Explorer: Browse databases and their tables/collections in the sidebar
- Persistent Connections: Automatically save and restore database connections
- Auto-Open SQLite Files: Automatically detect and open .db files when clicked
Database Explorer sidebar with connections and table tree view
Interactive data grid with sorting and filtering
Smart filtering for number columns with operators
Date filtering with ranges and comparison operators
Predefined sample queries for quick database exploration
AI-powered natural language query interface
SQL query editor with execution interface
Query results displaying aggregated data
Column-specific filter menu
Available filter types and options
Multi-column sorting capabilities
Install from the VS Code Marketplace:
ext install apertacodex.simple-db
Or search for "Simple DB" in the Extensions view (Ctrl+Shift+X).
- Open the Database Explorer in the VS Code sidebar (database icon)
- Click the database icon (➕) to add a SQLite database
- Click the server icon to add a MongoDB connection
- Or simply open any .db file - it will be added automatically!
- Expand a database connection in the explorer
- Click on a table/collection to view its data
- Click the filter icon (🔍) on any column header to filter:
- For numbers: Type
>100,<50,>=10,10-20, etc. - For dates: Type
>2024-01-01,2024-01-01 to 2024-12-31, etc. - For text: Type any substring to search
- For numbers: Type
- Press Enter or click the 🔍 button to apply the filter
- Click column headers to sort ascending/descending
- Use pagination controls at the bottom to navigate large datasets
Number Filters:
>100- Greater than 100<50- Less than 50>=10- Greater than or equal to 1010-20- Between 10 and 20 (range)!=5- Not equal to 5
Date Filters:
>2024-01-01- After January 1, 2024<2024-12-31- Before December 31, 20242024-01-01 to 2024-12-31- Date range2024-06- Contains "2024-06" (partial match)
The extension stores database connections in VS Code settings under simpleDB.connections.
- sqlite3: SQLite database driver
- mongoose: MongoDB object modeling tool
npm run compile: Compile TypeScript to JavaScriptnpm run watch: Watch for changes and recompile automatically
See CHANGELOG.md for all notable changes.
This project is licensed under the MIT License - see the LICENSE file for details.
Contributions are welcome! Feel free to submit issues and pull requests on GitHub.
If you encounter any issues or have suggestions, please open an issue on GitHub.