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).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table name, e.g. 'orders'. Case-insensitive. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |