Risingwave Best Practices

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

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-best-practices
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-best-practices ~/.claude/skills/risingwave-best-practices

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 Best Practices

14 rules covering schema design, streaming SQL patterns, sink configuration, and performance.

## How to Apply

1. Read the relevant rule files for the review type below
2. Apply rules to the design or code under review
3. Explain violations with their impact and the fix

## Review Procedures

### Schema Review
- [ ] [schema-source-vs-table.md](rules/schema-source-vs-table.md) — SOURCE vs TABLE selection
- [ ] [schema-append-only.md](rules/schema-append-only.md) — APPEND ONLY for immutable streams
- [ ] [schema-watermark.md](rules/schema-watermark.md) — Watermark placement

### Materialized View Review
- [ ] [mv-emit-on-window-close.md](rules/mv-emit-on-window-close.md) — EOWC for windowed queries
- [ ] [mv-background-ddl.md](rules/mv-background-ddl.md) — Non-blocking DDL for large tables
- [ ] [mv-no-order-by.md](rules/mv-no-order-by.md) — ORDER BY in MVs

### Streaming SQL Review
- [ ] [stream-tumble-windows.md](rules/stream-tumble-windows.md) — Time window functions
- [ ] [stream-cdc-pattern.md](rules/stream-cdc-pattern.md) — Two-step CDC setup
- [ ] [stream-temporal-join.md](rules/stream-temporal-join.md) — Joining streams with CDC tables

### Sink Review
- [ ] [sink-snapshot-false.md](rules/sink-snapshot-false.md) — Prevent backfill duplicates
- [ ] [sink-force-compaction.md](rules/sink-force-compaction.md) — Reduce output volume

### Performance Review
- [ ] [perf-shared-source.md](rules/perf-shared-source.md) — Shared Kafka source
Read the full skill on GitHub

Details

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

FAQ

What does the Risingwave Best Practices skill do?

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

How do I install the Risingwave Best Practices 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 Best Practices popular?

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

Related skills

Risingwave

9

risingwavelabs/agent-skills

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

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

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

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

SQL Expert

6

techgangboss/agentstore

Use this skill when the user needs help writing SQL queries, optimizing existing queries, understanding execution plans, designing schemas, or debugging database issues. Trigger on phrases like "write a query", "optimize this SQL", "explain this query", "design a schema", "database help", "why is this query slow", etc.

DatabasesIn 1 list

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

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