/schedule - Query Schedule
Query the Oracle schedule database via HTTP API. Backed by Drizzle DB with proper date indexing.
Usage
/schedule → Upcoming events (next 30 days)/schedule week → Next 7 days/schedule today → Today's events/schedule tomorrow → Tomorrow's events/schedule month → This month/schedule march → March events/schedule standup → Search by keyword/schedule all → Everything (all statuses)
Implementation
Run the query script:
bun .claude/skills/schedule/scripts/query.ts [filter]
The script queries GET /api/schedule on the Oracle HTTP server (port 47778).
Output Format
Do NOT show raw bash output. Parse the script output and render as a box-drawn table:
Upcoming (5 events)
┌────────┬───────┬──────────────────────────────────┐
│ Date │ Time │ Event │
├────────┼───────┼──────────────────────────────────┤
│ Mar 1 │ TBD │ งานบ้านสมาธิ ครั้ง 4 │
├────────┼───────┼──────────────────────────────────┤
│ Mar 10 │ 15:00 │ นัดอ.เศรษฐ์ (ที่คลินิก) │
└────────┴───────┴──────────────────────────────────┘
📄 `~/.arra/ψ/inbox/schedule.md`
Rules:
- Merge Notes into Event column (parenthesized if short, omit if too long)
- Hide Status column unless
all filter (done/cancelled rows exist)
- Show ground truth file path at the bottom
- Title: filter name + count, e.g. "Upcoming (5 events)", "March (8 events)"
API Reference
GET /api/schedule → next 14 days (pending)
GET /api/schedule?date=2026-03-05 → specific day
GET /api/schedule?date=today → today
GET /api/schedule?from=2026-03-01&to=2026-03-31 → range
GET /api/schedule?filter=keyword → search
GET /api/schedule?status=all → include done/cancelled
See Also
scripts/query.ts - Query script (hits Oracle API)- Oracle DB:
~/.arra/arra.db → schedule table
- Auto-export:
~/.arra/ψ/inbox/schedule.md (generated on write)
