/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)