describe_table
Inspect a table's columns, types, null rates, distinct counts, and sample data before writing queries.
Instructions
Describe one table: columns, types, null rates, distinct counts, examples.
Call this before writing a query against an unfamiliar table. It answers "what can I filter on, and what will be NULL" in a single round trip, which a raw information_schema dump does not.
Args: table (str): Table name, case-insensitive (e.g. 'orders').
Returns: str: Markdown containing: - header with row count and grain - a table of (column, type, null%, distinct, range, examples) - column definitions from the semantic layer - declared join keys - caveats that affect correctness
On failure: "Error: No table named 'x'. Available tables: ..."Examples: - Use when: "What columns does orders have?" - Use when: a query failed with an unknown-column error. - Don't use when: you need the distribution of one column (use profile_column instead).
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, e.g. 'orders'. Case-insensitive. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |