Skip to content

Edit your database like a spreadsheet. Commit it like code.

Rowan is a desktop client for ten databases, from PostgreSQL and MySQL to MongoDB, Redis and Cassandra. Change rows in the grid, read exactly what will run, then commit.

Free to use, no account. Pro is €20, once.

Close-up of the books table in Rowan: a changed price and stock marked as staged, a row struck through, and a Review 3 changes button.

Every change is shown as SQL before it runs.

Edits in the grid are staged, not saved. A changed cell gets a corner mark, a deleted row is struck through, a new row has a green edge. When you are ready, Rowan shows the statements it will run.

  1. 1Change values, add rows, delete rows. Nothing has touched the database yet.
  2. 2Read the exact DELETE, UPDATE and INSERT statements, keyed by primary key.
  3. 3Commit them in one transaction. If one fails, none of them stick.
The books table in Rowan with three staged edits: a changed price and stock, marked with a corner, and a deleted row struck through

Ten engines, one window.

SQL databases get SQL; MongoDB gets shell commands, Redis gets redis-cli commands, Cassandra gets CQL. Paste a connection URL and Rowan fills in the form, and private servers are reached through an SSH tunnel.

  • Pg

    PostgreSQL

    tested with 17

  • My

    MySQL

    tested with 8.4

  • Ma

    MariaDB

    tested with 11

  • Sq

    SQLite

    any .db file

  • Ms

    SQL Server

    tested with 2022

  • Or

    Oracle

    tested with 23ai

  • Cr

    CockroachDB

    tested with 26.4

  • Mo

    MongoDB

    tested with 8

  • Re

    Redis

    tested with 8

  • Ca

    Cassandra

    tested with 5

Safe mode dialog: Run 1 statement that changes data? Safe mode is on for Shop production. The UPDATE statement is listed above a Run on Shop production button.

Calm on the database you are afraid to touch.

  • Safe mode asks before any statement that changes data or schema, and lists the ones that do. It switches on by itself for connections you tag Production.
  • Read-only connections refuse every write, from the grid and from the editor.
  • Environment tags: Local, Development, Staging, Production, in words and colour, always in the title bar.
  • Passwords stay encrypted by the system keychain, and never leave your computer.

The rest of what you open a database client for.

A SQL editor that knows your schema

Autocomplete for tables and columns, one-key formatting, ⌘↵ runs the statement under the cursor, several result sets side by side, errors that say which statement failed. Every run lands in History.

The SQL editor with a query that ranks customers by money spent, and its 50 result rows in a grid below

ER diagram Pro

Every table, key and relation in a schema, laid out for you.

An ER diagram of the bookshop schema: customers, orders, order_items, books and authors joined by their foreign keys

AI SQL assistant Pro

Ask in plain words, get SQL for this engine in the editor. Uses your own Anthropic key and sends column names, never rows.

Users and roles

See every user and what it may do. Pro creates, drops and re-passwords them.

Running queries

Watch what is running right now and stop a runaway query (Pro).

Go to anything

⌘K finds a table, a view, a connection or a command.

History and saved queries

Search everything you ran. Save the queries you run every week.

Import and export

Tables or results to CSV, JSON and SQL inserts. CSV import in Pro.

Structure at a glance

Columns, types, defaults, indexes and foreign keys, plus the CREATE statement.

Free for good. €20 once for everything.

No subscription and no account. Pro is a licence key you paste into the app.

Rowan Free

€0forever

Every engine, editing with SQL review, the SQL editor, SSH and Safe mode.

Rowan Pro

€20once, lifetime licence

No limits, plus ER diagram, AI SQL, user management, CSV import and query control.

Buy Pro · €20

Secure checkout by Polar. Your key appears right after paying. 14-day refund, see the terms.

What Free and Pro include
FreePro
All ten engines, SQL and NoSQLYesYes
Edit rows with a SQL review before commitYesYes
SQL editor, formatting, autocomplete, historyLast 30 runsUnlimited
SSH tunnels, SSL, Safe mode, read-onlyYesYes
Export to CSV, JSON and SQLYesYes
Saved connections3Unlimited
Tabs open at once3Unlimited
Filter conditions on a table1Unlimited
ER diagram—Yes
AI SQL assistant (your own Anthropic key)—Yes
Create and drop users, change passwordsView onlyYes
CSV import—Yes
Stop running queriesView onlyYes

Questions

Open your first database in a minute.

Download, drag to Applications, paste a connection URL. Rowan Free has no time limit.

What Pro adds
Rowan's start window listing five saved connections: Postgres, MySQL production, SQLite, SQL Server and a read-only MariaDB replica, each with its environment tag