fastmcp-opengauss

HowardQin/fastmcp-opengauss

3.1

If you are the rightful owner of fastmcp-opengauss 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.

This document provides a comprehensive guide to deploying and using a Model Context Protocol (MCP) server for openGauss, built with FastMCP 2.0.

Model Context Protocol Server for openGauss

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:

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:

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: