RisingWave SQL Assistant

Public Preview

Website GitHub Slack

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.

Postgres CDC Source

Generate CREATE SOURCE and CREATE TABLE FROM SOURCE for Postgres CDC

Connection

Connect to PostgreSQL database. The user needs appropriate permissions for CDC (REPLICATION, LOGIN, and table access).

Name*

Name for the PostgreSQL CDC source.

Hostname*

Port*

Username*

Password*

Database*

Schema*

PostgreSQL schema name.

Replication Settings

Slot Name

Leave empty to auto-generate a unique replication slot name.

Auto Create Publication

(Automatically create publication if it doesn't exist.)

Advanced Options

SSL Mode

SSL connection mode.

Transactional Mode

(Enable transactional consistency for multi-table changes.)

Auto Schema Change (Premium)

(Automatically track schema changes from upstream database.)

AWS RDS

(Enable this if connecting to AWS RDS PostgreSQL.)

Create Table from Source

Specify which upstream table to materialize into RisingWave.

Table Name*

Name for the table to create in RisingWave.

Upstream Table*

Upstream table name. Format: schema.table or just table.

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