← All projects

PostgreSQL desktop workspace · Case study

Rowberry

A little clarity for your PostgreSQL. A free, open-source desktop app for browsing tables, writing SQL, and exploring nested JSON. Local-first, with careful editing and draft recovery. Currently in early development.

  • Electron
  • React
  • TypeScript
  • PostgreSQL
Visit project website ↗

The problem

Working with PostgreSQL often means moving between connections, SQL queries, table data and nested JSON. I wanted a focused desktop workspace that brings these tasks together and keeps workspace data local, without requiring an account or a hosted service.

My contribution

I’m the sole developer of Rowberry, an open-source PostgreSQL desktop app. I handle the design, development and technical decisions across the Electron application, React and TypeScript interface, schema navigation, tabbed SQL workspace and JSON inspection and editing. I also create and maintain the branding, website and documentation.

Key decisions

I focused on PostgreSQL first rather than spreading the initial release across multiple database engines. Electron provides the desktop shell, React and TypeScript power the interface, and Monaco Editor provides the SQL editing surface. Database access runs in a separate worker process behind a validated bridge, with a sandboxed renderer and verified TLS by default. Table browsing is paged, and eligible table and JSON edits use stable row identities and optimistic conflict checks. Connection metadata, saved queries and recoverable drafts stay on the device; remembered passwords use the operating system’s credential store when available.

Results

The current app includes saved connections, schema navigation, paged table browsing, multiple SQL tabs, completion, query cancellation and explicit transaction controls. JSON workflows include inspection, search, editing and previews before saving. Rowberry is still in early development: platform qualification, signing and installation checks remain outstanding. It can currently be tried from source; the website and repository document the supported workflows and remaining release work.

A look at the app

Rowberry in dark mode, with PostgreSQL tables in the sidebar, a SQL editor, and query results with an Inspect JSON action.
Rowberry — application screenshot.
Let’s talk about your project ↗