# Schedule

> [lab] v26.5.16 L-SKLL | Query schedule via Oracle API (Drizzle DB). Use when user says "schedule", "upcoming events", "what's on today", "calendar".

- Skill: `l3rowniecakez/schedule` (Agent Skill, multi-file: 3 files)
- Install (CLI): `npx skillmds@latest add l3rowniecakez/schedule`
- Raw SKILL.md: https://api.skillmd.com/api/skills/l3rowniecakez/schedule/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Integrations & APIs
- Author: l3rowniecakez (https://skillmd.com/u/l3rowniecakez)
- Updated: 2026-09-22
- Page: https://skillmd.com/skills/l3rowniecakez/schedule

---


# /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:

```bash
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)