Commands
84 items
Query syntax
13 items
Data types
8 items
Functions and operators
16 items
Identifiers
Naming restrictions
System catalogs
3 items
Psql commands
RisingWave supported commands
SQL reference
RisingWave SQL reference | PostgreSQL-compatible SQL for streaming
Complete SQL reference for RisingWave streaming database. PostgreSQL-compatible syntax for CREATE MATERIALIZED VIEW, sources, sinks, functions, data types, and system catalogs.
Need help generating SQL? Use Claude Code or Cursor with the RisingWave MCP server to generate and run SQL interactively.
Below are detailed SQL references supported by RisingWave.
For the summary of some SQL usage, refer to these SQL topics.