creel

creel is an efficient SQL terminal user interface (TUI) designed specifically for SQLite, MySQL, and PostgreSQL, built with the Go programming language. It leverages a vim-driven, keyboard-centric approach for enhanced productivity when browsing schemas, executing queries, and updating data, all directly from the terminal.

Core Features

• Database Connectivity: Seamlessly connect to SQLite, MySQL, and PostgreSQL databases, with support for SSH tunneling to access remote MySQL instances.
• Secure Password Management: Store passwords securely using the operating system's keychain across macOS, Windows, and Linux—no plain-text configurations.
• Read-Only Mode: Safeguard production databases by enabling read-only connections, either globally or per individual connection.

Browsing and Editing Capabilities

• Table Browser: Inspect schemas, expand columns, and use fuzzy filters to quickly locate data.
• Results Grid: Sort, filter, and hide columns, and explore foreign key relationships with ease. Chart your data using simple commands.
• Entity-Relationship Diagrams: Generate and export static ERDs using the graphical diagram feature available in the interface.
• Inline Data Editing: Modify table cells directly, create or clone rows, and easily paste data from the clipboard.
• Schema Editing: Modify the database structure by adding or renaming columns and managing tables through an intuitive table designer.

Enhanced Workflow

• Vim-Mode Editor: Utilize a vim-like editing paradigm with normal and insert modes, combined with SQL autocompletion.
• Session Management: Preserve your workspace with session restoration, enabling users to return to their previous connections and tabs effortlessly.
• Command Palette and Help: Access a robust command palette for quick command execution, accompanied by an in-app help overlay for assistance.

Performance and Compatibility

creel is optimized for performance; it efficiently handles large result sets, paged for speed and minimal memory usage. Users can also utilize script mode to execute queries and display results without initiating the TUI.

Comparisons with Other Tools

creel distinguishes itself from other database interaction tools through its commitment to a fast, keyboard-centric experience that eliminates dependencies by providing a single, static binary. It is specifically suited for users who desire a terminal-based approach for database management, contrasting with GUI-centric tools.

Documentation

For further details on features, keybindings, and configuration, refer to the extensive documentation. This includes guides on how to execute commands and manage your environment effectively.

In summary, creel offers a comprehensive SQL interface for professionals who require efficient, keyboard-driven interaction with their databases directly from the terminal, enabling quick and effective data management.