Opens in under a second, never freezes on a slow query, and shows you exactly what will change before you commit.
Windows 10 & 11 · PostgreSQL · Free trial on the Microsoft Store
Your windows, workspaces and tabs come back where you left them.
The UI thread never waits on the network or the database. Keep working, or cancel, at any time.
Edits wait in a change set. See the exact SQL first, then commit it in one transaction.
Data grid
Rowan pages by primary key, so jumping to row four million of a table is as quick as row one. Sort, filter and inspect without writing SQL.
Editing
Cell edits, new rows, duplicates and deletes are staged in a change set and tinted in the grid. Nothing reaches the server until you commit.
3 pending changes
| id | Column | Before | After |
|---|---|---|---|
| 3 | status | delivered | refunded |
| 5 | total | 34.62 | 249.00 |
| 7 | note | NULL | called back Tuesday |
BEGIN;-- public.orders: 3 updatedUPDATE "public"."orders" SET "status" = $1 WHERE "id" = $2;-- $1 = 'refunded', $2 = '3'UPDATE "public"."orders" SET "total" = $1 WHERE "id" = $2;-- $1 = '249.00', $2 = '5'UPDATE "public"."orders" SET "note" = $1 WHERE "id" = $2;-- $1 = 'called back Tuesday', $2 = '7'COMMIT;SQL editor
Suggestions come from a copy of your schema Rowan keeps in memory, so they never wait on the server. Results stream in a page at a time.
Keyboard first
Change any of them in Settings. Open Anything finds a table, view, function, saved query or command from a few letters of its name.
Everything else
The nine areas Rowan covers, each one described in full in the user guide.
Groups, tags and status colors, every SSL mode, SSH tunnels, and import from a postgresql:// URL.
Tabs, split panes and several windows, with sidebars for items, saved queries, history and row detail.
Smooth paging through millions of rows, multi-column sort, filters, pinned columns and Quick Look.
Inline edits, inserts and deletes staged in a change set, with undo, redo and a preview of the SQL.
Columns, keys, indexes, triggers, views, functions and schemas, staged and committed like data.
Context-aware autocomplete, streaming results, query parameters, Vim key bindings and saved queries.
Safe Mode levels per connection, read-only connections, a statement timeout and a passcode lock.
Process list, user management, ER diagram, backup and restore, import, export and a Metrics Board.
Light and dark themes that follow Windows, accent colors, two densities and a keymap you can rebind.
Safety
Rowan protects you from the mistakes every database user makes once: a write to the wrong server, an UPDATE without a WHERE, a query that never ends.
Five levels, from sending silently to asking for the database password before a statement goes out.
Rowan turns off every edit, and the server itself refuses writes for the session.
Rowan stops and asks before a statement changes every row in a table.
Set on every connection, 30 seconds unless you change it, so a runaway query can't hold locks forever.
Covers every window when you step away. Queries keep running behind it.
Saved in Windows Credential Manager, never in Rowan's own files, or asked for every time.
Rowan shows a new server's fingerprint first, and won't connect if a saved key changes.
Tables without one open read-only. Rowan never guesses a row's identity.
Tag a connection Production and it gets a red strip under the toolbar and Safe Mode 2, which asks for the password before anything but a read.
Principles
Every connection has its own worker thread that owns the libpq connection. Jobs go down and row batches come back, so the window always responds.
Data and structure edits go into a change set. Commit runs them inside one transaction as parameterized statements, and rolls back on any error.
Rowan only edits rows it can identify for certain. It never guesses a row's identity.
Colors, sizes, spacing, radii and fonts come from a single theme, which generates the style sheet and palette for both light and dark.
Quality
Before the installer phase, Rowan went through a full QA pass: code reviews, screenshot sweeps at every window size, theme and scale, and hands-on testing. Every issue is in the bug tracker with its severity and status.
Fixes come with a regression test wherever one is practical, and each batch of fixes was reviewed before it was closed.
| Level | Meaning | Issues logged |
|---|---|---|
| P0 | Data loss, wrong SQL committed, a safety feature bypassed, or the app unrecoverable | 10 logged |
| P1 | A feature broken or clearly wrong, or a common frustration | 35 logged |
| P2 | An edge-case bug, visible inconsistency, or rough resize behavior | 129 logged |
| P3 | Polish | 181 logged |
Platform
Rowan is in pre-release, at version 0.1.0. It supports PostgreSQL only; a macOS version from the same codebase is planned.
On 64-bit (x64) PCs, drawn crisply at 100%, 150% and 200% scaling, and across screens with different scaling.
Any version the PostgreSQL project still supports, on your computer, your network, in the cloud or through an SSH tunnel.
Light and dark themes that follow Windows, accent colors, Comfortable and Compact densities, and a translucent Mica sidebar on Windows 11.
A free trial with every feature. If you buy, your connections, saved queries and settings stay as they were.
Install the free trial from the Microsoft Store, connect to a server, and open a table.
Pre-release · v0.1.0 · Windows 10 & 11