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.

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

01Comprehensive database migration and schema versioning strategies

02Seamless CloudKit private database sync integration

03Optimized transaction management and N+1 query prevention

0461 GitHub stars

05Reactive UI binding with @FetchAll and @FetchOne property wrappers

06Type-safe schema definition using @Table macros

Use Cases

01Integrating CloudKit synchronization with custom error handling and conflict resolution.

02Architecting a local-first persistence layer for SwiftUI or TCA-based iOS apps.

03Implementing automated schema migrations for evolving production databases.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add johnrogers/claude-swift-engineering sqlite-data

For use in Claude.ai and ChatGPT

Download Skill