LinuxCommandLibrary
GitHubF-DroidGoogle Play Store

rainfrog

Lightweight terminal-based database management TUI

TLDR

Connect to a PostgreSQL database
$ rainfrog --url postgres://[user]:[password]@[host]/[database]
copy
Connect to a MySQL database
$ rainfrog --url mysql://[user]:[password]@[host]/[database]
copy
Connect to a SQLite database
$ rainfrog --url sqlite://[path/to/db.sqlite]
copy
Connect with a specific driver
$ rainfrog --url [connection_string] --driver [postgres]
copy

SYNOPSIS

rainfrog [options]

DESCRIPTION

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.

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.

SEE ALSO

psql(1), lazysql(1), mycli(1)

Copied to clipboard
Kai