> ## Documentation Index
> Fetch the complete documentation index at: https://docs.risingwave.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SQL reference

> 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](https://claude.ai/claude-code) or [Cursor](https://cursor.com) with the [RisingWave MCP server](https://github.com/risingwavelabs/risingwave-mcp) 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](/processing/sql/dynamic-filters).

<CardGroup>
  <Card title="Commands" icon="terminal" href="/web-api/iframe-proxy?url=https://docs.risingwave.com/sql/commands/overview">
    84 items
  </Card>

  <Card title="Query syntax" icon="code" href="/web-api/iframe-proxy?url=https://docs.risingwave.com/sql/query-syntax/overview">
    13 items
  </Card>

  <Card title="Data types" icon="table" href="/web-api/iframe-proxy?url=https://docs.risingwave.com/sql/data-types/overview">
    8 items
  </Card>

  <Card title="Functions and operators" icon="function" href="/web-api/iframe-proxy?url=https://docs.risingwave.com/sql/functions/overview">
    16 items
  </Card>

  <Card title="Identifiers" icon="id-badge" href="/web-api/iframe-proxy?url=https://docs.risingwave.com/sql/identifiers">
    Naming restrictions
  </Card>

  <Card title="System catalogs" icon="database" href="/web-api/iframe-proxy?url=https://docs.risingwave.com/sql/system-catalogs/overview">
    3 items
  </Card>

  <Card title="Psql commands" icon="terminal" href="/web-api/iframe-proxy?url=https://docs.risingwave.com/sql/psql-commands">
    RisingWave supported commands
  </Card>
</CardGroup>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.