MySQL Source Plugin

The CloudQuery MySQL plugin syncs your MySQL database to any of the supported CloudQuery destinations (e.g. PostgreSQL, BigQuery, Snowflake, and more). Supported database versions are >= 5.7.

Example

This example configures a MySQL source, located at localhost:3306. The (top level) spec section is described in the Source Spec Reference.

kind: source
spec:
  name: "mysql"
  path: "cloudquery/mysql"
  version: "v1.1.1"
  tables: ["*"]
  destinations: ["postgresql"]
  spec:
    connection_string: "user:password@/dbname"

MySQL spec

This is the (nested) spec used by the MySQL destination plugin.

• connection_string (string, required)

  Connection string to connect to the database. See the Go driver documentation (opens in a new tab) for more details.