table
Profile and query CSV/TSV/JSON/JSONL/Markdown data with filters, selections, aggregates, sorting, joins, and limits; output in multiple formats.
Instructions
Query CSV/TSV/JSON/JSONL/Markdown tables. No options = profile. where ["age > 30","city = Berlin","name ~ ^A","x is empty"], select, group_by + aggregate (count sum avg min max median count_distinct list; "sum(x) as t"), sort ["x desc"], distinct, join_path+on, limit, output, out_path.
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "table"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| on | No | col or left=right | |
| how | No | ||
| path | No | or a file | |
| sort | No | ||
| text | No | ||
| limit | No | ||
| where | No | ||
| format | No | ||
| output | No | ||
| select | No | ||
| distinct | No | ||
| group_by | No | ||
| out_path | No | ||
| aggregate | No | ||
| delimiter | No | ||
| join_path | No | ||
| no_header | No | ||
| overwrite | No |