Rowwright handbook

Download Rowwright, drag it into Applications and open it. Click New connection, pick your database and fill in the host, port and credentials — or paste a connection URL such as postgres://user:pass@host:5432/app and Rowwright fills the form for you.

Press Test to check the connection, then Save & Connect. Your tables, views, functions and collections appear in the sidebar.

Give each connection a color, an optional group and an environment — Local, Dev, Staging or Prod. Production connections always ask before running destructive statements like DROP, TRUNCATE or an UPDATE without a WHERE clause.

Turn on Read-only mode to block edits and write queries entirely. Passwords, SSH secrets and URIs are encrypted with your macOS Keychain.

In the connection dialog, open SSH Tunnel and enter your bastion host, user and either a private key (default ~/.ssh/id_ed25519) or a password. Rowwright opens a local tunnel and connects through it automatically.

Under SSL / TLS you can require encryption, turn off certificate verification for self-signed servers, and supply a custom CA certificate.

Open a table and double-click a cell (or press Return) to edit it. Edited cells are highlighted and nothing is written until you click Save changes — all pending edits, inserts and deletes are applied in a single transaction. Discard throws them away.

Right-click a cell to filter by its value, set it to NULL, copy rows as JSON or INSERT statements, or delete rows. Editing requires a primary key so Rowwright can target rows precisely.

⌘↵ runs the statement under your cursor (or your selection). ⇧⌘↵ runs the whole script. Multiple statements produce multiple result tabs. Use Explain to see the query plan and Format to tidy your SQL.

Every query is kept in History with its timing and status. Save queries you reuse with ⌘S.

The query tab accepts shell syntax: db.orders.find({ total: { $gt: 100 } }).sort({ placedAt: -1 }), db.users.aggregate([...]), ObjectId("…") and ISODate("…") all work. Collections open in a table view or a JSON view, and documents can be edited as JSON.

Keys are grouped into a tree by :. Filter with patterns like user:*, then open a key to edit its value, change its TTL, rename or delete it. The Console runs any command, one per line.

Open Settings → License & Plan and paste your key. Keys are verified offline. You can start a 14-day Pro trial from the same screen.

Licenses are a one-time purchase and never expire. Each includes a year of updates: Settings shows the date your free updates run until. After that date your license keeps working with every version released before it. To use newer versions, renew for another year and paste the new key you receive.