docyrus-custom-query
Installation
SKILL.md
Docyrus Custom Query
A custom query record (tenant_custom_query) is a saved, named, parameterized
query template. Its body is DSQL (logical SQL over appSlug.dataSourceSlug
tables — the dsql_query column, successor to the legacy raw-SQL query), plus
declared output fields, declared runtime filters (parameters), and optional
pivot/calc config. Unlike an ad-hoc dsql query, a saved record is reusable,
parameterized, and callable from app code.
Two API surfaces back these records, both reached through docyrus dsql
subcommands:
- CRUD of the record → dev/architect API, scoped to an app.
- Run (execute) → reports API, by query id, with runtime filter values.
For the record/column shape, fields/filters JSON structure, {{filter}}
operators, and the run contract, see
references/custom-query-record-reference.md.