rimor

Latin: I probe, I search thoroughly.

A terminal workbench for PostgreSQL, 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

╭─ 1  Explorer ────────────╮╭─ 2  ● orders.sql ─ ● best-customers.sql ─────────────────────────────────────────╮
│   + New connection       ││  1  -- Best customers this month                                                 │
│                          ││  2  SELECT c.name, c.city,                                                       │
│ ▾ ◈ shop  sqlite         ││  3         count(o.id)  AS orders,                                               │
│   ▾ ▫ Tables  2          ││  4         sum(o.total) AS spent                                                 │
│     ▾ ▦ customers        ││  5  FROM customers c                                                             │
│       ▾ ▫ Columns  4     ││  6  LEFT JOIN orders o ON o.customer_id = c.id                                   │
│           ⚷ id  INTEGER  ││  7  GROUP BY c.id                                                                │
│           · name  TEXT   ││  8  ORDER BY spent DESC NULLS LAST                                               │
│           · city  TEXT   ││                                                                                  │
│           · since  DATE  ││                                                                                  │
│       ▸ ▪ Indexes        ││                                                                                  │
│     ▸ ▦ orders           │╰─ ◈ shop ─────────────────────────────────────────────────────────────────────────╯
│   ▸ ▪ Views              │╭─ 3  Results ─────────────────────────────────────────────────────────────────────╮
│   ▸ ▪ Indexes            ││   name             city       orders  spent                                      │
│   ▸ ▪ Triggers           ││──────────────────────────────────────────────────────────────────────────────────│
│                          ││ 1 Grace Hopper     Arlington       2    995                                      │
│                          ││ 2 Alan Turing      Wilmslow        1    310                                      │
│                          ││ 3 Ada Lovelace     London          2  155.5                                      │
│                          ││ 4 Frances Allen    Peru            1   77.7                                      │
│                          ││ 5 Barbara Liskov   Boston          1  42.25                                      │
│                          ││ 6 Edsger Dijkstra  NULL            0   NULL                                      │
│                          ││                                                                                  │
│                          ││                                                                                  │
│                          ││                                                                                  │
│                          ││                                                                                  │
│                          ││                                                                                  │
╰──────────────────────────╯╰─ ✓ 6 rows · <1 ms ───────────────────────────────────── 2/6 · city text  y copy ─╯

╭─ 1  Explorer ────────────╮╭─ 2  ● orders.sql ─ ● best-customers.sql ─────────────────────────────────────────╮
│   + New connection       ││  1  -- Best customers this month                                                 │
│                          ││  2  SELECT c.name, c.city,                                                       │
│ ▾ ◈ shop  sqlite         ││  3         count(o.id)  AS orders,                                               │
│   ▾ ▫ Tables  2          ││  4         sum(o.total) AS spent                                                 │
│     ▾ ▦ customers        ││  5  FROM customers c                                                             │
│       ▾ ▫ Columns  4     ││  6  LEFT JOIN orders o ON o.customer_id = c.id                                   │
│           ⚷ id  INTEGER  ││  7  GROUP BY c.id                                                                │
│           · name  TEXT   ││  8  ORDER BY spent DESC NULLS LAST                                               │
│           · city  TEXT   ││                                                                                  │
│           · since  DATE  ││                                                                                  │
│       ▸ ▪ Indexes        ││                                                                                  │
│     ▸ ▦ orders           │╰─ ◈ shop ─────────────────────────────────────────────────────────────────────────╯
│   ▸ ▪ Views              │╭─ 3  Results ─────────────────────────────────────────────────────────────────────╮
│   ▸ ▪ Indexes            ││   name             city       orders  spent                                      │
│   ▸ ▪ Triggers           ││──────────────────────────────────────────────────────────────────────────────────│
│                          ││ 1 Grace Hopper     Arlington       2    995                                      │
│                          ││ 2 Alan Turing      Wilmslow        1    310                                      │
│                          ││ 3 Ada Lovelace     London          2  155.5                                      │
│                          ││ 4 Frances Allen    Peru            1   77.7                                      │
│                          ││ 5 Barbara Liskov   Boston          1  42.25                                      │
│                          ││ 6 Edsger Dijkstra  NULL            0   NULL                                      │
│                          ││                                                                                  │
│                          ││                                                                                  │
│                          ││                                                                                  │
│                          ││                                                                                  │
│                          ││                                                                                  │
╰──────────────────────────╯╰─ ✓ 6 rows · <1 ms ───────────────────────────────────── 2/6 · city text  y copy ─╯

╭─ 1  Explorer ────────────╮╭─ 2  ● orders.sql ─ ● best-customers.sql ─────────────────────────────────────────╮
│   + New connection       ││  1  -- Best customers this month                                                 │
│                          ││  2  SELECT c.name, c.city,                                                       │
│ ▾ ◈ shop  sqlite         ││  3         count(o.id)  AS orders,                                               │
│   ▾ ▫ Tables  2          ││  4         sum(o.total) AS spent                                                 │
│     ▾ ▦ customers        ││  5  FROM customers c                                                             │
│       ▾ ▫ Columns  4     ││  6  LEFT JOIN orders o ON o.customer_id = c.id                                   │
│           ⚷ id  INTEGER  ││  7  GROUP BY c.id                                                                │
│           · name  TEXT   ││  8  ORDER BY spent DESC NULLS LAST                                               │
│           · city  TEXT   ││                                                                                  │
│           · since  DATE  ││                                                                                  │
│       ▸ ▪ Indexes        ││                                                                                  │
│     ▸ ▦ orders           │╰─ ◈ shop ─────────────────────────────────────────────────────────────────────────╯
│   ▸ ▪ Views              │╭─ 3  Results ─────────────────────────────────────────────────────────────────────╮
│   ▸ ▪ Indexes            ││   name             city       orders  spent                                      │
│   ▸ ▪ Triggers           ││──────────────────────────────────────────────────────────────────────────────────│
│                          ││ 1 Grace Hopper     Arlington       2    995                                      │
│                          ││ 2 Alan Turing      Wilmslow        1    310                                      │
│                          ││ 3 Ada Lovelace     London          2  155.5                                      │
│                          ││ 4 Frances Allen    Peru            1   77.7                                      │
│                          ││ 5 Barbara Liskov   Boston          1  42.25                                      │
│                          ││ 6 Edsger Dijkstra  NULL            0   NULL                                      │
│                          ││                                                                                  │
│                          ││                                                                                  │
│                          ││                                                                                  │
│                          ││                                                                                  │
│                          ││                                                                                  │
╰──────────────────────────╯╰─ ✓ 6 rows · <1 ms ───────────────────────────────────── 2/6 · city text  y copy ─╯

theme dark light terminal

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 and columns with their types. Each level loads when you open it, and empty schemas stay out of the way.
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. Tabs save to .sql files, and unsaved work is still there the next time you start.
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.
Errors: The database's own message and code, with the failing line of your SQL and a caret where the database points.
Editor: Syntax highlighting in each database's own dialect, selection, undo, clipboard and indentation that follows the line above.
Sessions: Every tab runs on its own connection, so USE, temp tables and open transactions carry over from one run to the next.
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. Every shortcut can be remapped, and ctrl+g lists them all.

Install

With Go

A single binary with no other dependencies, for Linux, macOS and Windows. Needs Go 1.27 or newer.

$ go install rimor.dev/cmd/rimor@latest
$ rimor

From source

Clone the repository and build the command; the binary lands in the current folder.

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

Press a in the explorer to add a connection. Settings live in ~/.config/rimor/config.toml, written with every default on first run.