--- name: pp-redmine description: "Every Redmine feature, plus a local mirror that finally answers the cross-project questions the Roadmap page never could. Trigger phrases: `list my redmine issues`, `what's assigned to me in redmine`, `check redmine roadmap burndown`, `who's overloaded on this redmine project`, `find stale redmine issues`, `log time in redmine`, `use redmine`, `run redmine`." author: "" license: "Apache-2.0" argument-hint: " [args] | install cli|mcp" allowed-tools: "Read Bash" metadata: openclaw: requires: bins: - redmine-pp-cli install: - kind: go bins: [redmine-pp-cli] module: github.com/mvanhorn/printing-press-library/library/project-management/redmine/cmd/redmine-pp-cli --- # Redmine — Printing Press CLI ## Prerequisites: Install the CLI This skill drives the `redmine-pp-cli` binary. **You must verify the CLI is installed before invoking any command from this skill.** If it is missing, install it first: 1. Install via the Printing Press installer. It defaults binaries to `$HOME/.local/bin` on macOS/Linux and `%LOCALAPPDATA%\Programs\PrintingPress\bin` on Windows: ```bash npx -y @mvanhorn/printing-press-library install redmine --cli-only ``` 2. Verify: `redmine-pp-cli --version` 3. Ensure the reported install directory is on `$PATH` for the agent/runtime that will invoke this skill. If the `npx` install fails (no Node, offline, etc.), fall back to a direct Go install (requires Go 1.26.6 or newer). This installs into `$GOPATH/bin` (default `$HOME/go/bin`), so add that directory to `$PATH` instead: ```bash go install github.com/mvanhorn/printing-press-library/library/project-management/redmine/cmd/redmine-pp-cli@latest ``` If `--version` reports "command not found" after install, the runtime cannot see the binary directory on `$PATH`. Do not proceed with skill commands until verification succeeds. Redmine's REST API is deeply relational but strictly request-per-entity — no burndown endpoint, no workload endpoint, no staleness concept. This CLI absorbs the full REST surface (issues, projects, time entries, wiki, versions, memberships, and more) and adds a synced SQLite mirror underneath, so burndown, workload, cycle-time, and blocker-chain questions resolve to one local query instead of dozens of live requests. ## When to Use This CLI Use this CLI for any Redmine workflow: triaging and updating issues, logging and reporting time, planning releases against versions, managing projects/users/memberships, and — uniquely — cross-entity reporting (burndown, workload, cycle-time, staleness, blocker chains) that Redmine's own REST API and web UI cannot answer in one call. Good for agents scripting bulk issue updates, CI jobs that log time entries, and periodic digest/health checks. ## Anti-triggers Do not use this CLI for: - Do not use this CLI for real-time Gantt chart rendering or rich visual roadmap graphics — it reports the same underlying data as text/JSON, not a visual timeline. - Do not use this CLI to edit wiki page rich text/attachments inline — wiki update accepts plain Textile/Markdown body text, not a WYSIWYG diff. - Do not use this CLI for Redmine account self-service (password reset, 2FA enrollment) — that requires the web login UI. - Do not use this CLI to sync or mirror issues with GitHub/GitLab/Jira — it only talks to a single Redmine instance's REST API. ## Unique Capabilities These capabilities aren't available in any other tool for this API. ### Local state that compounds - **`roadmap burndown`** — See open/closed issue counts, average completion, and logged-vs-estimated hours for a release version — the Roadmap page Redmine never exposed as an API. _Reach for this before a release-readiness call instead of hand-counting issues in the web UI._ ```bash redmine-pp-cli roadmap burndown 1.0 --project demo --json ``` - **`workload`** — See every assignee's open-issue count and estimated hours in one aggregate view, with a flag for anyone over threshold. _Use this before sprint planning to catch overload without opening every engineer's issue list one by one._ ```bash redmine-pp-cli workload --project demo --threshold 5 --json ``` - **`issues stale`** — Find open issues nobody has touched in N days — Redmine has no built-in staleness concept. _Use this for triage sweeps to surface issues that fell through the cracks, not recently active ones._ ```bash redmine-pp-cli issues stale --project demo --days 14 --json ``` - **`digest`** — A personal activity report of what was created, updated, or closed in a time window, optionally scoped to issues assigned to or watched by you. _Use this for a 'what did I miss' catch-up instead of paging through each project's activity feed by hand._ ```bash redmine-pp-cli digest --since 7d --mine --json ``` - **`issues cycle-time`** — Average days from creation to close, grouped by tracker or project — real duration math the API can't do. _Use this to spot which issue types are taking longer than they should to resolve._ ```bash redmine-pp-cli issues cycle-time --group-by tracker --project demo --json ``` - **`issues blockers`** — Walk the full multi-hop 'blocks'/'blocked by' dependency chain for an issue, not just its direct relations. _Use this before starting work on an issue to confirm it isn't blocked three hops away by something you haven't seen yet._ ```bash redmine-pp-cli issues blockers 3 --depth 3 --json ``` ## HTTP Transport This CLI uses Chrome-compatible HTTP transport for browser-facing endpoints. It does not require a resident browser process for normal API calls. ## Command Reference **attachments** — Status: Beta, Availability: 1.3 - `redmine-pp-cli attachments delete` — Delete attachment - `redmine-pp-cli attachments download-file` — Undocumented: This operation is not listed in the official documentation. - `redmine-pp-cli attachments download-thumbnail` — Undocumented: This operation is not listed in the official documentation. - `redmine-pp-cli attachments get` — Show attachment - `redmine-pp-cli attachments update` — Update attachment **custom-fields-json** — Manage custom fields json - `redmine-pp-cli custom-fields-json` — List custom fields **enumerations** — Status: Alpha, Availability: 2.2 - `redmine-pp-cli enumerations get-document-categories` — List document categories - `redmine-pp-cli enumerations get-issue-priorities` — List issue priorities - `redmine-pp-cli enumerations get-time-entry-activities` — List time entry activities **groups** — Status: Alpha, Availability: 2.1 - `redmine-pp-cli groups delete` — Delete group - `redmine-pp-cli groups get` — Show group - `redmine-pp-cli groups update` — Update group **groups-json** — Manage groups json - `redmine-pp-cli groups-json create-group` — Create group - `redmine-pp-cli groups-json get-groups` — List groups **issue-categories** — Status: Alpha, Availability: 1.3 - `redmine-pp-cli issue-categories delete-issue-category` — Delete issue category - `redmine-pp-cli issue-categories get-issue-category` — Show issue category - `redmine-pp-cli issue-categories update-issue-category` — Update issue category **issue-statuses-json** — Manage issue statuses json - `redmine-pp-cli issue-statuses-json` — List issue statuses **issues** — Status: Stable, Availability: 1.0 - `redmine-pp-cli issues delete` — Delete issue - `redmine-pp-cli issues get` — Show issue - `redmine-pp-cli issues update` — Update issue **issues-json** — Manage issues json - `redmine-pp-cli issues-json create-issue` — Create issue - `redmine-pp-cli issues-json get-issues` — List issues **journals** — Status: Alpha, Availability: 5.0 - `redmine-pp-cli journals ` — The journal is deleted when it is updated with empty `notes` and has no property changes (`details`). **memberships** — Manage memberships - `redmine-pp-cli memberships delete` — Delete membership - `redmine-pp-cli memberships get` — Show membership - `redmine-pp-cli memberships update` — Warning **my** — Manage my - `redmine-pp-cli my get-account` — Show my account - `redmine-pp-cli my update-account` — Requests authenticated via OAuth are rejected with 403, regardless of the token's scopes. **news** — Status: Stable, Availability: 1.1 - `redmine-pp-cli news delete` — Delete news - `redmine-pp-cli news get` — Show news - `redmine-pp-cli news update` — Update news **news-json** — Manage news json - `redmine-pp-cli news-json` — List news **projects** — Status: Stable, Availability: 1.0 - `redmine-pp-cli projects delete` — Delete project - `redmine-pp-cli projects get` — Show project - `redmine-pp-cli projects update` — Update project **projects-json** — Manage projects json - `redmine-pp-cli projects-json create-project` — Create project - `redmine-pp-cli projects-json get-projects` — List projects **queries-json** — Manage queries json - `redmine-pp-cli queries-json` — List queries **relations** — Manage relations - `redmine-pp-cli relations delete-issue` — Delete issue relation - `redmine-pp-cli relations get-issue` — Show issue relation **roles** — Status: Alpha, Availability: 1.4 - `redmine-pp-cli roles ` — Show role **roles-json** — Manage roles json - `redmine-pp-cli roles-json` — List roles **search-json** — Manage search json - `redmine-pp-cli search-json` — Search **time-entries** — Status: Stable, Availability: 1.1 - `redmine-pp-cli time-entries delete-time-entry` — Delete time entry - `redmine-pp-cli time-entries get-time-entry` — Show time entry - `redmine-pp-cli time-entries update-time-entry` — Update time entry **time-entries-json** — Manage time entries json - `redmine-pp-cli time-entries-json create-time-entry` — Create time entry - `redmine-pp-cli time-entries-json get-time-entries` — List time entries **trackers-json** — Manage trackers json - `redmine-pp-cli trackers-json` — List trackers **uploads-json** — Manage uploads json - `redmine-pp-cli uploads-json` — Upload attachment file **users** — Status: Stable, Availability: 1.1 - `redmine-pp-cli users delete` — Delete user - `redmine-pp-cli users get` — Show user - `redmine-pp-cli users get-current` — Show current user - `redmine-pp-cli users update` — Update user **users-json** — Manage users json - `redmine-pp-cli users-json create-user` — Create user - `redmine-pp-cli users-json get-users` — List users **versions** — Status: Alpha, Availability: 1.3 - `redmine-pp-cli versions delete` — Delete version - `redmine-pp-cli versions get` — Show version - `redmine-pp-cli versions update` — Update version ## Freshness Contract This printed CLI owns bounded freshness only for registered store-backed read command paths. In `--data-source auto` mode, those paths check `sync_state` and may run a bounded refresh before reading local data. `--data-source local` never refreshes. `--data-source live` reads the API and does not mutate the local store. Set `REDMINE_NO_AUTO_REFRESH=1` to skip the freshness hook without changing source selection. Covered paths: - `redmine-pp-cli custom-fields-json` - `redmine-pp-cli custom-fields-json get` - `redmine-pp-cli custom-fields-json list` - `redmine-pp-cli custom-fields-json search` - `redmine-pp-cli enumerations` - `redmine-pp-cli enumerations get` - `redmine-pp-cli enumerations list` - `redmine-pp-cli enumerations search` - `redmine-pp-cli enumerations-issue-priorities-json` - `redmine-pp-cli enumerations-issue-priorities-json get` - `redmine-pp-cli enumerations-issue-priorities-json list` - `redmine-pp-cli enumerations-issue-priorities-json search` - `redmine-pp-cli enumerations-time-entry-activities-json` - `redmine-pp-cli enumerations-time-entry-activities-json get` - `redmine-pp-cli enumerations-time-entry-activities-json list` - `redmine-pp-cli enumerations-time-entry-activities-json search` - `redmine-pp-cli groups-json` - `redmine-pp-cli groups-json get` - `redmine-pp-cli groups-json list` - `redmine-pp-cli groups-json search` - `redmine-pp-cli issue-statuses-json` - `redmine-pp-cli issue-statuses-json get` - `redmine-pp-cli issue-statuses-json list` - `redmine-pp-cli issue-statuses-json search` - `redmine-pp-cli issues-json` - `redmine-pp-cli issues-json get` - `redmine-pp-cli issues-json list` - `redmine-pp-cli issues-json search` - `redmine-pp-cli memberships-json` - `redmine-pp-cli memberships-json get` - `redmine-pp-cli memberships-json list` - `redmine-pp-cli memberships-json search` - `redmine-pp-cli news-json` - `redmine-pp-cli news-json get` - `redmine-pp-cli news-json list` - `redmine-pp-cli news-json search` - `redmine-pp-cli projects-json` - `redmine-pp-cli projects-json get` - `redmine-pp-cli projects-json list` - `redmine-pp-cli projects-json search` - `redmine-pp-cli queries-json` - `redmine-pp-cli queries-json get` - `redmine-pp-cli queries-json list` - `redmine-pp-cli queries-json search` - `redmine-pp-cli roles-json` - `redmine-pp-cli roles-json get` - `redmine-pp-cli roles-json list` - `redmine-pp-cli roles-json search` - `redmine-pp-cli search-json` - `redmine-pp-cli search-json get` - `redmine-pp-cli search-json list` - `redmine-pp-cli search-json search` - `redmine-pp-cli time-entries-json` - `redmine-pp-cli time-entries-json get` - `redmine-pp-cli time-entries-json list` - `redmine-pp-cli time-entries-json search` - `redmine-pp-cli trackers-json` - `redmine-pp-cli trackers-json get` - `redmine-pp-cli trackers-json list` - `redmine-pp-cli trackers-json search` - `redmine-pp-cli users-json` - `redmine-pp-cli users-json get` - `redmine-pp-cli users-json list` - `redmine-pp-cli users-json search` When JSON output uses the generated provenance envelope, freshness metadata appears at `meta.freshness`. Treat it as current-cache freshness for the covered command path, not a guarantee of complete historical backfill or API-specific enrichment. ### Finding the right command When you know what you want to do but not which command does it, ask the CLI directly: ```bash redmine-pp-cli which "" ``` `which` resolves a natural-language capability query to the best matching command from this CLI's curated feature index. Exit code `0` means at least one match; exit code `2` means no confident match — fall back to `--help` or use a narrower query. ## Recipes ### Triage open bugs with a narrow agent payload ```bash redmine-pp-cli issues-json get-issues --project-id demo --status-id o --tracker-id 1 --agent --select id,subject,tracker.name,priority.name ``` Nested tracker/priority/status objects on every issue add up fast across a full project; --select keeps only the fields an agent actually needs to triage. ### Find issues nobody has touched in two weeks ```bash redmine-pp-cli issues stale --project demo --days 14 --json ``` Surfaces open issues with no recent activity, which Redmine itself has no concept of. ### See who's carrying the most open work ```bash redmine-pp-cli workload --project demo --threshold 5 ``` One command instead of opening each engineer's assigned-issue list to eyeball the count. ### Trace why an issue is blocked ```bash redmine-pp-cli issues blockers 3 --depth 3 ``` Walks the full transitive blocker chain instead of clicking through each linked issue one hop at a time. ### Check release readiness for a version ```bash redmine-pp-cli roadmap burndown 1.0 --project demo --json ``` Open/closed counts, average done_ratio, and hours variance for the version in one call, replacing a manual Roadmap-page count. ## Auth Setup Redmine is self-hosted, so two things are required instead of just a key: REDMINE_URL (your instance's base URL) and REDMINE_API_KEY (from your account's My Account page, or Administration > Settings > API for admins). Both are sent as-is — REDMINE_API_KEY becomes the X-Redmine-API-Key header on every request. Run `redmine-pp-cli doctor` to verify setup. ## Agent Mode Add `--agent` to any command. Expands to: `--json --compact --no-input --no-color`. - **Pipeable** — JSON on stdout, errors on stderr - **Filterable** — `--select` keeps a subset of fields. Dotted paths descend into nested structures; arrays traverse element-wise. Critical for keeping context small on verbose APIs: ```bash redmine-pp-cli attachments get mock-value --agent --select attachment ``` - **Previewable** — `--dry-run` shows the request without sending - **Offline-friendly** — sync/search commands can use the local SQLite store when available - **Non-interactive** — never prompts, every input is a flag - **Explicit confirmation** — `--agent` does not imply `--yes`; pass `--yes` separately only after the target, arguments, and side effects are clear - **Explicit retries** — use `--idempotent` only when an already-existing create should count as success, and use `--ignore-missing` only when a missing delete target should count as success ### Response envelope Commands that read from the local store or the API wrap output in a provenance envelope: ```json { "meta": {"source": "live" | "local", "synced_at": "...", "reason": "..."}, "results": } ``` Parse `.results` for data and `.meta.source` to know whether it's live or local. A human-readable `N results (live)` summary is printed to stderr only when stdout is a terminal AND no machine-format flag (`--json`, `--csv`, `--compact`, `--quiet`, `--plain`, `--select`) is set — piped/agent consumers and explicit-format runs get pure JSON on stdout. ## Paths and state Agents should treat the CLI's path resolver as part of the runtime contract: - Use `--home ` for one invocation, or set `REDMINE_HOME=` to relocate all four path kinds under one root. - Use per-kind env vars only when a specific kind must diverge: `REDMINE_CONFIG_DIR`, `REDMINE_DATA_DIR`, `REDMINE_STATE_DIR`, `REDMINE_CACHE_DIR`. - Resolution order is per-kind env var, `--home`, `REDMINE_HOME`, XDG (`XDG_CONFIG_HOME`, `XDG_DATA_HOME`, `XDG_STATE_HOME`, `XDG_CACHE_HOME`), then platform defaults. - `config` contains settings like `config.toml` and profiles. `data` contains `credentials.toml`, `data.db`, cookies, and auth sidecars. `state` contains persisted queries, jobs, and `teach.log`. `cache` contains regenerable HTTP/cache files. - Stored secrets live in `credentials.toml` under the data dir. Existing legacy `config.toml` secrets are read for compatibility and leave `config.toml` on the first auth write. - Run `redmine-pp-cli doctor --fail-on warn` to surface path and credential-location warnings. `agent-context` exposes a schema v4 `paths` block for agents that need the resolved dirs. - For MCP, pass relocation through the MCP host config. The MCP binary does not inherit CLI flags: ```json { "mcpServers": { "redmine": { "command": "redmine-pp-mcp", "env": { "REDMINE_HOME": "/srv/redmine" } } } } ``` Fleet precedence: an inherited per-kind env var overrides an explicit `--home` for that kind. Use `REDMINE_HOME` or per-kind vars as durable fleet levers, and use `--home` only for a single invocation. Relocation is not reversible by unsetting env vars; move files manually before clearing `REDMINE_HOME`, or `doctor` will not find credentials left under the former root. ## Automatic learning This CLI ships a self-capturing learning loop. The CLI does its own bookkeeping: every invocation is journaled locally, a failed flag followed by a corrected retry auto-derives a `flag_alias` candidate, and a `teach` on a query family without a playbook auto-synthesizes a `playbook_candidate` from the session's journal. Y