Skip to content

Using VisiData with MySQL and MariaDB

Tobi Schäfer edited this page Jul 29, 2020 · 1 revision

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:password@host.domain:port/database'

Example

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