Describe a table's columns
describe_tableReturns column names, types, nullability, primary keys, and defaults so you can inspect a table's schema before writing INSERT/UPDATE statements or WHERE filters.
Instructions
Return the column definitions of one table: name, type, nullable, primary_key and default for each column. Use it before writing INSERT/UPDATE statements or WHERE filters, once list_tables has given you the table name; it reads the schema, not the data, unless include_samples=true, which adds up to 5 distinct example values per column (one SELECT DISTINCT per column).
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": "describe_table"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table name, as returned by `list_tables`. | |
| database | No | Database name; omit to use the default database. | |
| include_samples | No | true = add up to 5 distinct sample values per column (default false). |