get_ddl
Retrieve the CREATE statement for a table, view, function, trigger, or other database object using its connection, schema, and name. Use it to inspect or recreate object definitions.
Instructions
Returns the CREATE statement of a table, view, function, trigger or other object.
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": {
"connection": "<connection>",
"schema": "<schema>",
"name": "<name>"
},
"name": "get_ddl"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| kind | No | The kind from `list_objects` (`table`, `view`, `function`, ...); looked up when left out. | |
| name | Yes | The object's name, as `list_objects` shows it. | |
| schema | Yes | The object's schema. | |
| connection | Yes | The connection's name, as `list_connections` shows it. |