Data Helper Application

Cross-platform desktop database workbench — connect six database engines, run queries, explore schemas, and manage Docker-backed instances from one Tauri app.

Repository

Cross-platform desktop database workbench — connect six database engines, run queries, explore schemas, and manage Docker-backed instances from one Tauri app.

Overview

Data Helper Application is a SvelteKit + Tauri desktop client for day-to-day database work. Instead of juggling separate GUIs per engine, you keep connections, query files, schema diagrams, and Docker lifecycle controls in one workspace. Local app state lives in SQLite via Drizzle; real database traffic goes through Rust connection modules on the Tauri side.

Supported databases

Native connection modules cover six engines used across student and professional projects:

PostgreSQL
MySQL
MariaDB
Microsoft SQL Server
MongoDB
SQLite

Workspace

The coding workspace pairs a file tree of saved query collections with Monaco-based query blocks. You can connect or remove datasources, share connection details when collaborating, and open SQL or NoSQL ER diagrams rendered with D3 to inspect relationships visually before changing schemas.

Docker dashboard

When databases run in containers, the Docker dashboard lists images and containers, supports pull/build flows, start/stop/restart, and opens a system terminal for container shells — useful for spinning up local Postgres or MySQL without leaving the app.

In-app documentation

Welcome, feature, user manual, maintenance, about, and release-note panels ship inside the app so operators can learn workflows without a separate docs site.

Stack

SvelteKit (static adapter) + Svelte 5 UI · Tauri 2 (Rust) for OS integration and DB drivers · Drizzle ORM + libSQL for local app data · Monaco Editor for query editing · xterm for embedded terminals · daisyUI + Tailwind CSS · Optional LangChain / OpenAI hooks for assisted workflows · Desktop updater endpoints for release builds across supported platforms