A terminal user interface (TUI) for viewing, editing, and querying SQLite and CSV database files.
termdbms (also called sqlite-tui) is a terminal-based database management system that provides a graphical interface for interacting with SQLite and CSV files directly from the command line. It enables developers and database administrators to browse tables, edit data, and run SQL queries without leaving their terminal environment.
Developers and database administrators who work with SQLite or CSV files and prefer a keyboard-first workflow within the terminal. It is particularly useful for those who manage databases on remote servers or in headless environments.
Developers choose termdbms for its pure Go implementation, efficient keyboard-first navigation, and comprehensive feature set including data editing with undo/redo, SQL query execution with a clipboard, and CSV conversion—all within a customizable TUI that works with both keyboard and mouse.
A TUI for viewing and editing database files.
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Features vim-like controls and WASD keys for efficient cell and column movement, enabling rapid data browsing without a mouse.
Supports undo and redo of SQL-based changes in SQLite databases, providing a safety net for data manipulation.
Allows seamless conversion of CSV files to SQLite databases and export of query results back to CSV, simplifying data workflows.
Offers multiple themes (default, nord, solarized) that can be cycled with a key press, enhancing visual comfort in terminal environments.
Only supports SQLite and CSV files currently, with MySQL and PostgreSQL on the roadmap but not implemented, restricting use to specific database types.
Lacks line wrapping in format mode and has known issues with tabs and newlines, which can break functionality and hinder editing of long text fields.
Build notes indicate slow performance on ARM architectures depending on specs, potentially affecting usability on devices like Raspberry Pi.