How does this skill handle database migrations?

The skill provides patterns for using DatabaseMigrator to ensure schema changes are applied sequentially and safely, preventing data loss and maintaining schema consistency.

Does this skill support reactive programming?

Yes, it includes specialized documentation and implementation patterns for ValueObservation, allowing you to create reactive data subscriptions that update your UI automatically.

Can this skill help optimize slow database queries?

Yes, the skill guides you through using EXPLAIN QUERY PLAN to identify bottlenecks and helps implement necessary indexes on WHERE, JOIN, and ORDER BY clauses.

When should I use GRDB instead of SQLiteData?

Choose GRDB for advanced scenarios requiring window functions, complex joins across 4 or more tables, performance-critical raw SQL, or reactive updates via ValueObservation.

GRDB SQLite for Swift

Name: GRDB SQLite for Swift
Author: johnrogers

byjohnrogers

•

Database Management

Implements type-safe SQLite database layers, complex SQL queries, and reactive data observation using GRDB.swift.

About

This skill equips Claude with specialized knowledge for GRDB.swift, enabling the development of powerful, type-safe SQLite database layers in iOS and macOS applications. It provides expert guidance on crafting complex raw SQL queries, managing schema migrations with DatabaseMigrator, and implementing reactive data updates via ValueObservation. By leveraging this skill, developers can ensure high-performance data persistence with proper indexing and query profiling using EXPLAIN QUERY PLAN, bridging the gap between high-level Swift code and raw SQLite power.

Key Features

Type-safe Record protocol implementation (Codable, Fetchable, Persistable)
Reactive data patterns and SwiftUI integration using ValueObservation
Performance profiling and optimization using EXPLAIN QUERY PLAN
Complex SQL query generation including window functions and 4+ table joins
Sequential database migration management with DatabaseMigrator
61 GitHub stars

Use Cases

Building high-performance local storage for data-intensive iOS/macOS applications
Managing complex schema evolutions through versioned, sequential migrations
Creating reactive user interfaces that automatically sync with SQLite data changes

About

Key Features

Type-safe Record protocol implementation (Codable, Fetchable, Persistable)
Reactive data patterns and SwiftUI integration using ValueObservation
Performance profiling and optimization using EXPLAIN QUERY PLAN
Complex SQL query generation including window functions and 4+ table joins
Sequential database migration management with DatabaseMigrator
61 GitHub stars

Use Cases

Building high-performance local storage for data-intensive iOS/macOS applications
Managing complex schema evolutions through versioned, sequential migrations
Creating reactive user interfaces that automatically sync with SQLite data changes