rainfrog

rainfrog is a lightweight, terminal-based database management tool designed for developers and database administrators who prefer working in the command line. It provides an efficient alternative to heavyweight GUI applications, offering quick database interactions and data exploration without leaving your terminal.

The tool features vim-like navigation that feels natural to terminal users, combined with a query editor that includes keyword highlighting, session history, and saved favorites for frequently used queries. You can quickly copy data, filter tables, and switch between schemas with minimal keystrokes. Metadata shortcuts let you view table properties and structure instantly.

Key capabilities include:

• Efficient navigation via vim keybindings and optional mouse controls
• Query editor with syntax highlighting, command history, and favorite queries
• Schema and table browsing with filtering and quick switching
• Data manipulation features for copying and exporting results
• Cross-platform support on macOS, Linux, Windows, and Android via Termux
• Multiple database support including PostgreSQL (Tier 1), MySQL, SQLite, Redshift, DuckDB, and Oracle

The interface is designed for speed and efficiency, allowing you to navigate databases and execute queries without context switching. Whether you need to test queries, explore data structures, or perform quick database operations, rainfrog eliminates the overhead of GUI tools while maintaining a responsive, intuitive experience.