sqlite-data

SKILL.md

SQLiteData provides type-safe SQLite access through Swift macros, simplifying database modeling and queries while handling CloudKit sync, migrations, and async patterns automatically.

ALWAYS load reference files if there is even a small chance the content may be required. It's better to have the context than to miss a pattern or make a mistake.

| Table Models | Defining tables with @Table, setting up primary keys, columns, or enums | | Queries - Basics | Using @FetchAll, @FetchOne, @Selection, filtering, ordering, or joins | | Queries - Advanced | Using @Fetch with FetchKeyRequest, dynamic queries, recursive CTEs, or direct reads |

Use when working with SQLiteData library (@Table, @FetchAll, @FetchOne macros) for SQLite persistence, queries, writes, migrations, or CloudKit private database sync. Source: johnrogers/claude-swift-engineering.

View raw