l8db
A fast, native desktop client for PostgreSQL and other database families — built with Tauri v2, React 19, and Rust.
Potencialize seu agente
Instalação do publicador. Não é um endpoint do PlugMCP.
Host a copy with our keys and logs.
Ainda não há uma versão empacotada no registro. Siga o README do repositório.
URL remota ou um comando na sua máquina? Como as duas instalações diferem
Rodar no PlugMCP
A new server you create. It is not this listing's official endpoint. Use the publisher install when you want their URL and their credentials.
AbrirDo publicador
A fast, native desktop client for PostgreSQL and other database families — built with Tauri v2, React 19, and Rust.
Fast, native desktop database client for PostgreSQL, ClickHouse, Oracle and more. Built with Tauri v2, React 19 and Rust. Query editor, table browser with inline editing, ER diagrams, EXPLAIN plans, SSH tunnels, OS keychain secrets and a built-in MCP server.
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.mdbun 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 publishes the stable release marked "Latest"; every push to canary publishes a vX.Y.Z-canary.N pre-release without any guarantee. Both ship installers for macOS (Universal DMG), Windows (MSI/NSIS) and Linux (deb/rpm/AppImage) plus latest.json for the in-app auto-updater, which follows the update channel chosen in the app (Stable by default). Versions and changelogs 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.
Fast, native desktop database client for PostgreSQL, ClickHouse, Oracle and more. Built with Tauri v2, React 19 and Rust. Query editor, table browser with inline editing, ER diagrams, EXPLAIN plans, S
Visão geral
Fast, native desktop database client for PostgreSQL, ClickHouse, Oracle and more. Built with Tauri v2, React 19 and Rust. Query editor, table browser with inline editing, ER diagrams, EXPLAIN plans, SSH tunnels, OS keychain secrets and a built-in MCP server.
Ferramentas
Ainda não há lista de ferramentas. Servidores remotos recebem uma após a primeira verificação de saúde.
Perguntas frequentes
Copie nesta página a configuração stdio para Cursor, Claude Desktop, Claude Code ou VS Code. Ela usa a instalação do publicador, não um proxy do PlugMCP.
Este registro não lista nenhuma variável de ambiente obrigatória.
L8db roda localmente via stdio.
Última verificação: 2026-10-28. Fast, native desktop database client for PostgreSQL, ClickHouse, Oracle and more. Built with Tauri v2, React 19 and Rust. Query editor, table browser with inline editing, ER diagrams, EXPLAIN plans, SSH tunnels, OS keychain secrets and a built-in MCP server.