connector

MySQL

The widely-used open-source relational database.

Connection fields

Field	Required	Description
`host`	Yes	Hostname or IP address of the MySQL server.
`port`	No	Defaults to 3306.
`user`	Yes	Username to authenticate with.
`password`	No	Not enforced by the connector, but almost every real server requires one — leave it blank only against a server configured to allow passwordless auth.
`db`	Yes	Database name to connect to.

Example configuration

{
  "host": "db.internal.example.com",
  "port": 3306,
  "user": "arcodash_reader",
  "password": "••••••••",
  "db": "analytics"
}

Caveats

MySQL's BOOL/BOOLEAN columns are stored as TINYINT under the hood, and this connector decodes every TINYINT column (including TINYINT(1)) as a plain integer, not a boolean — expect 0/1 rather than true/false in query results.
arcodash needs network access to reach the host, so a cloud-hosted instance (RDS, Cloud SQL, etc) must accept connections from the internet. arcodash doesn't publish a fixed set of outbound addresses to allowlist — enable SSL/TLS rather than relying on IP filtering.