openGauss MCP server build with FastMCP

Created By
HowardQina 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.
Overview

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.

Server Config

{
  "mcpServers": {
    "openGauss": {
      "command": "uv",
      "args": [
        "--directory",
        "C:\\your\\path\\fastmcp-opengauss",
        "run",
        "server.py",
        "--transport",
        "stdio"
      ]
    }
  }
}
Project Info
Created At
a year ago
Updated At
a year ago
Author Name
HowardQin
Star
-
Language
-
License
-
Category

Recommend Servers

View All
Knocksandbans.com
@MessingMedia

Knocks and bans tracks which players are injured, doubtful, or suspended. Via this MCP server, AI assistants can query that data directly — returning structured cards with full source links. Who Is This For? Football Fans Ask your AI assistant which players are injured or doubtful before this weekend's matches. Fantasy & Betting Analysts Get up-to-date availability data for squad building and informed predictions. Journalists & Bloggers Pull the latest injury roundups with source links to cite in match previews or reports. Available Tools top_player_statuses The 5 players most recently updated with an injured or doubtful status. Sorted by last update, newest first. Returns: name · injury · status · last updated · source link top_club_news The 3 clubs with the most recent editorial updates. Each card includes a short excerpt and a direct link to the club page. Returns: headline · excerpt · last updated · source link Try These Prompts Copy one of these into your AI assistant when the MCP server is connected. "Which players are currently injured or doubtful? Show me the 5 most recent updates with source links." "Give me the latest club squad news, with a summary and a link to each club page." "I'm building my fantasy team. Which key players are out or doubtful this week? Link me to the details." What You Get When your AI assistant connects to this MCP server, it can return: Player availability cards Recent injured or doubtful players, including status, update time, and a direct source link. Club update cards Latest club-level squad updates with a short summary and link to the full page. Additional Links MCP server URL for remote clients: https://www.knocksandbans.com/mcp/rpc

a day ago
Koreanpulse

42 minutes ago
Is Real Biz

19 hours ago