← MCP MySQL Server

MCP MySQL Server 3.1.0

npm · @liangshanli/mcp-server-mysql · current release

5
Tools
0
Resources
0
Templates
0
Prompts

Observation

Observed 2026-08-17T10:20:45.353Z using mcpSecurity-inventory. Status: succeeded. Negotiated protocol: 2025-06-18.

Server capabilities
{
  "tools": {
    "listChanged": false
  }
}

Tools 5

ToolCategoryAnnotationsRisk
check_permissionsCheck database permissions for DDL, DROP, DELETE and other operations. Returns detailed permission status including readonly mode restrictions (only SELECT and SHOW allowed when readonly is enabled)
Input schema
{
  "type": "object",
  "properties": {}
}
— · —
get_database_infoGet database information, including database list, table list and configuration information
Input schema
{
  "type": "object",
  "properties": {}
}
— · —
get_ddl_sql_logsGet DDL SQL operation logs
Input schema
{
  "type": "object",
  "properties": {
    "limit": {
      "type": "number",
      "description": "Limit count, default 50, max 500"
    },
    "offset": {
      "type": "number",
      "description": "Offset, default 0"
    }
  }
}
— · —
get_operation_logsGet operation logs
Input schema
{
  "type": "object",
  "properties": {
    "limit": {
      "type": "number",
      "description": "Limit count, default 50"
    },
    "offset": {
      "type": "number",
      "description": "Offset, default 0"
    }
  }
}
— · —
sql_queryExecute SQL query, supports DDL and DML operations
Input schema
{
  "type": "object",
  "properties": {
    "sql": {
      "type": "string",
      "description": "SQL statement to execute"
    }
  },
  "required": [
    "sql"
  ]
}
— · —

Resources 0

Resource templates 0

Prompts 0

Let’s talk about MCP security.

Share your details and our security team will contact you.