sql
Read-only SQL (DuckDB dialect) over the warehouse views: players, player_seasons (listed position / height by season), games, box_game, box_season, arc_season, arc_live, loki, loki_release, pac_season, skills_season (19 skill groups + season percentiles), onoff_season and lineups (incl. four factors and rebound shares), wowy, channels, xpts_rapm. One SELECT only, max 200 rows; PIVOT is not allowed (use max(x) filter (where ...)); quote "window" and "asof"; write every column alias with AS (a bare alias like load / value / rows / minutes is a syntax error). Use other tools first; call describe for column meanings.
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": {
"query": "<query>"
},
"name": "sql"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| query | Yes |