describe_table
Analyze spreadsheet structure to reveal column names, data types, row counts, and sample data for effective SQL query planning.
Instructions
Inspect the structure of a sheet treated as a database table.
Returns column names, inferred data types (text, integer, number, boolean, date), total row count, and sample values from the first 3 data rows. Use this before writing SQL queries to understand the available columns and their types.
When sheet is omitted, returns a list of descriptions for all sheets.
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": {
"file": "<file>"
},
"name": "describe_table"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | Yes | Path to the spreadsheet file | |
| sheet | No | Sheet name to describe. If omitted, describes all sheets in the workbook. | |
| header_row | No | 1-based row number containing column headers. Defaults to 1. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |