skillZs
★ LIVE SKILL TAGS ★
>>> LIVE SKILLS INDEX <<<
* OPEN SOURCE *
NO LOGIN, NO TRACKING
※ REAL INSTALL DATA ※
← back to all skills
risingwavelabs/agent-skills100 installs

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

How do I install this agent skill?

npx skills add https://github.com/risingwavelabs/agent-skills --skill risingwave-best-practices
view source ↗

Is this agent skill safe to install?

  • Gen Agent Trust Hubpass

    The risingwave-best-practices skill is a comprehensive set of technical guidelines for RisingWave users. It covers schema design, materialized views, and performance optimization. The skill uses safe practices, such as providing placeholders for credentials in example configurations, and contains no malicious code or exfiltration patterns.

  • Socketpass

    No alerts

  • Snykpass

    Risk: LOW · No issues

What does this agent skill do?

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

Materialized View Review

Streaming SQL Review

Sink Review

Performance Review

Rule Categories

PriorityCategoryImpactPrefixRules
1Schema DesignCRITICAL / HIGHschema-3
2Materialized ViewsCRITICAL / HIGHmv-3
3Streaming SQLCRITICAL / HIGHstream-3
4Sink ConfigurationHIGH / MEDIUMsink-2
5PerformanceHIGH / MEDIUMperf-3

Quick Reference

Schema:

  • schema-source-vs-table — CDC requires TABLE; SOURCE is for append-only streams
  • schema-append-only — APPEND ONLY enables optimizations; use for immutable event data
  • schema-watermark — Define watermarks at ingestion point (source/table), not in MVs

Materialized Views:

  • mv-emit-on-window-close — Use EOWC for final window results; default emits partial updates
  • mv-background-ddl — SET BACKGROUND_DDL=true before creating MVs over large tables
  • mv-no-order-by — ORDER BY in MV applies only at creation, not to ongoing results

Streaming SQL:

  • stream-tumble-windows — Use TUMBLE/HOP/SESSION, not date_trunc, for streaming windows
  • stream-cdc-pattern — Two-step: CREATE SOURCE (shared) → CREATE TABLE ... FROM source
  • stream-temporal-join — Join streaming source with CDC table using FOR SYSTEM_TIME AS OF

Sinks:

  • sink-snapshot-false — Always use snapshot = false when adding sinks to existing MVs
  • sink-force-compaction — Use force_compaction = true for high-cardinality upsert sinks

Performance:

  • perf-shared-source — Multiple MVs from one Kafka topic should use shared source
  • perf-indexes-on-mv — Create indexes on MV columns used in WHERE/JOIN predicates
  • perf-parallelism — Increase parallelism for high-throughput MVs

Add the canonical catalog link to the repository README so users can inspect current installs and available audits. The publishing guide covers the complete discovery path.

<a href="https://skillzs.dev/skills/risingwavelabs/agent-skills/risingwave-best-practices">View risingwave-best-practices on skillZs</a>