Rainfrog is a database tool for the terminal that provides a lightweight, keyboard-driven interface for interacting with databases from the command line.
The tool addresses the need for efficient database exploration and querying without leaving the terminal. It combines vim-like keybindings with mouse support for navigation, includes a query editor with syntax highlighting and session history, and allows users to quickly copy data, filter tables, and switch between schemas. The interface also provides shortcuts to view table metadata and properties, making common database tasks accessible through a single terminal application.
Rainfrog suits developers and database administrators who prefer terminal-based workflows and want to avoid heavyweight GUI tools. It works across macOS, Linux, Windows, and Android via Termux. The tool supports multiple databases at different maturity levels: PostgreSQL receives the most frequent testing and rapid bug fixes, while MySQL and SQLite are often tested with fixes applied as needed, DuckDB is community-supported, and Oracle is experimental. The PostgreSQL driver can also connect to other databases supporting the PostgreSQL wire protocol, such as AWS Redshift, though this functionality is not well tested. The README explicitly cautions that the software is under active development with breaking changes expected, and recommends against using it with write access on production databases.
Development activity shows consistent engagement with the codebase through regular commits and active issue management. The project maintains organized documentation including installation instructions across multiple package managers and detailed customization options for settings, keybindings, and database connections. Community contributions are actively welcomed, particularly for tier-three and tier-four database support.
