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.
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 |