Query Cache
query_cacheRun read-only DuckDB SQL over cached Brazilian Central Bank SGS time series to filter, aggregate, and analyze local parquet data without fetching fresh observations.
Instructions
Run read-only SQL across every cached series (DuckDB over parquet files).
Example: SELECT series_name, avg(value) FROM cached_series WHERE ref_date >= DATE '2020-01-01' GROUP BY 1 ORDER BY 2 DESC.
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": {
"sql": "<sql>"
},
"name": "query_cache"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | Read-only DuckDB SQL over the local parquet cache. Available views: cached_series(ref_date, value, series_id, series_name, unit, frequency, source, fetched_at), cached_queries (same columns), series_metadata(series_id, series_name, coverage, rows, updated_at). | |
| limit | No | Maximum rows returned (1..100000). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||