--- name: pp-jobber description: "Read-only Jobber CLI for offline analysis — every GraphQL surface synced to SQLite, every relationship queryable. Trigger phrases: `ar aging in jobber`, `jobber invoice payments mismatch`, `search jobber data`, `snapshot diff jobber`, `query jobber sql`, `use jobber-pp-cli`, `run jobber-pp-cli`." author: "melanson633" license: "Apache-2.0" argument-hint: " [args] | install cli|mcp" allowed-tools: "Read Bash" metadata: openclaw: requires: bins: - jobber-pp-cli --- # Jobber — Printing Press CLI ## Prerequisites: Install the CLI This skill drives the `jobber-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: ```bash npx -y @mvanhorn/printing-press install jobber --cli-only ``` 2. Verify: `jobber-pp-cli --version` 3. Ensure `$GOPATH/bin` (or `$HOME/go/bin`) is on `$PATH`. If the `npx` install fails (no Node, offline, etc.), fall back to a direct Go install (requires Go 1.26.3 or newer): ```bash go install github.com/mvanhorn/printing-press-library/library/sales-and-crm/jobber/cmd/jobber-pp-cli@latest ``` If `--version` reports "command not found" after install, the install step did not put the binary on `$PATH`. Do not proceed with skill commands until verification succeeds. The `jobber-pp-cli` binary syncs the whole Jobber GraphQL surface into a local SQLite database, then lets you slice it with `ar aging`, `invoices trace`, `snapshot diff`, FTS `search`, and ad-hoc `sql`. Existing Jobber MCPs are RPC proxies — you can't run them on a plane, you can't compose them with SQL, and they don't store data locally. This tool does. It also ships read-only by construction (no mutation commands are emitted), which makes it safe to hand to an advisor or auditor on a live client tenant. ## When to Use This CLI Use jobber-pp-cli when an agent or user needs offline analysis of a Jobber tenant: AR aging, invoice payment tracing, week-over-week snapshot diffs, full-text search across synced data, or ad-hoc SQL over the local store. It is read-only by design — pair it with QBO or another accounting CLI for full reconciliation. It does not write to Jobber. ## When Not to Use This CLI Do not activate this CLI for requests that require creating, updating, deleting, publishing, commenting, upvoting, inviting, ordering, sending messages, booking, purchasing, or changing remote state. This printed CLI exposes read-only commands for inspection, export, sync, and analysis. ## Unique Capabilities These capabilities aren't available in any other tool for this API. ### Accounting & AR analysis - **`ar aging`** — Aged AR by client with 0-30/31-60/61-90/90+ buckets and per-bucket totals — answers the question every advisor and bookkeeper asks first, offline and instantly. _Reach for this whenever the user asks about overdue invoices, collections risk, or DSO. It's the offline-first, agent-shaped equivalent of opening the Jobber AR report and re-pivoting in Excel._ ```bash jobber-pp-cli ar aging --as-of 2026-05-15 --json --select client,bucket_0_30,bucket_31_60,bucket_61_90,bucket_over_90 ``` - **`invoices trace`** — Per-invoice ledger: total billed, sum of payment records, balance, allocated payout reference, status drift. `--mismatched` filters to invoices where payments don't equal total. _Use when the user asks 'why is this invoice still open' or wants to find misposted payments. One row per invoice covers everything the Jobber UI buries three clicks deep._ ```bash jobber-pp-cli invoices trace --mismatched --json ``` ### Diligence & diff - **`snapshot diff`** — Diff two labeled SQLite snapshots: new clients, status transitions, paid invoices, open-AR deltas per client. `--save