rimor.dev

rimor

Latin: I probe, I search thoroughly.

A terminal workbench for PostgreSQL, MySQL, SQL Server and SQLite. Browse the catalog, write SQL in tabs and scroll through millions of rows without leaving the keyboard.

go install rimor.dev/cmd/rimor@latest
theme
This is the real interface, drawn by rimor itself.

What it does

Explorer
Your connections and their catalog as a tree: databases, schemas, tables, views, functions, indexes, foreign keys and columns with their types. Each level loads when you open it, and empty schemas stay out of the way. Press / and the tree shrinks to what matches as you type.
Query tabs
Each tab knows where it runs, a connection and a database, and shows it at the bottom. Open a tab from anything in the tree and it starts there. Each runs on its own connection, so USE, temp tables and open transactions carry over; a tab says when it is inside a transaction, and closing it asks whether to commit or roll back. Tabs save to .sql files, and unsaved work is still there the next time you start.
AI agents
Ask Claude Code, in another terminal, for the orders whose delivery date has passed: it reads your catalog and opens the query in a new tab for you to review. It never runs anything or sees credentials. Chasing a slow server? Press alt+a to share a tab's results, and the agent writes each query, you run it, and it reads the rows: no copying either way. One command sets it up: claude mcp add rimor -- rimor mcp.
Results
Rows appear within milliseconds and keep streaming in the background, stored compactly enough for millions of them. Scroll by row and by column; esc stops fetching and keeps what arrived. A failure shows the database's own message and code, with a caret where it points in your SQL. A SQL Server batch keeps every result and its messages: PRINT, statistics, row counts, errors in place. e exports a result as CSV, JSON, SQL INSERTs or Markdown, every row of it if you like.
Editing
Open a cell to see its whole value, copy it, or change it. rimor shows the UPDATE it will run, touches only that row, and refuses if someone changed it since you loaded it. JSON gets its own editor, and invalid JSON is never sent.
Read-only connections
Mark a connection read-only and writes are refused: by the server on PostgreSQL and MySQL, by the engine on SQLite, by rimor on SQL Server.
Editor
Syntax highlighting in each database's own dialect, selection, undo, clipboard and indentation that follows the line above.
Scripts
Press s on a table, view, column or routine for ready-made SQL in its own dialect: the first rows, an insert or update to fill in, a call with every parameter. It opens in a new tab and runs when you run it; until you fill it in, it changes nothing. A procedure, view or trigger opens as its definition: edit it, run the tab, and rimor applies it the way the engine allows, without overwriting someone else's change.
Themes
Dark, light, or your terminal's own colours. On Omarchy rimor follows the system theme; elsewhere it matches your terminal's background.
Layout and keys
Drag the borders between panes, or resize from the keyboard; any pane goes full screen with alt+f. F1 shows the keys that apply where you are, and every shortcut can be remapped.

Install

Download

A single binary with no other dependencies, for Linux, macOS and Windows on amd64 and arm64: get the archive for your system from the latest release. On Arch Linux it is in the AUR, built from source or prebuilt.

$ yay -S rimor      # or rimor-bin

With Go

With Go 1.27 or newer, install it, or clone the repository and build it; the binary lands in the current folder.

$ go install rimor.dev/cmd/rimor@latest
$ git clone https://github.com/alchemy/rimor
$ cd rimor && go build ./cmd/rimor

Press a in the explorer to add a connection, or give one on the command line for a session that is saved nowhere: rimor ./app.db, rimor postgres://me@host/db. Settings live in ~/.config/rimor/config.toml, written with every default on first run. Every few hours rimor asks GitHub whether a newer release is out, and says so above the query; check_updates = false turns that off.