my-cmd - Lightweight MySQL TUI & CLI Tool

Powerful Text User Interface (TUI) for MySQL database management - cross-platform, no MySQL client installation required, intuitive command-line interaction with rich terminal-based UI.

Free Trial

See TUI/CLI in Action

Watch how easy it is to manage MySQL databases with my-cmd's interactive TUI and powerful CLI commands.
This demo shows data export, SQL execution, and TUI menu navigation in real-time.

Key Features of Our TUI/CLI Tool

Intuitive TUI Interface

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.

No Installation Needed

Extract the zip file and use immediately. No MySQL client, no DLL files, no system environment configuration required.

Cross-Platform Support

Works seamlessly on Windows, Linux and macOS. Same command syntax and TUI experience across all operating systems.

Full Data Operations

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.

High Performance

Lightweight core with optimized data processing algorithms. Fast data import/export with minimal resource consumption in both CLI and TUI modes.

Secure Connection

Supports MySQL SSL encryption and secure authentication methods to protect your database connection in both interactive TUI and scripted CLI usage.

TUI/CLI Usage Examples

1. Launch Interactive TUI Mode

Start the Text User Interface for interactive database management:

my-cmd
my-cmd> connect root:password123@192.168.0.102:3306/test
my-cmd> load table=media_messages 
      > datafile=f:\media_messages.txt 
      > filetype=txt 
      > delimiter=, 
      > quote=" 
      > header=y;

Features in TUI mode:

  • Interactive menu navigation with keyboard shortcuts (arrow keys, Enter, Esc)
  • Real-time SQL editor with syntax highlighting
  • Visual progress bars for data import/export operations
  • Searchable database object browser (tables, views, procedures)

2. Run via CLI (Non-Interactive)

Basic connection command with host, port, service name, username and password:

my-cmd dsn="root:password123@192.168.0.102:3306/test" task=load table=media_messages datafile=f:\media_messages.txt delimiter=, quote=" header=y quit=y

3. Export Data to CSV (TUI/CLI)

Export data from employees table to CSV file with custom delimiter (works in both modes):

my-cmd dsn="root:password123@192.168.0.102:3306/test" task=unload table=employees datafile=e:\temp\tables\emp_data.csv delimiter="," header=y quit=y

Learn:

What People Use It For

There is nothing on this server to connect with

A production or customer machine where installing a MySQL client is not an option. my-cmd is a single executable with no client, no DLLs and no environment configuration - copy it and use the terminal you already have.

A screen in front of MySQL, not a prompt

Connect, search the tables, views and procedures, and write SQL in an editor with syntax highlighting - results as a table in the same window, over SSH or any terminal.

The same job, but nobody is watching

The whole task - connection, SQL, import or export - passed as parameters in one command, so it can run from a script, a pipeline or a scheduled task.

Rows out to a file, files back into rows

Export a table or a query to CSV, TSV, TXT or JSON, and load a file back in - with the delimiter, quote character and header under your control.

One instruction that works on three systems

The same connection string, the same commands and the same interface on Windows, Linux and macOS - so a runbook or a CI step is written once.

AI wrote the SQL - now it has to run

An assistant can write the script in seconds; running it against the real database - on a server with no client installed, in a script, with a result you can keep - is the part this tool does.

Pricing & Editions

my-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
Buy Now Download Trail

Frequently Asked Questions

What is the difference between TUI and CLI modes in my-cmd?

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.

What MySQL versions does my-cmd support?

my-cmd supports MySQL 5.5, 5.6, 5.7, 8.0 and MariaDB 10.x series. Both TUI and CLI modes work with on-premises MySQL databases, MySQL Cloud, and MariaDB databases.

Do I need to install MySQL Client on my machine?

No, you don't need to install any MySQL Client software. my-cmd has a built-in lightweight MySQL connectivity component that allows direct connection to MySQL databases without additional client installation - this applies to both TUI and CLI modes.

Can I use TUI mode in remote terminal sessions (SSH)?

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.

Is my database password secure when using my-cmd?

Yes. my-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 MySQL's native SSL encryption when enabled on the server side.