rainfrog

Terminal database client with vim-like keybindings and a query editor, supporting Postgres, MySQL, SQLite, Redshift, DuckDB, and Oracle.

install

rainfrog is a terminal-based database client written in Rust and built on Ratatui. It lets you browse schemas and tables, run SQL queries, and inspect results from a TUI. Supported drivers are Postgres (tier 1), MySQL, SQLite, Redshift and DuckDB (tier 2), and Oracle (tier 3, which needs Oracle Client libraries installed via ODPI-C). The Postgres and MySQL drivers can also be tried against other databases that speak the same wire protocol, though the README says this is not well tested.

The interface uses vim-like keybindings and optional mouse support. The query editor has keyword highlighting, session history, and saved favorites. You can copy data, filter tables, switch between schemas, and open shortcuts for table metadata and properties. Results can be exported. Settings, connections, and keybindings are customized through a rainfrog_config.toml file, and rainfrog edit opens that config.

You can connect with individual flags (--driver, --username, --host, --port, --database), with a full --url, or through a DATABASE_URL environment variable or .env file. Any missing options are prompted for. --ssl-required forces TLS on Postgres, MySQL, and Oracle connections. A Docker image is available for Postgres and MySQL, and SQLite works with a mounted volume. Binaries target macOS, Linux, Windows, and Android via Termux. Icons need a Nerd Font.

It suits developers and DBAs who want to query and explore databases without leaving the terminal. The README warns that the project is under active development and that breaking changes are expected. It advises against using it with write access on a production database.

Installation

# via Homebrew
brew install rainfrog
# via Cargo
cargo install rainfrog --locked
# via Pacman (Arch Linux)
pacman -S rainfrog

Alternatives & related tools

add a badge to your README

Maintain rainfrog? Show that it's featured on trmn. The badge links back to this page.

Featured on trmn
Markdown
[![Featured on trmn](https://www.trmn.sh/badge/rainfrog.svg)](https://www.trmn.sh/tools/rainfrog?utm_source=badge)
HTML
<a href="https://www.trmn.sh/tools/rainfrog?utm_source=badge"><img src="https://www.trmn.sh/badge/rainfrog.svg" alt="Featured on trmn" height="20"></a>