Read-only Jobber CLI for offline analysis — every GraphQL surface synced to SQLite, every relationship queryable, zero mutation risk.
jobber-pp-cli pulls the whole Jobber GraphQL surface into a local SQLite database once, then lets you slice it with ar aging, invoices trace, snapshot diff, FTS search, and 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.
Created by @melanson633 (melanson633).
Authentication
Jobber uses OAuth2 authorization code flow with mandatory refresh-token rotation. jobber-pp-cli reads JOBBER_CLIENT_ID, JOBBER_CLIENT_SECRET, JOBBER_CALLBACK_URL, JOBBER_ACCESS_TOKEN, JOBBER_REFRESH_TOKEN, and JOBBER_GRAPHQL_VERSION from the environment. Every refresh persists the newest refresh token back to the Windows user environment (required by Jobber's rotation policy). Run jobber-pp-cli doctor to verify the connection.
Quick Start
# verify OAuth token, GraphQL version, and throttle budget before a long pull
jobber-pp-cli doctor
# one-time full pull of every read-only surface into local SQLite
jobber-pp-cli sync --full
# your first analytical question — aged AR by client, offline
jobber-pp-cli ar aging --as-of 2026-05-15 --json
# per-invoice ledger filtered to invoices whose payments don't equal total
jobber-pp-cli invoices trace --mismatched --json
# FTS5 across every text field in the synced store
jobber-pp-cli search "smith" --json
Unique Features
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.
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.
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 <label> tags the current DB for a later diff.
Reach for this on a weekly cadence to write client memos, identify deltas, or build an audit log of changes between two points in time.
jobber-pp-cli snapshot diff 2026-05-15 2026-05-22 --json
Usage
Run jobber-pp-cli --help for the full command reference and flag list.
Commands
clients
Clients (Jobber clients Relay connection)
jobber-pp-cli clients get - Get a client by EncodedId
jobber-pp-cli clients list - List clients with optional filters
invoices
Invoices (Jobber invoices Relay connection)
jobber-pp-cli invoices - List invoices with optional filters
jobber_jobs
Jobs (Jobber jobs Relay connection). Resource key is jobber_jobs to avoid press v4.9.0 reserved-cobra collision; post-rewrite renames Cobra Use back to jobs and removes the unused built-in jobs ledger.
jobber-pp-cli jobber_jobs get - Get a job by EncodedId
jobber-pp-cli jobber_jobs list - List jobs with optional filters
payment-records
Payment records (Jobber paymentRecords Relay connection, PaymentRecordInterface)
jobber-pp-cli payment-records - List payment records with optional filters (entryDate is exclusive both ends - pad +/-1 day)
properties
Properties (Jobber properties Relay connection)
jobber-pp-cli properties - List properties with optional filters
quotes
Quotes (Jobber quotes Relay connection)
jobber-pp-cli quotes - List quotes with optional filters
visits
Visits (Jobber visits Relay connection)
jobber-pp-cli visits - List visits with optional filters
Output Formats
# Human-readable table (default in terminal, JSON when piped)
jobber-pp-cli clients list
# JSON for scripting and agents
jobber-pp-cli clients list --json
# Filter to specific fields
jobber-pp-cli clients list --json --select id,name,status
# Dry run — show the request without sending
jobber-pp-cli clients list --dry-run
# Agent mode — JSON + compact + no prompts in one flag
jobber-pp-cli clients list --agent
Agent Usage
This CLI is designed for AI agent consumption:
- Non-interactive - never prompts, every input is a flag
- Pipeable -
--json output to stdout, errors to stderr
- Filterable -
--select id,name returns only fields you need
- Previewable -
--dry-run shows the request without sending
- Read-only by default - this CLI does not create, update, delete, publish, send, or mutate remote resources
- Offline-friendly - sync/search commands can use the local SQLite store when available
- Agent-safe by default - no colors or formatting unless
--human-friendly is set
Exit codes: 0 success, 2 usage error, 3 not found, 4 auth error, 5 API error, 7 rate limited, 10 config error.
Health Check
jobber-pp-cli doctor
Verifies configuration, credentials, and connectivity to the API.
Configuration
Config file: ~/.config/jobber/config.toml
Static request headers can be configured under headers; per-command header overrides take precedence.
Environment variables:
| Name | Kind | Required | Description |
|---|
JOBBER_CLIENT_ID | per_call | Yes | Set to your API credential. |
JOBBER_CLIENT_SECRET | per_call | Yes | Set to your API credential. |
JOBBER_CALLBACK_URL | per_call | Yes | Set to your API credential. |
JOBBER_ACCESS_TOKEN | per_call | Yes | Set to your API credential. |
JOBBER_REFRESH_TOKEN | per_call | Yes | Set to your API credential. |
JOBBER_GRAPHQL_VERSION | per_call | Yes | Set to your API credential. |
Troubleshooting
Authentication errors (exit code 4)
- Run
jobber-pp-cli doctor to check credentials
- Verify the environment variable is set:
echo $JOBBER_CLIENT_ID
Not found errors (exit code 3)
- Check the resource ID is correct
- Run the
list command to see available items
API-specific
- 401 Unauthorized after running for an hour — Jobber access tokens are short-lived. Run
jobber-pp-cli auth refresh — it persists the rotated refresh token back to the Windows user env automatically.
- GraphQL version error in response — Update
JOBBER_GRAPHQL_VERSION to the active version listed at https://developer.getjobber.com/docs/using_jobbers_api/api_versioning, then re-run.
- Throttled: cost > restore — Run
jobber-pp-cli doctor to see the throttle budget. Use sync --resource clients to pull one resource at a time, or wait — Jobber restores 500 cost units/second.
- Empty results from
ar aging after a fresh install — Run jobber-pp-cli sync --full first. The novel features query the local SQLite store, not the live API.
Sources & Inspiration
This CLI was built by studying these projects and resources:
Generated by CLI Printing Press