achristmascarl/rainfrog
Rainfrog
Rainfrog is a terminal-based database client that connects to multiple database engines, combining schema browsing, interactive SQL query execution, and inline data editing into a single terminal interface. It provides a tree navigator for exploring tables, columns, and indexes, and an inline cell editor that automatically constructs and executes the necessary UPDATE statements when a cell value is changed. The application also supports modal Vim-style keyboard shortcuts for cursor movement and editing, making it usable entirely from the keyboard.
Query results are fetched in chunks and paginated on demand, allowing smooth scrolling through large datasets without overwhelming the terminal. System metadata is cached at connection time to speed up schema tree navigation, and the user interface is built on a retained-mode widget tree that renders via a framebuffer with mouse and keyboard event handling. Keybindings, display settings, and mouse capture behavior are all configurable through a YAML file loaded at startup.
Connections can be configured using connection strings or individual parameters such as host, port, and credentials. The client supports saving frequently used SQL queries as named favorites for quick replay and can export query results or entire tables to CSV files saved to the system downloads directory.
Features
- Database Management Clients - Provides a terminal-based client for running SQL queries and editing data across multiple database engines.
- Database Driver Abstractions - Provides a common API layer over interchangeable native database drivers for executing queries and managing connections.
- Database Connection Configurations - Configures database connections by providing connection strings or parameters including host, port, and credentials.
- Database Administration Interfaces - Manages databases from the command line with schema browsing, query execution, and inline editing.
- Schema Object Inspection - Navigates database schemas, tables, and metadata in a tree view with keyboard and mouse support for filtering and inspection.
- Database Query Execution - Executes SQL queries interactively with syntax highlighting and session history, displaying results instantly.
- Schema Introspection - Fetches database metadata at connect time and caches it in memory for fast schema tree navigation.
- In-Place Cell Editing - Updates individual row cells directly from the command line without writing SQL, with immediate visual feedback.
- Inline Data Editing - Edits individual row cell values directly in the terminal without writing SQL statements.
- Multi-Database Connections - Connects to multiple database engines using native drivers or wire-protocol compatibility for cross-vendor querying.
- Stream-Aware Result Paginators - Fetches query results in chunks and renders them on demand, enabling smooth scrolling through large datasets without overwhelming the terminal.
- Implicit Update Statement Builders - Automatically builds and executes UPDATE statements when a cell is edited, eliminating the need to write SQL manually.
- SQL Query Editors - Ships an interactive SQL editor with syntax highlighting, session history, and inline cell editing.
- Interactive SQL Executors - Runs ad-hoc SQL queries in a terminal interface with syntax highlighting, history, and instantly visible results.
- Database Schema Explorers - Provides a tree navigator for exploring tables, columns, indexes, and metadata in a terminal interface.
- Modal Keybinding Engines - Implements a finite state machine that parses keyboard input across modes and maps sequences to configurable action handlers.
- Vim-Style Application Keybindings - Controls text cursor movement, insertion, deletion, and selection using modal Vim key sequences for efficient editing.
- Terminal Widget Sets - Renders a retained-mode widget tree onto a terminal screen using a cell-based framebuffer and event-dispatch loop.
- CSV Exports - Exports query results and table data to CSV files saved in the system downloads directory.
- Keyboard Shortcut Mappings - Remaps default keyboard shortcuts for navigation, editing, and command execution to match personal preferences.
- Display Settings - Adjusts mouse capture, column widths, row spacing, and keybindings through a configuration file for terminal display.
- Bases de datos - PostgreSQL management tool with vim-like keybindings.
- Herramientas de desarrollo - Database management TUI for SQL.
- SQL Clients and IDEs - Terminal-based database interface with experimental support for analytical engines.
