risingwavelabs/risingwave-mcp
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
list_databases
List all databases
show_tables
List tables in the current database
describe_table
Describe the schema of a table
run_select_query
Safely execute a SELECT query
explain_query
Get query execution plan without running it