← MCP MySQL Server

MCP MySQL Server 0.2.4

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

4
Tools
0
Resources
0
Templates
0
Prompts

Observation

Observed 2026-08-17T21:29:08.207Z using mcpSecurity-inventory. Status: succeeded. Negotiated protocol: 2024-11-05.

Server capabilities
{
  "tools": {}
}

Tools 4

ToolCategoryAnnotationsRisk
connect_dbConnect to MySQL database (optional if environment variables are set)
Input schema
{
  "type": "object",
  "properties": {
    "host": {
      "type": "string",
      "description": "Database host"
    },
    "user": {
      "type": "string",
      "description": "Database user"
    },
    "password": {
      "type": "string",
      "description": "Database password"
    },
    "database": {
      "type": "string",
      "description": "Database name"
    },
    "port": {
      "type": "number",
      "description": "Database port (optional)"
    }
  },
  "required": [
    "host",
    "user",
    "password",
    "database"
  ]
}
— · —
describe_tableGet table structure
Input schema
{
  "type": "object",
  "properties": {
    "table": {
      "type": "string",
      "description": "Table name"
    }
  },
  "required": [
    "table"
  ]
}
— · —
list_tablesList all tables in the database
Input schema
{
  "type": "object",
  "properties": {
    "random_string": {
      "type": "string",
      "description": "Dummy parameter for no-parameter tools"
    }
  },
  "required": []
}
— · —
queryExecute a SELECT query
Input schema
{
  "type": "object",
  "properties": {
    "sql": {
      "type": "string",
      "description": "SQL SELECT query"
    },
    "params": {
      "type": "array",
      "items": {
        "type": [
          "string",
          "number",
          "boolean",
          "null"
        ]
      },
      "description": "Query parameters (optional)"
    }
  },
  "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.