基于java的stdio的mysql-mcp-server

toolList

• db_read_query
• db_write_dml
• db_write_ddl
• db_explain_plan
• db_slow_query_log
• db_analyze_natural

[
  {
    "name": "db_read_query",
    "description": "执行只读 SELECT / SHOW / EXPLAIN，自动追加 LIMIT，返回表格式 JSON。",
    "inputSchema": {
      "type": "object",
      "properties": {
        "sql": { "type": "string", "description": "只读 SQL 语句" },
        "maxRows": { "type": "integer", "default": 200, "minimum": 1, "maximum": 2000 }
      },
      "required": ["sql"]
    }
  },
  {
    "name": "db_write_dml",
    "description": "执行 INSERT / UPDATE / DELETE；支持批量，返回受影响行数。",
    "inputSchema": {
      "type": "object",
      "properties": {
        "sql": { "type": "string", "description": "DML 语句或 ; 分隔的多条语句" },
        "params": { "type": "array", "items": {}, "description": "预编译参数二维数组，可选" }
      },
      "required": ["sql"]
    }
  },
  {
    "name": "db_write_ddl",
    "description": "执行 CREATE / ALTER / DROP 等 DDL，先语法预检，再执行。",
    "inputSchema": {
      "type": "object",
      "properties": {
        "sql": { "type": "string", "description": "DDL 语句" },
        "dryRun": { "type": "boolean", "default": true, "description": "true=仅语法校验不执行" }
      },
      "required": ["sql"]
    }
  },
  {
    "name": "db_explain_plan",
    "description": "获取 SQL 的执行计划（EXPLAIN / EXPLAIN ANALYZE）。",
    "inputSchema": {
      "type": "object",
      "properties": {
        "sql": { "type": "string" },
        "analyze": { "type": "boolean", "default": false }
      },
      "required": ["sql"]
    }
  },
  {
    "name": "db_slow_query_log",
    "description": "拉取最近 N 条慢查询（默认 >1 s）。",
    "inputSchema": {
      "type": "object",
      "properties": {
        "limit": { "type": "integer", "default": 50, "maximum": 500 }
      }
    }
  },
  {
    "name": "db_analyze_natural",
    "description": "把自然语言转成 SQL（可选 NLP 接口），返回可执行语句与风险提示。",
    "inputSchema": {
      "type": "object",
      "properties": {
        "question": { "type": "string", "description": "自然语言查询需求" },
        "schemaHint": { "type": "string", "description": "库/表范围提示，可选" }
      },
      "required": ["question"]
    }
  }
]