RisingWave SQL Assistant

Public Preview

This tool is in Public Preview and may contain errors or inaccuracies.

Please refer to the official RisingWave documentation for accurate and up-to-date information.

MySQL CDC Source

Generate CREATE SOURCE and CREATE TABLE for MySQL CDC

Connection

Connect to MySQL database. The user needs REPLICATION SLAVE and REPLICATION CLIENT privileges. Server ID will be auto-generated by the system.

Hostname*

Port*

Username*

Password*

Database*

Cannot use built-in databases like mysql, sys, information_schema, performance_schema.

Advanced Options

Configure optional advanced settings for MySQL CDC connection.

SSL Mode

SSL connection mode.

Auto Schema Change (Premium Feature)

(Automatically propagate upstream schema changes to RisingWave.)

Table Configuration

Configure the table to create from the MySQL CDC source. Upstream table format should be 'database.table' or 'table'.

Source Name*

Name for the CREATE SOURCE statement.

Upstream Table*

Upstream MySQL table in format 'database.table' or just 'table'.

Table Name*

Name for the table to create in RisingWave.

Backfill Historical Data

(Sync existing data from upstream table. Checked by default. Uncheck to only consume new changes (adds snapshot = 'false').)

SQL Preview

Ready to Generate SQL

Fill in the required fields on the left to generate your RisingWave SQL statement. The preview will update automatically as you enter information.

💡 Quick Start:

• Start with the required fields marked with red asterisks (*)
• Use the Verify button to check for missing fields
• Copy the generated SQL when ready