a4f391accee40fc987d5590fee83b93d1a514541source_git · kevinbin/mcp-mysql-server · current release
Observed 2026-08-25T21:09:51.570Z using mcpSecurity-inventory. Status: succeeded. Negotiated protocol: 2024-11-05.
{
"tools": {}
}| Tool | Category | Annotations | Risk |
|---|---|---|---|
add_columnAdd a new column to existing tableInput schema{
"type": "object",
"properties": {
"table": {
"type": "string"
},
"field": {
"type": "object",
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"length": {
"type": "number",
"optional": true
},
"nullable": {
"type": "boolean",
"optional": true
},
"default": {
"type": [
"string",
"number",
"null"
],
"optional": true
}
},
"required": [
"name",
"type"
]
}
},
"required": [
"table",
"field"
]
} | — | — · — | — |
connect_dbConnect to MySQL database using URL or configInput schema{
"type": "object",
"properties": {
"url": {
"type": "string",
"description": "Database URL (mysql://user:pass@host:port/db)",
"optional": true
},
"workspace": {
"type": "string",
"description": "Project workspace path",
"optional": true
},
"host": {
"type": "string",
"optional": true
},
"user": {
"type": "string",
"optional": true
},
"password": {
"type": "string",
"optional": true
},
"database": {
"type": "string",
"optional": true
}
}
} | — | — · — | — |
create_tableCreate a new table in the databaseInput schema{
"type": "object",
"properties": {
"table": {
"type": "string",
"description": "Table name"
},
"fields": {
"type": "array",
"items": {
"type": "object",
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"length": {
"type": "number",
"optional": true
},
"nullable": {
"type": "boolean",
"optional": true
},
"default": {
"type": [
"string",
"number",
"null"
],
"optional": true
},
"autoIncrement": {
"type": "boolean",
"optional": true
},
"primary": {
"type": "boolean",
"optional": true
}
},
"required": [
"name",
"type"
]
}
},
"indexes": {
"type": "array",
"items": {
"type": "object",
"properties": {
"name": {
"type": "string"
},
"columns": {
"type": "array",
"items": {
"type": "string"
}
},
"unique": {
"type": "boolean",
"optional": true
}
},
"required": [
"name",
"columns"
]
},
"optional": true
}
},
"required": [
"table",
"fields"
]
} | — | — · — | — |
describe_tableGet table structureInput schema{
"type": "object",
"properties": {
"table": {
"type": "string",
"description": "Table name"
}
},
"required": [
"table"
]
} | — | — · — | — |
executeExecute an INSERT, UPDATE, or DELETE queryInput schema{
"type": "object",
"properties": {
"sql": {
"type": "string",
"description": "SQL query (INSERT, UPDATE, DELETE)"
},
"params": {
"type": "array",
"items": {
"type": [
"string",
"number",
"boolean",
"null"
]
},
"description": "Query parameters (optional)"
}
},
"required": [
"sql"
]
} | — | — · — | — |
list_tablesList all tables in the databaseInput schema{
"type": "object",
"properties": {},
"required": []
} | — | — · — | — |
queryExecute a SELECT queryInput 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"
]
} | — | — · — | — |