Microscope
The most ergonomic way to work with databases. Searching 100k rows in under 1s.
curl -fsSL https://zarrasvand.com/install_microscope.sh | shLightning Fast
Sub 1-second performance for 100k rows with GPU acceleration
Multi-Format Support
CSV, SQLite, and Parquet files with seamless folder scanning
Large File Handling
Efficiently process files as large as your hard drive.
Release Notes - Version 1.0.0
Foundation & Architecture
- •Migrated from WASM DuckDB to Rust backend for improved performance and reliability
- •Streamlined backend focused solely on DuckDB with Parquet/CSV/JSON support
- •Custom titlebar with platform-specific window controls (macOS/Windows/Linux)
- •Tabbed workspaces with context management for handling multiple files
- •Session persistence: store and restore workspace state across restarts
Query & Data Features
- •SQL autocomplete using CodeMirror 6
- •Split-view implementation for better screen utilisation
- •Automatic timestamp detection and formatting with epoch support
- •Column width management with intuitive drag-to-resize
- •Tab key support for autocomplete acceptance
File Management
- •File and folder change detection with auto-refresh on filesystem changes
- •Recent files feature with quick access modal
- •File associations for Parquet files (double-click to open)
- •Custom tooltips displaying full file paths with smart truncation
UI/UX Enhancements
- •Black theme with improved colour coherency and reduced visual clutter
- •Coherent modal styling across the application
- •Improved row readability with optimised heights
- •Tab truncation from the left for better context
Stability & Performance
- •Fixed DuckDB panic when handling infinite values in Parquet files
- •Resolved race conditions in workspace tab management and loading
- •Unified file state management with single source of truth
- •Comprehensive component tests for DataTable, DirectoryPicker, and modals
Feature Comparison
| Feature | Microscope | DBeaver Community | Beekeeper Studio | Jupyter + pandas |
|---|---|---|---|---|
| CSV Support | ✓ | ✓ | ✓ | ✓ |
| SQLite Support | ✓ | ✓ | ✓ | ✓ |
| Parquet Support | ✓ | ✓ | Limited | ✓ |
| Performance | Sub 1s (100k rows) | Moderate | Poor | Variable |
| GPU Acceleration | ✓ | ✗ | ✗ | Limited |
| File Size Handling | As large as fits on hardrive | 10GB+ | ~500MB-1GB | RAM dependent |
| Folder Scanning | ✓ | ✗ | ✗ | ✓ |
