$npx -y skills add Soul-Brews-Studio/arra-oracle-skills-cli --skill scheduleQuery schedule via Oracle API (Drizzle DB). Use when user says "schedule", "upcoming events", "what's on today", "calendar".
| 1 | # /schedule - Query Schedule |
| 2 | |
| 3 | Query the Oracle schedule database via HTTP API. Backed by Drizzle DB with proper date indexing. |
| 4 | |
| 5 | ## Usage |
| 6 | |
| 7 | - `/schedule` → Upcoming events (next 30 days) |
| 8 | - `/schedule week` → Next 7 days |
| 9 | - `/schedule today` → Today's events |
| 10 | - `/schedule tomorrow` → Tomorrow's events |
| 11 | - `/schedule month` → This month |
| 12 | - `/schedule march` → March events |
| 13 | - `/schedule standup` → Search by keyword |
| 14 | - `/schedule all` → Everything (all statuses) |
| 15 | |
| 16 | ## Implementation |
| 17 | |
| 18 | Run the query script: |
| 19 | |
| 20 | ```bash |
| 21 | bun .claude/skills/schedule/scripts/query.ts [filter] |
| 22 | ``` |
| 23 | |
| 24 | The script queries `GET /api/schedule` on the Oracle HTTP server (port 47778). |
| 25 | |
| 26 | ## Output Format |
| 27 | |
| 28 | **Do NOT show raw bash output.** Parse the script output and render as a box-drawn table: |
| 29 | |
| 30 | ``` |
| 31 | Upcoming (5 events) |
| 32 | |
| 33 | ┌────────┬───────┬──────────────────────────────────┐ |
| 34 | │ Date │ Time │ Event │ |
| 35 | ├────────┼───────┼──────────────────────────────────┤ |
| 36 | │ Mar 1 │ TBD │ งานบ้านสมาธิ ครั้ง 4 │ |
| 37 | ├────────┼───────┼──────────────────────────────────┤ |
| 38 | │ Mar 10 │ 15:00 │ นัดอ.เศรษฐ์ (ที่คลินิก) │ |
| 39 | └────────┴───────┴──────────────────────────────────┘ |
| 40 | |
| 41 | 📄 `~/.arra/ψ/inbox/schedule.md` |
| 42 | ``` |
| 43 | |
| 44 | Rules: |
| 45 | - Merge Notes into Event column (parenthesized if short, omit if too long) |
| 46 | - Hide Status column unless `all` filter (done/cancelled rows exist) |
| 47 | - Show ground truth file path at the bottom |
| 48 | - Title: filter name + count, e.g. "Upcoming (5 events)", "March (8 events)" |
| 49 | |
| 50 | ## API Reference |
| 51 | |
| 52 | ``` |
| 53 | GET /api/schedule → next 14 days (pending) |
| 54 | GET /api/schedule?date=2026-03-05 → specific day |
| 55 | GET /api/schedule?date=today → today |
| 56 | GET /api/schedule?from=2026-03-01&to=2026-03-31 → range |
| 57 | GET /api/schedule?filter=keyword → search |
| 58 | GET /api/schedule?status=all → include done/cancelled |
| 59 | ``` |
| 60 | |
| 61 | ## See Also |
| 62 | |
| 63 | - `scripts/query.ts` - Query script (hits Oracle API) |
| 64 | - Oracle DB: `~/.arra/arra.db` → `schedule` table |
| 65 | - Auto-export: `~/.arra/ψ/inbox/schedule.md` (generated on write) |