Risingwave

Use when working with RisingWave — streaming SQL database, materialized views, sources, sinks, CDC from PostgreSQL/MySQL, Kafka ingestion, time windows (TUMBLE/HOP/SESSION), watermarks, EMIT ON WINDOW CLOSE, port 4566, risingwave-mcp, event streaming pipeline design, real-time analytics, stream processing

9 starsDatabases Plugin marketplace

Install

Claude Code plugin
/plugin marketplace add risingwavelabs/agent-skills

The repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add risingwavelabs/agent-skills --skill risingwave
Manual install
git clone --depth 1 https://github.com/risingwavelabs/agent-skills.git /tmp/agent-skills
mkdir -p ~/.claude/skills
cp -r /tmp/agent-skills/skills/risingwave ~/.claude/skills/risingwave

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# RisingWave

RisingWave is a streaming SQL database implementing the PostgreSQL wire protocol.
The core pipeline is: **Source** (ingest) → **Materialized View** (continuous compute) → **Sink** (output).

## Core Principles

1. **Port 4566, not 5432** — RisingWave listens on `4566` for SQL connections. Dashboard is at `5691`.
2. **SOURCE ≠ TABLE** — `CREATE SOURCE` connects a stream but doesn't persist data. `CREATE TABLE` persists. For CDC (Debezium, Maxwell, Canal), you MUST use `CREATE TABLE ... FROM source`.
3. **Watermarks unlock window closing** — Without `WATERMARK FOR col AS col - INTERVAL '...'`, `EMIT ON WINDOW CLOSE` won't work; use it on the source or table definition. In RisingWave 2.8+, watermarks on `TABLE` require `APPEND ONLY` — use `CREATE SOURCE` for non-append-only streams that need watermarks.
4. **`EMIT ON WINDOW CLOSE` vs default** — Default emit-on-update sends partial results after each checkpoint. Use `EMIT ON WINDOW CLOSE` for final, immutable window results.
5. **Large backfills need `BACKGROUND_DDL`** — Creating an MV over a large table blocks without `SET BACKGROUND_DDL = true`. Monitor with `SELECT * FROM rw_catalog.rw_ddl_progress`.
6. **`snapshot = false` on sinks** — Adding a sink to an existing MV without this flag replays all historical data into the sink.
7. **Verify docs** — RisingWave evolves rapidly. When unsure, check [docs.risingwave.com](https://docs.risingwave.com) or query `SHOW CREATE` on existing objects.

## Connection
Read the full skill on GitHub

Details

Skill name
risingwave
Path
skills/risingwave/SKILL.md
Repo updated
13 April 2026

FAQ

What does the Risingwave skill do?

Use when working with RisingWave — streaming SQL database, materialized views, sources, sinks, CDC from PostgreSQL/MySQL, Kafka ingestion, time windows (TUMBLE/HOP/SESSION), watermarks, EMIT ON WINDOW CLOSE, port 4566, risingwave-mcp, event streaming pipeline design, real-time analytics, stream processing

How do I install the Risingwave skill?

Claude Code plugin: /plugin marketplace add risingwavelabs/agent-skills. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Risingwave popular?

It lives in risingwavelabs/agent-skills, which has 9 GitHub stars and 0 forks.

Related skills

Risingwave Best Practices

9

risingwavelabs/agent-skills

Use when designing RisingWave schemas, writing materialized views, configuring sources or sinks, optimizing streaming SQL performance, troubleshooting slow backfills, setting up CDC, designing time-windowed aggregations, or reviewing a RisingWave streaming pipeline

Databases

Query Tune

9

kbdevs/query-tune

Diagnose and improve slow SQL queries using execution plans, existing indexes, bounded reads, and paired benchmarks. Use for query latency, excess statements, or lock contention; follow the project's migration process for schema changes.

Databases

Seekdb

9

oceanbase/oceanbase-skills

Overview skill for OceanBase SeekDB. Routes to specialized sub-skills covering the full SeekDB lifecycle — install/deploy on a target machine, build from source, look up documentation, use the seekdb-cli for SQL/schema/vector ops, import CSV/Excel data, and query/export results. Use as a starting point when the user mentions seekdb, pyseekdb, "install seekdb", "build seekdb", "seekdb docs", "seekdb-cli", "import to seekdb", "query seekdb", or wants a lightweight standalone OceanBase-compatible database.

Databases

Disenar Arquitectura Datasets Tablas Bigquery

9

detrics/claude-skills

Diseña una arquitectura de datos de marketing en BigQuery con Detrics — decide los datasets, table groups, tablas y campos por fuente de datos, planifica las queries de consolidación (y las ejecuta vía un MCP de BigQuery si está disponible) y produce las tablas master que consumen tus dashboards. Usar cuando un usuario quiere planificar o reestructurar su data warehouse de marketing, organizar datos de múltiples clientes, decidir qué tablas y campos sincronizar, o diseñar los esquemas que alimentan sus dashboards.

Databases

Persistence Design

9

eralmansouri/skills

Use for database and persistence design, data ownership, transaction boundaries, repositories, CQRS read models, query performance, optimistic concurrency, caching, projections, schema migrations, partitioning, and multi-tenancy.

Databases

Mema Vault

33

dvcrn/openclaw-skills-marketplace

Secure credential manager using AES-256 (Fernet) encryption. Stores, retrieves, and rotates secrets using a mandatory Master Key. Use for managing API keys, database credentials, and other sensitive tokens.

Databases17

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.