Repolode
Submit
achristmascarl

achristmascarl/rainfrog

A terminal (TUI) database client for PostgreSQL, MySQL, SQLite, DuckDB and more, with vim-style keybindings.

Open-source alternative to:DBeaverTablePlus

View on GitHubWebsite
Stars
5,383
Forks
98
Open issues
14
Last commit
9 days ago

What is it?

rainfrog is a lightweight database tool that runs in the terminal. It lets you connect to databases, browse schemas and tables, edit and run SQL queries, and review results without leaving the command line. It is built with Rust and the ratatui TUI library.

The tool supports PostgreSQL, MySQL, SQLite, Redshift, DuckDB and Oracle, with each driver assigned a support tier that reflects how often it is tested. Navigation uses vim-like keybindings and optional mouse control. The query editor offers keyword highlighting, autocomplete, session history and saved favorites.

Results can be copied, filtered and exported to CSV. Connections can be set through command-line flags, a connection URL, environment variables or a config file, and passwords can be stored in the platform keychain. The project is installable via cargo, Homebrew, pacman, conda, Nix and release binaries, and runs on macOS, Linux, Windows and Android via Termux.

Key features

  • 01Connects to PostgreSQL, MySQL, SQLite, DuckDB, Redshift and Oracle
  • 02Vim-like keybindings with optional mouse support
  • 03Query editor with keyword highlighting, autocomplete, history and favorites
  • 04Filter tables, switch schemas and preview table rows
  • 05Export query results to CSV
  • 06Passwords can be saved in the platform keychain

Use cases

  • Inspecting and querying a database over SSH on a remote server
  • Quickly browsing tables and schemas without opening a GUI client
  • Running ad hoc SQL against local SQLite or DuckDB files
  • Working from a terminal-only environment such as Termux on Android

Quick start

  1. 1

    Install rainfrog with cargo (requires Rust)

    cargo install rainfrog --locked
  2. 2

    Or install with Homebrew on macOS or Linux

    brew install rainfrog
  3. 3

    Run rainfrog and enter connection details when prompted

    rainfrog

Things to know

  • The project is under active development, so expect breaking changes.
  • Not recommended for use with write access on a production database.
  • Support varies by database; Oracle needs extra runtime dependencies and some tier 4 drivers are experimental.

Topics

#database#terminal#tui#sql#postgresql#mysql#sqlite#rust#database-management#ratatui

FAQ

What is rainfrog?
A terminal (TUI) database client for PostgreSQL, MySQL, SQLite, DuckDB and more, with vim-style keybindings. rainfrog is a lightweight database tool that runs in the terminal. It lets you connect to databases, browse schemas and tables, edit and run SQL queries, and review results without leaving the command line. It is built with Rust and the ratatui TUI library.
Is rainfrog free to use? What license does it have?
rainfrog is open source under the MIT license. Check the license terms before using it in commercial products.
Is rainfrog still maintained?
Actively maintained. The last commit to rainfrog was on Oct 13, 2026.
What can I use rainfrog for?
Inspecting and querying a database over SSH on a remote server Quickly browsing tables and schemas without opening a GUI client Running ad hoc SQL against local SQLite or DuckDB files Working from a terminal-only environment such as Termux on Android
How do I install rainfrog?
Install rainfrog with cargo (requires Rust): cargo install rainfrog --locked Or install with Homebrew on macOS or Linux: brew install rainfrog Run rainfrog and enter connection details when prompted: rainfrog
Where can I get rainfrog?
The source code and installation instructions are on GitHub: https://github.com/achristmascarl/rainfrog

Summary generated by AI from the project's README. GitHub stats refresh daily.

Related projects