What does the SQLiteData Claude Code Skill do?

This skill enables Claude to implement and manage type-safe SQLite persistence and CloudKit synchronization in Swift applications. It leverages the Point-Free SQLiteData library to provide a fast, value-oriented alternative to SwiftData.

How does this skill improve my Swift 6 workflow?

The skill enforces Swift 6 strict concurrency compliance by using nonisolated value types and specific database transaction patterns, helping Claude avoid data races and threading issues in your codebase.

Does it support custom SQL queries?

Yes, it includes support for the #sql macro for compile-time verified raw SQL, as well as advanced patterns for CTEs, JSON aggregation, and custom database functions.

When should I use SQLiteData instead of SwiftData?

Use this skill when your project requires near-raw SQLite performance, value-type (struct) models instead of classes, compiler-checked queries, or advanced CloudKit features like record sharing.

What database capabilities does it provide?

It provides comprehensive support for type-safe queries via the #sql macro, reactive SwiftUI property wrappers like @FetchAll, CloudKit sync engine management, and structured migrations using GRDB.

SQLiteData

Name: SQLiteData
Author: CharlesWiltgen

byCharlesWiltgen

•

Mobile Development

Implements type-safe SQLite persistence and CloudKit synchronization for modern Swift and xOS development using value-oriented patterns.

Streamline data persistence in Apple platform applications with a type-safe, performance-oriented interface for SQLite. Leveraging Point-Free's SQLiteData and GRDB, this skill provides a powerful alternative to SwiftData, focusing on value types and compiler-checked queries. It simplifies complex database tasks like CloudKit record sharing, full-text search, and batch operations while ensuring full compatibility with Swift 6 strict concurrency. Whether you are managing large datasets or implementing custom SQL logic, it offers the perfect balance between high-level abstraction and near-raw-SQLite performance.

Key Features

01Provides type-safe SQLite queries with compile-time verification via StructuredQueries and the #sql macro.

02Defines best practices and anti-patterns for mutations, query ordering, and transaction safety.

03Enforces Swift 6 strict concurrency compliance through nonisolated value types and @Table macros.

04Integrates CloudKit synchronization with support for record sharing and manual sync engine control.

0561 GitHub stars

06Offers reactive SwiftUI property wrappers for efficient data observation and lifecycle-aware fetching.

Use Cases

01Implementing advanced database features like FTS5 full-text search and Common Table Expressions (CTEs) in Swift.

02Migrating from class-based SwiftData models to a lightweight, value-oriented persistence layer.

03Building high-performance iOS apps requiring complex SQLite queries and seamless CloudKit synchronization.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add charleswiltgen/axiom sqlitedata

For use in Claude.ai and ChatGPT

Download Skill