rainfrog

Lightweight terminal-based database management TUI

TLDR

Connect to a PostgreSQL database

$ rainfrog --url postgres://[user]:[password]@[host]/[database]

Connect to a MySQL database

$ rainfrog --url mysql://[user]:[password]@[host]/[database]

Connect to a SQLite database

$ rainfrog --url sqlite://[path/to/db.sqlite]

Connect with a specific driver

$ rainfrog --url [connection_string] --driver [postgres]

rainfrog is a lightweight, terminal-based database management tool designed as an alternative to pgAdmin and DBeaver. It features vim-like keybindings, a query editor with keyword highlighting, session history, favorites, and the ability to quickly copy data, filter tables, and switch between schemas. It supports PostgreSQL, MySQL, and SQLite.

PARAMETERS

--url CONNECTIONSTRING_

Database connection string.

--driver DRIVER

Database driver to use (postgres, mysql, sqlite).

--username USER

Database username.

--password PASS

Database password.

--host HOST

Database host.

--port PORT

Database port.

--database NAME

Database name.

INSTALL

sudo pacman -S rainfrog

brew install rainfrog

nix profile install nixpkgs#rainfrog

CAVEATS

Under active development with expected breaking changes. Not recommended for write access on production databases. Connection strings with special characters in passwords may need URL encoding.

HISTORY

rainfrog was created by achristmascarl and is written in Rust.