describe_table
Retrieve a table's columns, types, primary key, and foreign-key relationships to author accurate multi-table queries. Force a live re-read with refresh=true.
Instructions
Describes one named table — its columns and types, primary key, and foreign-key relationships — scoped to just that table, so you can author a correct (possibly multi-table) query directly. Indexes and comments are not included. Set refresh=true to force a live re-read.
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": {
"db": "<db>",
"table": "<table>"
},
"name": "describe_table"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| db | Yes | Database name as defined in infra-mcp.yaml | |
| table | Yes | Table name; use schema.table to disambiguate across schemas | |
| refresh | No | Skip the in-memory cache and force a live re-read |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |