# RisingWave

This MCP server for Claude Code connects an agent to RisingWave for database queries and inspection. It can also track streaming job progress.

- MCP server · `type=mcp` · Claude Code, Codex, Cursor, GitHub Copilot, Windsurf (Devin Desktop), Cline, Zed, Gemini CLI · ★ 19 repo stars
- Author: risingwavelabs
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/risingwavelabs/risingwave-mcp
- Updated: 2026-11-09
- Security check: automated, 2026-11-17 (text) — warning: a command downloads a script from risingwave.com and runs it right away. Do not run such commands without an explicit yes from the human.
- HTML: https://affpapa.org/en/nevibecode/mcp/risingwave

## What it does

The server lets an agent query RisingWave, inspect database objects, and manage them. Its tools cover table and materialized view listings, SELECT queries, query plans, and streaming job monitoring.

A running RisingWave instance and the `RISINGWAVE_CONNECTION_STR` connection string are required. The listed setup runs the server in Docker over STDIO, using the `risingwavelabs/risingwave-mcp-server:0.1.1` image. Database permissions set the limits: the server exposes DDL and DML operations, so the configured user determines which ones the agent can perform.

## Requirements
- Needs: Docker
- Environment variables: `RISINGWAVE_CONNECTION_STR`, `MCP_TRANSPORT` — keys and tokens: ask the human for the values, never commit them or put them in shared files.

## Install

### Claude Code (native platform)

**Platform CLI**
```bash
claude mcp add --env RISINGWAVE_CONNECTION_STR=<RISINGWAVE_CONNECTION_STR> --env MCP_TRANSPORT=<MCP_TRANSPORT> --transport stdio risingwave -- docker run -i --rm -e RISINGWAVE_CONNECTION_STR -e MCP_TRANSPORT docker.io/risingwavelabs/risingwave-mcp-server:0.1.1
```
Replace <…> with your own values

### Codex

**Platform CLI**
```bash
codex mcp add risingwave --env RISINGWAVE_CONNECTION_STR=<RISINGWAVE_CONNECTION_STR> --env MCP_TRANSPORT=<MCP_TRANSPORT> -- docker run -i --rm -e RISINGWAVE_CONNECTION_STR -e MCP_TRANSPORT docker.io/risingwavelabs/risingwave-mcp-server:0.1.1
```
Replace <…> with your own values

### Cursor

**Config file**
File `.cursor/mcp.json`:
```json
{
    "mcpServers": {
        "risingwave": {
            "command": "docker",
            "args": [
                "run",
                "-i",
                "--rm",
                "-e",
                "RISINGWAVE_CONNECTION_STR",
                "-e",
                "MCP_TRANSPORT",
                "docker.io/risingwavelabs/risingwave-mcp-server:0.1.1"
            ],
            "env": {
                "RISINGWAVE_CONNECTION_STR": "<RISINGWAVE_CONNECTION_STR>",
                "MCP_TRANSPORT": "<MCP_TRANSPORT>"
            }
        }
    }
}
```
Replace <…> with your own values

### GitHub Copilot

**Config file**
File `.vscode/mcp.json`:
```json
{
    "servers": {
        "risingwave": {
            "type": "stdio",
            "command": "docker",
            "args": [
                "run",
                "-i",
                "--rm",
                "-e",
                "RISINGWAVE_CONNECTION_STR",
                "-e",
                "MCP_TRANSPORT",
                "docker.io/risingwavelabs/risingwave-mcp-server:0.1.1"
            ],
            "env": {
                "RISINGWAVE_CONNECTION_STR": "<RISINGWAVE_CONNECTION_STR>",
                "MCP_TRANSPORT": "<MCP_TRANSPORT>"
            }
        }
    }
}
```
Replace <…> with your own values

### Gemini CLI

**Platform CLI**
```bash
gemini mcp add -e RISINGWAVE_CONNECTION_STR=<RISINGWAVE_CONNECTION_STR> -e MCP_TRANSPORT=<MCP_TRANSPORT> risingwave docker run -i --rm -e RISINGWAVE_CONNECTION_STR -e MCP_TRANSPORT docker.io/risingwavelabs/risingwave-mcp-server:0.1.1
```
Replace <…> with your own values

## When to use it
- inspect tables and materialized views
- run a SELECT query against RisingWave
- examine a query execution plan
- track streaming job progress

## Example prompts
- List the tables and materialized views in RisingWave.
- Run a SELECT query to count rows in `orders`.
- Show the execution plan for this query.

## Similar
- [google-agents-cli-observability](https://affpapa.org/en/nevibecode/skills/google-agents-cli-observability.md) — skill · 585900 installs
- [xlsx](https://affpapa.org/en/nevibecode/skills/xlsx.md) — skill · 187223 installs
- [caveman-evidence-review](https://affpapa.org/en/nevibecode/skills/caveman-evidence-review.md) — skill · 128400 installs
- [migration](https://affpapa.org/en/nevibecode/skills/migration.md) — skill · 127700 installs
- [analytics](https://affpapa.org/en/nevibecode/skills/analytics.md) — skill · 97200 installs
- [ab-testing](https://affpapa.org/en/nevibecode/skills/ab-testing.md) — skill · 89300 installs

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
