rowan

Rowan

A desktop database client for PostgreSQL, MySQL and SQLite.

Every connection opens read-only at the database level. AI agents connect over MCP, and their writes wait for your approval.

Rowan runs on Linux, macOS and Windows.

databases
PostgreSQL, MySQL, SQLite
agents
MCP over HTTP and stdio
built with
Go and Wails
A video of Rowan with no sound. The captions say: Every connection opens read-only. Completion for tables after FROM and JOIN. Columns for each alias in the statement. Keywords in the case that you type. Ctrl Enter runs the query. A write does not run until you unlock the connection. Agents connect over MCP. Their writes wait for you. You see the reason, the SQL and the rows that change. Rowan runs the write only after you approve it. Two layouts: a search surface or a full workspace.

Work in the layout that fits the task

Rowan has two layouts. Both use the same connections, safety model and dialogs.

To switch the layout, click the layout button in the title bar. You can also press Ctrl+K and choose the switch command. On macOS, press ⌘K.

The workspace layout in the dark theme. Connection tabs run across the top. The SQL editor sits above the result grid. The row inspector and the agent feed fill the right column.

Workspace

Connections are tabs at the top. The editor and the grid stack in the center. A row inspector and a live agent feed sit on the right.

The inspector shows the selected row and the tables that reference it. To open the row that a foreign key points to, click its value.

Corners are square and the font is mono throughout.

Parts of the workspace layout
AreaContents
Title barConnection tabs, search, the layout and theme buttons, the lock state and the MCP status
LeftA rail for tables, the MCP server and the activity log, then the table list with a filter
CenterThe SQL editor above the result grid
RightThe row inspector and the live agent feed
The command layout in the light theme. The search orders refunded lists the matching tables and shows a live preview of the refunded orders.

Command

There is no permanent sidebar. You open everything from one search surface with a live preview. This layout suits people who visit a database occasionally.

The first word picks a table. The other words become filters. The preview runs while you type.

Search input and the filter that Rowan writes
InputFilter
orders refundedstatus = 'refunded'refunded is a sampled value of status.
orders 10442id = 10442A number filters the primary key.
orders status:shippedstatus = 'shipped'
orders total_cents>5000total_cents > 5000
customers email~acmeemail contains acme
orders shipped_at:nullshipped_at IS NULL
  • TabWrite the filters in column:value form, so you can edit them.
  • EnterOpen the table.
  • Ctrl+EnterOpen the query in the editor.

Write SQL with completion that reads your schema

The editor completes tables, columns, keywords and functions while you type. The list depends on the position of the caret in the statement.

What the completion list shows
Caret positionThe list shows
After FROM, JOIN, UPDATE or INTOTables and views
After SELECT, WHERE, ON, SET or ORDER BYThe columns of the tables in the statement
After alias. or table.The columns of that table
After INSERT INTO orders (Only the columns of orders

When two tables in the statement have a column with the same name, Rowan inserts the column with its alias, such as o.id. Keywords follow the case that you type. A function inserts with its parentheses.

  • Tab or EnterInsert the selected item.
  • Ctrl+SpaceOpen the list at the caret.
  • EscClose the list.

When the editor gets focus, Rowan loads the columns of all tables in one catalog query. If the schema has more than 20,000 columns, Rowan loads the columns of a table when a statement names it.

The SQL editor with the completion list open after c. in a WHERE clause. The list shows the columns of the customers table, which has the alias c.

Every connection opens read-only

Rowan sets read-only mode in the database session, not only in the UI. A write fails in the database even if a check in Rowan misses it.

To write, unlock the connection for a fixed time. Rowan then relocks it.

Rowan classifies each statement before it runs
StatementClassLocked connectionUnlocked connection
SELECT * FROM orders WHERE status = 'refunded' read Runs Runs
UPDATE orders SET status = 'shipped' WHERE id = 10442 write Blocked Runs
UPDATE orders SET status = 'shipped' destructive Blocked Asks for confirmation. It changes every row in the table.
DROP TABLE invoices destructive Blocked Asks for confirmation. A drop cannot be undone.
SET default_transaction_read_only = off write Blocked Runs. Rowan then closes the session.
Rowan blocks an UPDATE on the read-only acme-prod connection. The message says to unlock writes to run it, with an Unlock writes button.
Read-only at the database level
The read pool sets default_transaction_read_only on PostgreSQL, transaction_read_only on MySQL and query_only on SQLite.
Writes need an unlock
A write on a locked connection does not reach the database. Unlock for 5, 15, 30 or 60 minutes, or until relaunch. Rowan then relocks the connection and closes its write pool.
Production connections ask for the name
To unlock a production connection, type the connection name.
Destructive statements ask for confirmation
This applies to DROP, TRUNCATE, and DELETE or UPDATE without WHERE.
Statements that lift read-only mode count as writes
Examples are SET default_transaction_read_only = off, BEGIN READ WRITE and PRAGMA query_only = 0.
Session state does not leak
When a script runs SET, USE or its own BEGIN, Rowan closes that connection after the script. The connection does not go back to the pool.

Agents query your data. You approve their writes.

AI agents connect to Rowan over MCP. You choose the connections and the tables that agents can see.

With approvals on, a write from an agent waits in the approval queue until you approve or deny it.

The approval queue with 3 agent writes. Each entry shows the agent, the reason, the SQL statement and the rows that change, with Deny and Approve buttons.
reason
The reason that the agent gave for the write.
sql
The statement that the agent wants to run.
impact
The number of rows that change, counted with the read pool. For updates and inserts, the old and new values. Rowan never runs a write to compute this preview.

Connect an agent

Rowan serves MCP over Streamable HTTP on 127.0.0.1:7421/mcp. Every request needs the bearer token in ~/.config/rowan/mcp-token.

Rowan refuses requests that carry an Origin header. This blocks web pages and DNS rebinding.

For a client that speaks only stdio, add the bridge. The bridge forwards each call to the running app.

shell
claude mcp add rowan -- /path/to/rowan mcp --stdio

Replace /path/to/rowan with the path to the Rowan binary. The MCP server view in Rowan shows a snippet to copy for Claude Desktop, Claude Code, Cursor and plain HTTP.

The MCP server view. It lists the connected clients, a configuration snippet for each client, the agent policy for each connection and the tools that agents can call.

Tools

MCP tools and what they do
ToolWhat it does
list_connectionsLists the connections that you shared with agents.
list_tablesLists the tables in the allowlist, with row counts.
describe_tableReturns columns, keys, indexes and references.
queryRuns one read-only statement. Results stop at the row limit.
explainReturns the plan. Rowan refuses ANALYZE.
executeRuns one write on a read-write connection. With approvals on, the call waits for you.

Policy for each connection

  • Shared or hidden
  • Read-only or read-write
  • Approve writesAlways on for production connections.
  • Row limit
  • Table allowlist

Rowan blocks a statement that names a table outside the allowlist. Rowan does not check views that read hidden tables. To protect that data, use database grants.

Build from source

You need Go 1.27, Node 20 or later and the Wails v2 CLI. On Linux, you also need GTK 3 and WebKitGTK 4.1.

  1. Clone the repository.
  2. In the repository root, build the app.
  3. Start the app.

On macOS and Windows, leave out -tags webkit2_41. For live reload during development, run wails dev -tags webkit2_41.

On first launch, Rowan writes ~/.config/rowan/config.toml and a sample SQLite database. The sample has customers, products, orders, order items and invoices.

shell
wails build -tags webkit2_41./build/bin/rowan