Describe table
describe_tableInspect a PostgreSQL table’s columns, primary and foreign keys, constraints, and indexes to understand its schema before writing queries.
Instructions
Columns (type, nullability, default, comment), primary key, foreign keys, unique and check constraints, and indexes of one table.
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" or "schema.table" |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| kind | Yes | ||
| name | Yes | ||
| schema | Yes | ||
| columns | Yes | ||
| comment | Yes | ||
| indexes | Yes | ||
| totalSize | Yes | ||
| primaryKey | Yes | ||
| foreignKeys | Yes | ||
| estimatedRows | Yes | ||
| checkConstraints | Yes | ||
| uniqueConstraints | Yes |