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.
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
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 | ✓ | ✗ | ✗ | ✓ |
