Savoia Studio
A lightweight but feature-rich desktop database client for PostgreSQL and MySQL. 100% Rust, with a native GPU-rendered UI built on GPUI Kit. No webview.
Free: no trial, no license key, no account.
Download for macOS, Windows or Linux · Website · Documentation
See docs/PLAN.md for the roadmap and docs/adr/ for architecture decisions.
Layout
| Path | What |
|---|
crates/savoia-app | The app binary (savoia-studio): GPUI views, theme, icon assets |
crates/savoia-core | Domain types, connection config + URL import, driver traits, errors; no UI dependency |
crates/savoia-pg | PostgreSQL driver (tokio-postgres, rustls) |
crates/savoia-mysql | MySQL/MariaDB driver (mysql_async, rustls) |
crates/savoia-store | Saved connections (SQLite) and secrets (a user-only 0600 file) |
crates/savoia-tunnel | SSH tunnels (russh) with known_hosts verification |
crates/savoia-transfer | Dump and import: external client tools and the built-in engine |
docs/site | The website: landing page (landing/) and user documentation (mdBook, src/), published to GitHub Pages |
Prerequisites
- Rust stable (
rustup)
- Linux only:
libxkbcommon-dev libxkbcommon-x11-dev libwayland-dev libvulkan-dev libfontconfig-dev libx11-xcb-dev libssl-dev
- Docker, for the test databases
Commands
cargo run -p savoia-app # run the app
cargo build -p savoia-app --release
cargo clippy --workspace --all-targets -- -D warnings
cargo test --workspace
npm run docs # the website and docs on http://localhost:3000, rebuilt on change (needs mdbook)
docker compose up -d --wait # Postgres 17 :54317 (TLS on), MySQL 8.4 :33084, SSH bastion :2222 — all savoia/savoia
Working on the UI
scripts/dev.sh rebuilds and restarts the app whenever a source file changes, then reconnects the data source you used last. Set SAVOIA_DEV_OPEN=schema.table to also reopen that table's data view:
SAVOIA_DEV_OPEN=it_rel.orders scripts/dev.sh
It is a restart, not an in-place hot reload: GPUI has no hot-patching, so window state other than the reconnect and the data view starts fresh. A failed build leaves the running app as it was. brew install watchexec makes it react faster; without it the script polls once a second.
Live tests
Driver, tunnel and UI integration tests talk to the compose services. Without these variables they return early and report as passed, so set them when you want real coverage:
SAVOIA_PG_URL=postgres://savoia:[email protected]:54317/savoia \
SAVOIA_MYSQL_URL=mysql://savoia:[email protected]:33084/savoia \
SAVOIA_SSH_TEST=1 cargo test --workspace
Benchmarks
scripts/bench.sh startup and scripts/bench.sh scroll (with SAVOIA_PG_URL) measure the release budgets in a real window. Results are in docs/benchmarks/.
Sample data
samples/ has a Serie A 2025-26 database for trying the explorer, ER diagram and console by hand. Clubs and stadiums are real (figures approximate); every person is invented. It has 20 clubs, 490 players, 380 fixtures (20 matchdays played, so later scores are NULL), views, a function, a procedure, and 150,000 match_events rows for paging and cancel.
docker exec -i savoia-db-postgres-17-1 psql -U savoia -d savoia < samples/serie_a.postgres.sql # schema serie_a
docker exec -i savoia-db-mysql-8.4-1 mysql -uroot -psavoia < samples/serie_a.mysql.sql # database serie_a
To change the data, edit samples/generate_serie_a.py and run it; it rewrites both files with the same rows.
UI conventions
- Colors come from
crates/savoia-app/src/theme.rs; don't hard-code colors in views.
- Lucide icons beyond the default component set must be added to
crates/savoia-app/src/assets.rs, otherwise they render blank.
- Only
savoia-app depends on gpui-kit. Keep database, dump and storage logic in UI-free crates.
Releasing
Add a changeset to PRs users will notice (npm ci, then npx changeset); merging the generated "Release Savoia Studio" PR tags and builds the release. See docs/RELEASING.md.
License
Licensed under either of MIT or Apache-2.0, at your option.
