Projects / OpenRDB Studio

Tools

OpenRDB Studio

A free, open-source desktop SQL client built with Rust, Tauri, React, and TypeScript. The React front end delivers a modern SQL client experience; SQLx powers type-safe, async connectivity and query execution across relational databases.

RustTauriReactTypeScriptSQLx

01 Walkthrough

One short demo and two screens from the product.

Screenshot 01
Screenshot 02

02 Stack layers

Interface

ReactTypeScriptSQL editor UX

Native core

RustTauriTokio

Data access

SQLxPostgreSQLMySQLSQLite

03 Architecture

REQUESTinvoke("run_query", sql)tracing
invokecredsReact UIMonaco · resultsCLIENTTauri IPCCommand bridgeEDGERust CoreConnectionsSVCOS KeychainCredentialsEXTSQLx PoolTokio · asyncSVCPostgreSQLDATAMySQLDATASQLiteDATA

React UI talks to the Rust core through Tauri IPC. SQLx pools connections over Tokio; credentials stay in the OS keychain.

  • Full React/TypeScript front end for a modern SQL client UX
  • SQLx for type-safe async database access in Rust
  • Cross-platform via Tauri with OS keychain credentials

04 Engineering challenges

01

Native feel, web UI

Tauri keeps the binary small and the backend in Rust while the interface stays a modern React app.

02

Type-safe SQL core

SQLx over Tokio gives async, compile-checked database access across PostgreSQL, MySQL, and SQLite.

03

Credential safety

Connection credentials live in the OS keychain, not in app-managed storage or config files.

04

Real connections

Moved from dummy UI data to live database connections for table previews, structure views, and ERDs.

05 Trade-offs & decisions

TaurivsElectron

A fraction of the memory and binary size, plus a Rust-native backend for the SQL core.

SQLxvsHeavy ORM

Type-safe raw SQL fits a database tool better than an abstraction that hides the SQL.

Desktop appvsWeb app only

Local connectivity to databases behind firewalls, without proxying credentials through a server.