MySQL Source Plugin

Latest: v2.0.10

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: "v2.0.10"
  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.

Make sure you use environment variable expansion in production instead of committing the credentials to the configuration file directly.

Tables Tables