winget install --id=LeonAchteresch.l8db -e l8db is a fast, native desktop client for PostgreSQL and other databases. It covers table browsing with filtering and inline editing, schema inspection, a Monaco-based SQL editor with history and saved queries, EXPLAIN visualization, ER diagrams, roles and privileges, partitioning, logical replication, sessions and locks, SSL/TLS per connection, SSH tunnels and OS keychain secrets.
A fast, native desktop client for PostgreSQL and other database families — built with Tauri v2, React 19, and Rust.
Features depend on the selected database family and installed driver. The list below describes the PostgreSQL feature set; see the provider matrix and contributor guide for other products, capabilities and driver requirements.
EXPLAIN and EXPLAIN ANALYZE rendered as a collapsible plan tree with costs and timingsFROM/JOIN get warning markers (CTE-aware)pg_stat_activity with cancel/terminate, plus lock monitordisable, prefer, require, verify-ca, verify-full per connection (OS certificate store)~/.ssh/config); database TLS follows the selected SSL mode. See docs/ssh-network.md| Layer | Technology |
|---|---|
| Shell | Tauri v2 (Rust backend) |
| Frontend | React 19 · TypeScript · Vite |
| Routing | TanStack Router |
| Data | TanStack Query |
| UI | shadcn/ui · Tailwind CSS v4 |
| Editor | Monaco Editor |
| DB | tokio-postgres · bb8 connection pool |
bun is required — tauri.conf.json hardcodes it)cargo install tauri-cli --version "^2"bun install
bun run tauri dev
The app opens automatically. The Vite dev server runs on port 1420 (strict).
bun run tauri build
Outputs an installer / app bundle in src-tauri/target/release/bundle/.
src/
features/ # Feature modules (one view component per feature)
shell/ # App chrome: layout, header, sidebar, tab bar, transaction panel
table/ # Table & view browser (data, columns, indexes, triggers)
query/ # SQL query editor
alter-table/ # Column management (add / alter / drop)
sequences/ # Sequence listing and editing
extensions/ # Extension management
functions/ # Function/procedure browser
triggers/ # Trigger viewer
er-diagram/ # ER diagram canvas
users/ # Roles & privileges
settings/ # App settings
home/ # Home / overview
components/ui/ # Shared shadcn primitives
lib/
db.ts # Tauri invoke() bridge (all commands)
queries.ts # TanStack Query hooks
connections.ts # Zustand connection store (persisted)
settings.ts # Zustand settings store (persisted)
transactions.ts # Transaction state
routes/ # TanStack Router file routes (thin wrappers)
src-tauri/src/
db/
mod.rs # DatabaseAdapter trait + shared types
postgres.rs # PostgreSQL implementation
commands.rs # #[tauri::command] handlers
pool.rs # bb8 connection pool management
transaction.rs # Transaction state management
lib.rs # Tauri builder, plugin init, command registration
main.rs # Entry point
invoke() calls are centralized in src/lib/db.ts. TypeScript types mirror Rust structs — keep them in sync.DatabaseAdapter trait in src-tauri/src/db/mod.rs is the extension point for additional DB engines.src/routes/ are thin: they wire createFileRoute to feature views. Route tree is auto-generated into src/routeTree.gen.ts — do not edit it manually.localStorage under key l8db.connections.postgres-native-tls (OS certificate store) with per-connection ssl_mode.fetch_table_rows uses the configurable page size from settings (default 100). Builder-generated filters are validated server-side; raw SQL filter mode sends allow_raw=true.cargo check and cargo clippy in src-tauri/ before committing Rust changes.npx tsc -p tsconfig.app.json --noEmit to typecheck the frontend.Data transfer behavior, limits and benchmarks: data-transfer.md.
Backup, restore and dump tools: backup.md.
Reproducible database and browser checks: integration-tests.md.
Performance tests, workload replay and l8db --benchmark: performance.md.
Production configuration: .github/PRODUCTION.md.
CHANGELOG.md tracks user-facing changes (Keep a Changelog).
Releases: every push to main auto-publishes installers for macOS (Universal DMG), Windows (MSI/NSIS), and Linux (deb/AppImage) plus latest.json for the in-app auto-updater — version (..) and changelog are generated from Conventional Commits. Full runbook: .github/RELEASING.md.
OS package managers (Homebrew, winget, AUR, Flatpak): templates in packaging/, guide in packaging/README.md.
SECURITY.md describes supported versions and how to report vulnerabilities.
l8db is open source under the Apache License 2.0. See NOTICE for attribution.