Does it support SwiftUI and the @Observable macro?

Yes, it includes specialized guidance for using @FetchAll and @FetchOne within SwiftUI views and @Observable models to ensure reactive UI updates.

Is this skill compatible with The Composable Architecture (TCA)?

Yes, it includes patterns for injecting database dependencies and sync engines via the Swift Dependencies library, making it ideal for TCA projects.

Can this skill help optimize slow database queries?

Absolutely. It identifies performance anti-patterns like N+1 queries and provides implementation patterns for joins, indexes, and batch fetching.

Is CloudKit synchronization included in this skill?

Yes, the skill covers the complete setup for CloudKit private database sync, including delegate implementation for conflict resolution and error handling.

How does this skill handle database schema changes?

The skill provides specific patterns for using the DatabaseMigrator and #sql() macro to ensure schema updates are applied safely without causing runtime crashes.

SQLite Data for Swift

Name: SQLite Data for Swift
Author: johnrogers

byjohnrogers

•

Database Management

Simplifies type-safe SQLite persistence and CloudKit synchronization for Swift applications using modern macros and property wrappers.

About

The SQLite Data skill enables Claude to architect, implement, and optimize database layers using the SQLiteData library. It provides domain-specific knowledge for defining type-safe models with Swift macros, managing complex asynchronous queries, and handling automated migrations. This skill is particularly useful for developers building local-first iOS applications that require robust persistence, SwiftUI integration, and seamless CloudKit private database synchronization while adhering to performance best practices and The Composable Architecture (TCA) patterns.

Key Features

Comprehensive database migration and schema versioning strategies
Seamless CloudKit private database sync integration
Optimized transaction management and N+1 query prevention
61 GitHub stars
Reactive UI binding with @FetchAll and @FetchOne property wrappers
Type-safe schema definition using @Table macros

Use Cases

Integrating CloudKit synchronization with custom error handling and conflict resolution.
Architecting a local-first persistence layer for SwiftUI or TCA-based iOS apps.
Implementing automated schema migrations for evolving production databases.

About

Key Features

Comprehensive database migration and schema versioning strategies
Seamless CloudKit private database sync integration
Optimized transaction management and N+1 query prevention
61 GitHub stars
Reactive UI binding with @FetchAll and @FetchOne property wrappers
Type-safe schema definition using @Table macros

Use Cases

Integrating CloudKit synchronization with custom error handling and conflict resolution.
Architecting a local-first persistence layer for SwiftUI or TCA-based iOS apps.
Implementing automated schema migrations for evolving production databases.