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
Install
/plugin marketplace add risingwavelabs/agent-skillsThe repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.
npx skills add risingwavelabs/agent-skills --skill risingwavegit 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/risingwavePersonal 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
Details
- Skill name
risingwave- Repository
- risingwavelabs/agent-skills
- 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
9risingwavelabs/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
Query Tune
9kbdevs/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.
Seekdb
9oceanbase/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.
Disenar Arquitectura Datasets Tablas Bigquery
9detrics/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.
Persistence Design
9eralmansouri/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.
Mema Vault
33dvcrn/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.
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.