A simple native desktop app to browse and query your MySQL and PostgreSQL databases. Built with Rust and egui for a fast, responsive, and lightweight experience.
Grab the latest pre-built binary from the Releases page. No installer needed — just download and run.
Note: Currently only tested on Windows. Other platforms may work but are untested — if you run into issues please open an issue.
Connection manager
- PostgreSQL and MySQL support
- Save, duplicate, and delete connections
- Color labels and group organisation with drag-and-drop reordering
- SSH tunnel support — password, key file, or SSH agent auth
- Test connection button with real round-trip latency
Data explorer
- Collapsible sidebar tree — databases → schemas → tables with row counts
- Tabbed interface with right-click tab actions (close, close others, close to left/right)
- Data tab — paginated row grid with row selection and copy to clipboard
- Structure tab — column definitions with PK / FK / nullable annotations
- Inline data editing with a pending-changes review before commit
- SQL query editor with syntax highlighting and Ctrl+Enter to run
UI
- Dark and light themes
- Compact / Regular / Comfy row density
- Structured logs with automatic daily rotation
App settings (theme, density, sidebar width) are stored alongside the connection database:
| Platform | Path |
|---|---|
| Windows | %APPDATA%\yssv\ |
| macOS / Linux | ~/.config/yssv/ |
Connections database: connections.db in the folder above — a plain SQLite file. You can back it up or copy it between machines.
| Platform | Path |
|---|---|
| Windows | %APPDATA%\yssv\logs\yssv.log.YYYY-MM-DD |
| macOS / Linux | ~/.config/yssv/logs/yssv.log.YYYY-MM-DD |
Log files older than 7 days are deleted automatically on startup. Override with YSSV_LOG_KEEP_DAYS=30.
Log level (default info in release builds, debug in dev):
# Linux / macOS
YSSV_LOG=debug ./yssv
# Windows PowerShell
$env:YSSV_LOG = "debug"
.\yssv.exeRequirements: Rust 1.80+ via rustup. No system C libraries needed — TLS uses pure-Rust Rustls.
Linux only — install these system packages first:
sudo apt install libxcb-render0-dev libxcb-shape0-dev libxcb-xfixes0-dev \
libxkbcommon-dev libssl-dev# Clone
git clone https://github.com/aodihis/yssv.git
cd yssv
# Run in development mode
cargo run
# Build a release binary
cargo build --release
./target/release/yssv # Linux / macOS
.\target\release\yssv.exe # Windows# Unit tests — no database required, fast
cargo test --lib
# Integration tests (UI smoke tests — no database required)
cargo test --test integration
# All tests including database tests — requires live PostgreSQL and MySQL
export YSSV_TEST_PG_URL=postgres://user:pass@localhost/testdb
export YSSV_TEST_MYSQL_URL=mysql://user:pass@localhost/testdb
cargo test -- --include-ignoredSee LICENSE.