Back to destination list
Official
MySQL
This destination plugin lets you sync data from a CloudQuery source to a MySQL database
Loading plugin documentation
This destination plugin lets you sync data from a CloudQuery source to a MySQL database
Loading plugin documentation
We use tracking cookies to understand how you use the product and help us improve it. Please accept cookies to help us improve. You can always opt out later via the link in the footer.
If you need support for older versions, please contact us
kind: destination
spec:
name: "mysql"
path: "cloudquery/mysql"
registry: "cloudquery"
version: "v5.3.24"
# Learn more about the configuration options at https://cql.ink/mysql_destination
spec:
connection_string: "user:password@/dbname"
# Optional parameters:
# batch_size: 1000 # 1K entries
# batch_size_bytes: 4194304 # 4 MiB
batch_size and batch_size_bytes.connection_string (string) (required)"user:password@tcp(127.0.0.1:3306)/dbname" connect with TCP"user:[email protected]:3306/dbname?charset=utf8mb4\u0026parseTime=True\u0026loc=Local" connect and set character set, time parsing, and location"user:password@localhost:3306/dbname?timeout=30s\u0026readTimeout=1s\u0026writeTimeout=1s" connect and set various timeouts"user:password@/dbname?loc=UTC\u0026allowNativePasswords=true\u0026tls=preferred" connect and set location and native password allowance, and prefer TLSbatch_size (integer) (optional) (default: 1000)batch_size_bytes (integer) (optional) (default: 4194304 (= 4 MiB))docker run -p 3306:3306 --name mysql -e MYSQL_ROOT_PASSWORD=test -e MYSQL_DATABASE=cloudquery -d mysql:latest
cloudquery MySQL database via the following connection string:root:password@/cloudquery
kind: destination
spec:
name: "mysql"
path: "cloudquery/mysql"
registry: "cloudquery"
version: "v5.3.24"
spec:
connection_string: "root:password@/cloudquery"