show_create_table
Retrieve the CREATE TABLE or CREATE VIEW statement for a specific table or view in a MySQL or MariaDB database.
Instructions
Return SHOW CREATE TABLE / VIEW DDL for a table or view.
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": {
"table": "<table>"
},
"name": "show_create_table"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table or view name | |
| database | No | Schema name (optional if MYSQL_DATABASE is set) |