write-aql
Installation
SKILL.md
Writing AQL to answer a question
Goal: turn the user's analytics request into a correct AQL query, verify it, and run it.
Authoring mode
Plugin setting: ${user_config.authoring_mode}
Write AQL yourself (Self mode below) only when the authoring mode is self. It's set by, in priority order: the user in this conversation, the project's instructions (e.g. CLAUDE.md, AGENTS.md, Cursor rules — "Holistics authoring mode: self"), then the plugin setting above. Otherwise — including when the plugin setting above is an unfilled ${…} placeholder — use Holistics AI mode.
Decide the mode now, before anything else. In self mode, follow Self mode and do NOT call generate_aql.
Prerequisites
- Set up Holistics MCP. If you call the tools through the
holistics mcpCLI instead, follow Calling tools via the CLI in thesetup-amql-developmentskill — parameters are one JSON object (for AQL/AML, a JSON file piped on stdin), neverkey=value. - Know the dataset. Use
fetch_datasetto list its models, fields, and metrics — that's yourdataset_fields. Use only those, with their EXACT names. In an AMQL repo, also read the dataset/model.amlfiles for definitions and descriptions.