pivot_table
Reshape database tables into pivot tables by specifying row columns, a column to pivot, and a value column with aggregation (sum, avg, count, min, max).
Instructions
Сводная таблица в стиле Excel (PIVOT).
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": {
"table_name": "<table_name>",
"row_columns": "<row_columns>",
"col_column": "<col_column>",
"value_column": "<value_column>"
},
"name": "pivot_table"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| col_column | Yes | ||
| table_name | Yes | ||
| row_columns | Yes | ||
| agg_function | No | sum | |
| value_column | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |