openGauss MCP server build with FastMCP

@HowardQin

a year ago

An openGauss database MCP server build with FastMCP, Supporting Stdio, SSE and Streamable-Http transporting mode, 2 resources: get_schemas, get_tables 3 tools: execute_query, get_table_definition, list_tables_in_current_schema, get_current_user_and_schema Can read and write openGauss database.

概览工具评论

概览

Model Context Protocol Server for openGauss

Build with FastMCP 2.0 written in Python.
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.
2 resources: get_schemas, get_tables
3 tools: execute_query, get_table_definition, list_tables_in_current_schema, get_current_user_and_schema
Can read and write openGauss database.

在 Playground 中尝试

服务器配置

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

Build with ShipAny.