mysql_legacy_ddl
Execute one table-level DDL statement (CREATE, ALTER, DROP, TRUNCATE, RENAME) on legacy MySQL 5.0–5.6. Must set MYSQL_LEGACY_ALLOW_DDL=true; blocks database drops and views. Use insert/update/delete for row changes.
Instructions
Runs exactly one table-level CREATE, ALTER, DROP, TRUNCATE, or RENAME supplied in sql. Off unless MYSQL_LEGACY_ALLOW_DDL=true. DROP and TRUNCATE are irreversible. Rejects DROP DATABASE, views, and indexes. For row changes use mysql_legacy_insert, mysql_legacy_update, or mysql_legacy_delete.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"sql": "<sql>"
},
"name": "mysql_legacy_ddl"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | One MySQL table-level DDL statement: CREATE/ALTER/DROP/TRUNCATE/RENAME TABLE. |