sqlpen
A SQL client for PostgreSQL and SQLite: tables, an editor that knows SQL, rows in a grid.
That part is not wired in this demo.
What it does
- The editor
- Completes your tables and columns. ⌘ Enter runs the statement under the caret.
- The grid
- Ten thousand rows scroll like ten. Sort, copy, save as CSV.
- Read only
- Unless you run it with --write. A password is never shown.
Run it by its name
sqlpen --demo# a small shop in SQLite, in memorysqlpen app.db# a SQLite filesqlpen postgres://reader@db.example.com/shop# a PostgreSQL databasesqlpen# the one $DATABASE_URL names
- Over plain ssh
- Run it on the server. Nothing listens on a port.
- Your font and theme
- bateri draws it the way it draws its own text.
- In another terminal
- Says what it is connected to and lists the tables.
The other pens
- textpen A code editor: the project’s files as a tree, tabs, search, and what git says of them. →
- toppen A system monitor in the way of top and btop: cards with graphs, and a table of processes. →
- dockerpen Docker in the pane: containers, logs, images, volumes, networks and disk. →
- pickpen Choose rows in the middle of a pipeline: filter, sort and mark them, and they go out on stdout. →
Download bateri
Free and openly licensed. Open it and your zsh arrives as usual; bateri handles the rest.
Download for macOSOr with Homebrew: