RisingWave MCP

RisingWave is a Postgres-compatible streaming database that maintains materialized views incrementally as events arrive. Its MCP server connects an agent to a running instance over the Postgres wire protocol and exposes the catalog as tools: list databases, schemas, tables, and materialized views, describe a table's columns and types, and inspect the sources and sinks that wire the database to Kafka topics, change data capture streams, and downstream systems. Beyond exploration it runs queries and, where the connected role permits, executes statements that create or drop materialized views, sources, and sinks. That turns a chat client into a workable interface for iterating on a streaming pipeline: ask what data is available, inspect a schema, draft a view, create it, then query the maintained result a moment later instead of waiting for a scheduled job. The server is open source and works against self-hosted RisingWave as well as the managed cloud service. It suits data engineers prototyping streaming transformations, analysts who want conversational access to continuously updated aggregates, and teams building agents that need current numbers rather than a nightly snapshot. Permissions follow the database role in the connection string, so restricting an agent to reads is a matter of pointing it at a read-only user.