MySQL

Category: SQL Status: base

Connects to a MySQL relational database. Supports full SQL querying, schema browsing, migrations, and ORM code generation.

Connection Settings

Field	Default	Description
host	localhost	Server hostname or IP
port	3306	TCP port
user	(empty)	Database username
password	(empty)	Database password
dbname	(empty)	Database name
url	(empty)	Full connection URL (overrides above fields)

Authentication

Username and password. Password must be at least 8 characters; avoid spaces and quotation marks.

Supported Actions

• execute — run arbitrary SQL queries
• download — export table or query result
• delete — drop tables
• liquibase — Liquibase migration support
• transfer_table — copy table to another connector
• create_user — add a database user
• python_description / django_description / sqlalchemy_description — generate ORM model code
• search_by_value — search within fetched table data

External Links

• https://dev.mysql.com/doc/