Microscope
The most ergonomic way to work with databases.
Search 100k rows in under a second.
curl -fsSL https://zarrasvand.com/install_microscope.sh | shmacOS & Linux installation command
Lightning Fast
Sub 1-second performance for 100k rows with GPU acceleration.
Multi-Format
CSV, SQLite, and Parquet files with seamless folder scanning.
Large Files
Efficiently process files as large as your hard drive allows.
Built With
Rust
DuckDB
React
Tauri
Release Notes
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
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 | Unlimited (Disk-bound) | 10GB+ | ~500MB-1GB | RAM dependent |
| Folder Scanning | ✓ | ✗ | ✗ | ✓ |
Perfect For
Data Engineers
Quickly inspect and validate large Parquet and CSV datasets without writing complex scripts.
Database Admins
Ergonomic management of SQLite databases with lightning-fast search and GPU-accelerated previews.
Analysts
Instant access to data-heavy files with intuitive split-views and smart timestamp detection.