Using VisiData with MySQL and MariaDB

Prerequisites

You either need a working MySQL / MariaDB installation or at least the libmysqlclient-dev package (Ubuntu; name might be different on other platforms) on your machine.

Installation

Add the mysqlclient Python module to your setup or virtual environment, resp.:

pip install mysqlclient

Usage

The syntax is straight-forward, the connection URL should be self-explanatory:

vd 'mysql://username:[email protected]:port/database'

Example

vd 'mysql://mysql:xxx@localhost:3306/information_schema'