MySQL

Install

See the Install guide for the full setup, including Windows PowerShell.

curl -fsSL https://install.skippr.io/install.sh | shClick to copy

Reads data from MySQL tables.

Configuration

source:
  kind: mysql
  connection_string: ${MYSQL_CONNECTION_STRING}

Field	Default	Description
connection_string	(required)	MySQL connection string (e.g. mysql://user:pass@host:3306/db)
tables	(auto-discover)	Optional list of schema.table names to ingest

Namespace: mysql.{database}.{schema}.{table}

CLI

skippr connect source mysql \
  --connection-string 'mysql://user:pass@host:3306/db' \
  --tables customers,orders

Flag	Description
--connection-string	MySQL connection string
--tables	Comma-separated list of tables (omit to discover all)

Authentication

Use a MySQL connection string. Prefer an environment variable so credentials do not live in skippr.yaml.

export MYSQL_CONNECTION_STRING="mysql://user:pass@host:3306/db"

Permissions or Network Requirements

The MySQL user needs read access to the selected tables, and the machine running skippr must be able to reach the MySQL host and port. For CDC-specific binlog requirements, see CDC Sources -- MySQL.

Troubleshooting

Symptom	Fix
authentication or connection errors	Verify MYSQL_CONNECTION_STRING, host reachability, and the selected database name.
missing tables	Check the --tables list or omit it to let Skippr discover all readable tables.

CDC Support

MySQL supports real-time Change Data Capture via binlog replication. When paired with a supported warehouse destination, Skippr reconciles those mutations to exactly-once final state.

See CDC Sources -- MySQL for prerequisites, configuration, and resume behavior.

Next steps

• Pair this source with a destination from Destination Connectors.
• For CDC setup and restart behavior, see CDC Sources and CDC Operations.

Install

See the Install guide for the full setup, including Windows PowerShell.

curl -fsSL https://install.skippr.io/install.sh | shClick to copy