saiku: Command for GitHub Copilot

.github/prompts/review.md

review is a command for GitHub Copilot from spiculedata/saiku. It costs 13 tokens per session (455 once invoked), scanned A, original, Apache-2.0.

A pull-request review procedure for Saiku, using the repository's review rubric to compare claimed changes with the actual diff and check correctness, security, tests, and conventions.

In plain words
What is it for?
Use it to inspect Saiku pull requests, run focused Java or UI checks, and write a rubric-based review without changing the contributor's branch.
Why use it?
It prevents reviews from becoming improvised checklists and treats unfulfilled pull-request claims as findings.

Command for GitHub Copilot

Written for GitHub Copilot: a Copilot chat mode or prompt. Also seen: mentions AGENTS.md.

This is spiculedata/saiku's own configuration. It tells GitHub Copilot how to work on saiku itself, so it is not a mod to install elsewhere. Copy it as a starting point and replace the rules that are about this project. Everything saiku configures →

About the project

Saiku is an open-source semantic layer that represents data as analytical cubes for browser exploration, SQL queries, dashboards, and AI-agent access. It is for analysts and applications that need to query structured business data through Mondrian, Apache Calcite, REST, or MCP. The catalogue instruction helps agents work with Saiku.

spiculedata/saiku · 1,334 stars · on GitHub · saiku.bi

Reuse

Borrowing it

Nothing to install: this file belongs to spiculedata/saiku. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.

Copy the file
curl -O https://raw.githubusercontent.com/spiculedata/saiku/development/.github/prompts/review.md
Clone the repo
git clone --depth 1 https://github.com/spiculedata/saiku

Made for: GitHub Copilot.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for review

README.md
[![agentmods](https://agentmods.dev/badge/commands/spiculedata/saiku/review/github.svg)](https://agentmods.dev/commands/spiculedata/saiku/review)
Your own site
<a href="https://agentmods.dev/commands/spiculedata/saiku/review"><img src="https://agentmods.dev/badge/commands/spiculedata/saiku/review/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for review

Your own site · 80×15
<a href="https://agentmods.dev/commands/spiculedata/saiku/review"><img src="https://agentmods.dev/badge/commands/spiculedata/saiku/review.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 13 Only the description is in the session, so the agent can decide to use it. The body loads when it is invoked.
When invoked 455 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00013 $0.00455
Opus 5.5 $0.00005 $0.00182
Sonnet 5.5 $0.00003 $0.00091
Haiku 4.5 $0.00001 $0.00046

Measured 26d ago against content hash 15c87d52b161, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

review scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 26d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

.github/prompts/review.md · 32 lines

What it actually says

Review pull request ${input:pr:PR number or URL} on spiculedata/saiku using the rubric in docs/review-rubric.md. That rubric is the source of truth for the axes, the severity labels, and the report shape — read it first and follow it rather than improvising a checklist.

  1. Set up. gh pr view <pr> --json title,body,baseRefName,files and gh pr diff <pr>. Confirm baseRefName is development. Read docs/review-rubric.md and the Conventions specific to this repo section of AGENTS.md.
  2. Claim check. List what the PR body promises; list what the diff actually contains. A mismatch is a blocking finding on its own.
  3. Walk the axes. Correctness and security first and in full, then tests, then repo conventions, then compatibility, then hygiene. Skip axes the diff cannot raise rather than padding the report.
  4. Verify locally where cheap. Run the module's suite (mvn -pl <module> -am test -Dtest=<Class>) for a behaviour claim, and cd saiku-ui && npm run check && npm test for UI paths. Never lower .github/test-floors.json or .coverage-thresholds.json to make something pass. Do not push to the contributor's branch.
  5. Report. Blocking findings first, then non-blocking, then praise. One line per finding: severity — file:line — what breaks — what you'd accept instead. End with a one-line verdict: approve, approve with comments, or changes requested.

Do not merge, do not edit the PR body or the diff, and do not review a PR you authored. The human maintainer has the final call — see CONTRIBUTING.md § PR review.

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 26d ago First seen · 32 lines · 13 tokens per session scan A 15c87d52b161

Subscribe to this mod's changes

review is a command published in the GitHub repository spiculedata/saiku (1,334 stars, last pushed yesterday), licensed Apache-2.0. It adds 13 tokens to every session and 455 once invoked, about $0.0001 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-10-03.