Can this skill help with 'database is locked' errors?

Yes, it provides specific guidance on identifying nested write calls and suggests architectural changes like using DatabasePool instead of DatabaseQueue.

How does it assist with CloudKit sync issues?

The skill includes a symptom-to-fix map for SyncEngine, addressing common issues like permission errors, invalid record names, and unique constraint conflicts.

What should I use for learning CloudKit sync patterns instead?

While this skill handles errors, you should use the 'router' or 'core' skills for learning implementation patterns or building new features.

When should I use the sqlitedata-swift-diag skill?

Use this skill when you encounter specific error messages, unexpected behaviors, or crashes related to SQLiteData. It is designed for troubleshooting rather than feature implementation.

Does it support debugging SwiftUI Previews?

Yes, it provides specific setup patterns to prevent crashes and empty data states within SwiftUI Previews and XCTest environments.

SQLiteData Swift Diagnostics

Name: SQLiteData Swift Diagnostics
Author: sitapix

bysitapix

0•

Database Management

Troubleshoots and resolves SQLiteData issues in Swift, including build errors, runtime crashes, and sync failures.

This skill acts as a specialized diagnostic engine for Claude Code, mapping specific SQLiteData symptoms to actionable fixes. It provides domain-specific guidance for developers debugging Swift applications, covering everything from compilation errors and SQL constraint failures to complex CloudKit synchronization issues. It is an essential tool for maintaining robust database layers in iOS and macOS apps, offering quick solutions for migration failures, UI data-binding problems with @Fetch wrappers, and concurrency-related database locks.

Key Features

010 GitHub stars

02Best practices for database migrations and preview-specific crashes

03CloudKit SyncEngine diagnostic map for permissions and record errors

04Detailed resolution steps for SQL constraint failures and database locking

05Troubleshooting for @Fetch property wrappers and SwiftUI observation issues

06Symptom-to-fix mapping for common SQLiteData build and runtime errors

Use Cases

01Debugging 'no such table' or column mismatch errors during schema migrations

02Resolving UNIQUE or FOREIGN KEY constraint failures during CloudKit synchronization

03Fixing UI issues where @FetchAll or @FetchOne results fail to update in SwiftUI views

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add sitapix/sqlitedata-swift-skills sqlitedata-swift-diag

For use in Claude.ai and ChatGPT

Key Features

010 GitHub stars

02Best practices for database migrations and preview-specific crashes

03CloudKit SyncEngine diagnostic map for permissions and record errors

04Detailed resolution steps for SQL constraint failures and database locking

05Troubleshooting for @Fetch property wrappers and SwiftUI observation issues

06Symptom-to-fix mapping for common SQLiteData build and runtime errors

Use Cases

01Debugging 'no such table' or column mismatch errors during schema migrations

02Resolving UNIQUE or FOREIGN KEY constraint failures during CloudKit synchronization

03Fixing UI issues where @FetchAll or @FetchOne results fail to update in SwiftUI views

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add sitapix/sqlitedata-swift-skills sqlitedata-swift-diag

For use in Claude.ai and ChatGPT