read_metadata_tool
Read metadata from Excel or CSV files to retrieve sheet structure, column details, null counts, unique counts, and suggested operations.
Instructions
Read file metadata (Excel or CSV) and return in MCP-compatible format.
Args: file_path: Absolute path to data file
Returns: dict: Structured metadata including: For Excel: - file_info: {type: "excel", sheet_count, sheet_names} - data: {sheets: [{sheet_name, rows, columns}]} For CSV: - file_info: {type: "csv", encoding, delimiter} - data: {rows, columns} Common: - status: SUCCESS/ERROR - columns contain: - name, type, examples - stats: null_count, unique_count - warnings, suggested_operations
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes |