Model Context Protocol Server for openGauss

Name: fastmcp-opengauss
Author: HowardQin

Features

Build with FastMCP 2.0 .
Support Stdio, SSE and Streamable-Http transporting method.
MCP server transporting method, listerning port, host and path are Configurable via command-line argument.
openGauss connection parameters are configurable via environment variables or .env files.

Deployment

Note: uv and python >= 3.12 is required.

git clone https://github.com/HowardQin/fastmcp-opengauss.git cd fastmcp-opengauss cp .env.example .env uv sync

openGauss connection parameters are loaded from .env, for example:

OPENGAUSS_HOST=172.32.148.228 OPENGAUSS_PORT=31001 OPENGAUSS_USER=app OPENGAUSS_PASSWORD=Postgres1234 OPENGAUSS_DBNAME=app

These parameters can be overwriten if identical environment variables are set.

Usage with Claude Desktop

Claude Desktop only supports Stdio mode, so we add the Stdio starting command in claude_desktop_config.json:

{ "mcpServers": { "openGauss": { "command": "uv", "args": [ "--directory", "C:\\Users\\qinh\\fastmcp-opengauss", "run", "server.py", "--transport", "stdio" ] } } }

Usage with CherryStudio

CherryStudio supports all three transporting modes: Stdio, SSE and Streamable-Http

Stdio:

CherryStudio with stdio fastmcp-opengauss Arguments:

--directory C:\Users\qinh\fastmcp-opengauss run server.py --transport=stdio

SSE:

For SSE transport mode, we need to start a standalone mcp server, run following command in project root directory, or in any directory with --directory specifing project root dir :

uv --directory C:\Users\qinh\fastmcp-opengauss run .\server.py --transport=sse --port=8000 --path=/sse --host=0.0.0.0

Then configure CherryStudio to connect to sse mcp server: CherryStudio with sse fastmcp-opengauss

Streamable-Http:

For Streamable-Http, we need to start a standalone mcp server, run following command in project root directory, or in any directory with --directory specifing project root dir:

uv --directory C:\Users\qinh\fastmcp-opengauss run .\server.py --transport=streamable-http --port=8000 --path=/mcp --host=0.0.0.0

Then configure CherryStudio to connect to streamable-http mcp server: CherryStudio with sse fastmcp-opengauss