Docs
Plugins
Sources
MySQL
Overview

MySQL Source Plugin

Latest: v1.1.1

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.

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