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 |

使用 SQLiteData 庫（@Table、@FetchAll、@FetchOne 宏）進行 SQLite 持久性、查詢、寫入、遷移或 CloudKit 私有數據庫同步時使用。 來源：johnrogers/claude-swift-engineering。

查看原文