skills.rest
aashari
aashariCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

calendar-core

Document Apple Calendar CoreData schema and epoch conversion rules for macOS.

5|Updated Feb 28, 2026
Search Tags:#sqlite#calendar#data-access#apple-calendar#coredata-epoch#query-canonical#development-reference
One-click install
npx skills add https://github.com/aashari/ai-agent-skills --skill calendar-core
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: calendar-core
Source: https://github.com/aashari/ai-agent-skills/tree/main/skills/apple-calendar/calendar-core
Command: npx skills add https://github.com/aashari/ai-agent-skills --skill calendar-core

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Provides a local technical reference for Apple Calendar data on macOS, including database location, CoreData epoch considerations, schema details, and canonical query guidance.

Core Features & Use Cases

  • Defines the Apple Calendar data schema (CalendarItem, OccurrenceCache, Calendar, Store, Location, Participant, Recurrence) and how to apply standard exclusion filters for clean results.
  • Documents CoreData epoch conversion, OccurrenceCache usage for recurring events, and a canonical query template to reliably fetch events within a time window.
  • Serves as the loaded reference when any calendar-* skill runs, ensuring consistent time handling and query semantics across skills.

Quick Start

Load this core reference automatically when any calendar-* skill runs to ensure correct time conversion and canonical querying.

Frequently Asked Questions about calendar-core

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query Apple Calendar data on macOS using SQLite?▼

To query Apple Calendar data on macOS, apply a canonical SQLite query template against the local database to reliably fetch events within a specific time window. This approach ensures deterministic results by applying standard exclusion filters for clean output.

What is the CoreData epoch for Apple Calendar timestamps?▼

The CoreData epoch for Apple Calendar timestamps starts on January 1, 2001. Converting these timestamps requires specific handling rules to ensure accurate time window queries and consistent time management across calendar data retrieval.

How does OccurrenceCache work for recurring events in Apple Calendar?▼

The OccurrenceCache stores expanded instances of recurring events in the Apple Calendar database. Querying this cache allows reliable retrieval of recurring event occurrences within a time window without manually calculating repeat intervals.

What database schema does Apple Calendar use on macOS?▼

The Apple Calendar schema includes CalendarItem, OccurrenceCache, Calendar, Store, Location, Participant, and Recurrence entities. Understanding this schema is necessary for fetching events, locations, and participant data correctly.

Why are my Apple Calendar SQLite queries returning duplicate or invalid events?▼

Duplicate or invalid events appear when Apple Calendar SQLite queries omit standard exclusion filters. Applying canonical query templates with proper filtering guidelines ensures clean results by excluding cancelled or invalid occurrences.

Related Skills

Explore More Software Engineering Skills→
Desko77Desko77
43

1c-mcp-toolkit

Expose a live 1C database through a direct HTTP API.

Community
Advanced
jwilgerjwilger

event-modeling

Guide structured event modeling workshops for event-sourced systems.

Community
Advanced
wordflowlabwordflowlab
14

markdown-segment-translator

Segment long Markdown documents, translate each segment, and merge into Chinese.

Official
Advanced
annurdienannurdien

eventkit

Query and manipulate calendar and reminder data using Apple's EventKit APIs.

Community
Intermediate