Powerful Text User Interface (TUI) for Oracle database management - cross-platform, no Oracle client installation required, intuitive command-line interaction with rich terminal-based UI.
Watch how easy it is to manage Oracle databases with ora-cmd's interactive TUI and powerful CLI commands.
This demo shows data export, SQL execution, and TUI menu navigation in real-time.
User-friendly Text User Interface with interactive menus, real-time feedback, and syntax highlighting - combines the power of CLI with the usability of graphical interfaces.
Extract the zip file and use immediately. No Oracle client, no DLL files, no system environment configuration required.
Works seamlessly on Windows, Linux and macOS. Same command syntax and TUI experience across all operating systems.
Supports data import (CSV/TSV/TXT/JSON), data export(CSV/TSV/TXT/JSON), SQL script execution, and database connection management via both CLI commands and TUI menus.
Lightweight core with optimized data processing algorithms. Fast data import/export with minimal resource consumption in both CLI and TUI modes.
Supports Oracle Net encryption and secure authentication methods to protect your database connection in both interactive TUI and scripted CLI usage.
Start the Text User Interface for interactive database management:
ora-cmd
ora-cmd> connect scott:tiger@192.168.0.102:1521/orcl
ora-cmd> load table=media_messages
> datafile=f:\media_messages.txt
> filetype=txt
> delimiter=,
> quote="
> header=y;
Features in TUI mode:
Basic connection command with host, port, service name, username and password:
ora-cmd dsn="scott:tiger@192.168.0.102:1521/orcl" task=load table=media_messages datafile=f:\media_messages.txt delimiter=, quote=" header=y quit=y
Export data from EMP table to CSV file with custom delimiter (works in both modes):
ora-cmd dsn="pan:withdata@192.168.0.102:1521/test" task=unload table=EMP datafile=e:\temp\tables\emp_data.csv delimiter="," header=y quit=y
Learn:
ora-cmd offers flexible licensing options for individuals and enterprises. All paid editions include full TUI/CLI functionality, ongoing updates and technical support.
| Edition | Price (USD) | License Type | Features |
|---|---|---|---|
| Free Trial | $0 | 30-day trial | Full TUI/CLI features, limited to 1000 rows per import/export |
| Full Edition | $49.95 | Single user | Full TUI/CLI features, unlimited rows |
| Enterprise Edition (Site License) |
$800 | Unlimited users | Full TUI/CLI features, unlimited rows + priority support |
CLI (Command Line Interface) mode is for scripted/automated usage with single commands, while TUI (Text User Interface) mode provides an interactive, menu-driven terminal interface with visual feedback, progress indicators, and keyboard navigation - ideal for ad-hoc database management tasks. You can switch between modes based on your workflow needs.
ora-cmd supports Oracle 10g, 11g, 12c, 18c, 19c and 21c. Both TUI and CLI modes work with on-premises Oracle databases and Oracle Cloud Infrastructure (OCI) databases.
No, you don't need to install any Oracle Client software. ora-cmd has a built-in lightweight Oracle connectivity component that allows direct connection to Oracle databases without additional client installation - this applies to both TUI and CLI modes.
Yes, the TUI mode is fully compatible with remote terminal sessions (SSH, Telnet, etc.) on Linux/macOS and Windows Terminal. It works with all standard terminal emulators and supports ANSI escape codes for proper rendering of the text-based interface.
Yes. ora-cmd does not store your database credentials. In TUI mode, passwords are masked (hidden) when entered, and you can use environment variables or encrypted configuration files to pass credentials in CLI mode. All database connections use Oracle's native encryption when enabled on the server side.