risingwave-mcp

risingwavelabs/risingwave-mcp

3.4

If you are the rightful owner of risingwave-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

RisingWave MCP Server is a lightweight Model Context Protocol server designed to facilitate natural language querying and management of RisingWave streaming databases through AI assistants.

RisingWave MCP Server is a cutting-edge solution that leverages the Model Context Protocol (MCP) to enable seamless interaction with RisingWave streaming databases using natural language. This server is built on top of FastMCP and risingwave-py, ensuring high-performance communication via STDIO transport. It integrates effortlessly with popular AI assistants like VS Code Copilot and Claude Desktop, allowing users to query and manage their databases in real-time. Whether running a local instance or utilizing RisingWave Cloud, users can easily set up and connect to their databases. The server supports a wide range of tools for database management, including listing databases, showing tables, and executing queries. With its robust feature set and easy integration, RisingWave MCP Server is an ideal choice for developers and data analysts looking to harness the power of AI-driven database management.

Features

  • Real-time access to RisingWave tables, materialized views, and streaming data
  • Built on FastMCP and risingwave-py with high-performance STDIO transport
  • Seamless integration with VS Code Copilot, Claude Desktop, and other MCP-compatible tools

Usages

usage with VS Code Copilot connection string

{
  "servers": {
    "risingwave-mcp": {
      "type": "stdio",
      "command": "python",
      "args": ["path_to/risingwave-mcp/src/main.py"],
      "env": {
        "RISINGWAVE_CONNECTION_STR": "postgresql://root:root@localhost:4566/dev"
      }
    }
  }
}

usage with VS Code Copilot individual parameters

{
  "servers": {
    "risingwave-mcp": {
      "type": "stdio",
      "command": "python",
      "args": ["path_to/risingwave-mcp/src/main.py"],
      "env": {
        "RISINGWAVE_HOST": "localhost",
        "RISINGWAVE_PORT": "4566",
        "RISINGWAVE_USER": "root",
        "RISINGWAVE_PASSWORD": "root",
        "RISINGWAVE_DATABASE": "dev",
        "RISINGWAVE_SSLMODE": "disable"
      }
    }
  }
}

usage with Claude Desktop

{
  "mcpServers": {
    "risingwave-mcp": {
      "command": "python",
      "args": ["path_to/risingwave-mcp/src/main.py"],
      "env": {
        "RISINGWAVE_CONNECTION_STR": "postgresql://root:root@localhost:4566/dev"
      }
    }
  }
}

Tools

  1. list_databases

    List all databases

  2. show_tables

    List tables in the current database

  3. describe_table

    Describe the schema of a table

  4. run_select_query

    Safely execute a SELECT query

  5. explain_query

    Get query execution plan without running it