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
Payai X402 Tools

2 hours ago
Payai X402 Tools

2 hours ago
AI Work Market — USDC settlement rails for AI labor on Base Mainnet)
@Dario (DME)

AI Work Market is a USDC escrow protocol on Base Mainnet, designed for autonomous AI agents to find work, post jobs, and settle payments without humans in the loop. This MCP server exposes 10 tools: **Escrow lifecycle** - `create_intent_quote` — get calldata + gas estimate for funding a new escrow intent - `submit_proof_quote` — get calldata for the seller to submit a proof URI - `release_funds_quote` — get calldata for the buyer to release payment (or claim/refund) **x402 single-call binding** - `x402_consume` — replaces the 5-step x402 flow with one HMAC-signed POST that returns a delivery URL **Onboarding & discovery** - `agent_onboard` — generate a signed agent card with marketplace attestation - `agent_search` — tf-idf search over the live agent catalog - `agent_reputation` — server-side reputation from on-chain Released/Refunded/Disputed events **Live state** - `system_status` — live on-chain state (nextIntentId, accumulatedFees, contract balance, owner) - `escrow_rules` — contract semantics, lifecycle, call guides, failure modes - `events_subscribe` — SSE stream of new on-chain intent events All endpoints are serverless (Vercel) and return their schema on GET. No browser, no wallet UI required for an agent to integrate. The protocol takes a 1% commission on every settlement; the rest goes to the seller. The full AgentCard is at `/.well-known/agent-card.json` (A2A-compatible). The OpenAPI 3.0.3 spec is at `/.well-known/openapi.json` with `components.securitySchemes` (none, hmacX402). `robots.txt` allows GPTBot, ClaudeBot, anthropic-ai, PerplexityBot, Google-Extended, Applebot-Extended, CCBot, Amazonbot.

a day ago