1.0.0npm · @sajithrw/mcp-mysql · current release
Observed 2026-08-18T00:23:27.675Z using mcpSecurity-inventory. Status: succeeded. Negotiated protocol: 2025-06-18.
{
"tools": {}
}| Tool | Category | Annotations | Risk |
|---|---|---|---|
mysql_connectConnect to a MySQL database with provided connection parametersInput schema{
"type": "object",
"properties": {
"host": {
"type": "string",
"description": "MySQL server hostname or IP address"
},
"port": {
"type": "number",
"description": "MySQL server port (default: 3306)",
"default": 3306
},
"user": {
"type": "string",
"description": "Database username"
},
"password": {
"type": "string",
"description": "Database password"
},
"database": {
"type": "string",
"description": "Database name (optional)"
},
"ssl": {
"type": "boolean",
"description": "Use SSL connection (default: false)",
"default": false
}
},
"required": [
"host",
"user",
"password"
]
} | — | — · — | — |
mysql_describe_tableGet the structure/schema of a specific tableInput schema{
"type": "object",
"properties": {
"table": {
"type": "string",
"description": "Table name to describe"
},
"database": {
"type": "string",
"description": "Database name (uses current database if not specified)"
}
},
"required": [
"table"
]
} | — | — · — | — |
mysql_disconnectDisconnect from the MySQL databaseInput schema{
"type": "object",
"properties": {}
} | — | — · — | — |
mysql_get_table_statsGet statistics about a table (row count, size, etc.)Input schema{
"type": "object",
"properties": {
"table": {
"type": "string",
"description": "Table name to get statistics for"
},
"database": {
"type": "string",
"description": "Database name (uses current database if not specified)"
}
},
"required": [
"table"
]
} | — | — · — | — |
mysql_list_databasesList all databases on the MySQL serverInput schema{
"type": "object",
"properties": {}
} | — | — · — | — |
mysql_list_tablesList all tables in the current or specified databaseInput schema{
"type": "object",
"properties": {
"database": {
"type": "string",
"description": "Database name (uses current database if not specified)"
}
}
} | — | — · — | — |
mysql_queryExecute a SQL query on the connected MySQL databaseInput schema{
"type": "object",
"properties": {
"query": {
"type": "string",
"description": "SQL query to execute"
},
"parameters": {
"type": "array",
"description": "Parameters for prepared statement (optional)",
"items": {
"type": "string"
}
}
},
"required": [
"query"
]
} | — | — · — | — |
mysql_show_indexesShow indexes for a specific tableInput schema{
"type": "object",
"properties": {
"table": {
"type": "string",
"description": "Table name to show indexes for"
},
"database": {
"type": "string",
"description": "Database name (uses current database if not specified)"
}
},
"required": [
"table"
]
} | — | — · — | — |