sqlitedata

Persist type-safe SQLite data with CloudKit synchronization and raw SQL macros.

1.1k|81|Updated Nov 30, 2025

Search Tags:#sqlite #macros #cloudkit #ctype #sqlitedata

Ready to run

npx skills add https://github.com/CharlesWiltgen/Axiom --skill sqlitedata

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: sqlitedata
Source: https://github.com/CharlesWiltgen/Axiom/tree/main/.claude-plugin/plugins/axiom/skills/sqlitedata
Command: npx skills add https://github.com/CharlesWiltgen/Axiom --skill sqlitedata

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

SQLiteData provides type-safe SQLite with a modern macro-based model system, CloudKit sync, and raw SQL capabilities for advanced queries.

Core Features & Use Cases

@Table models with queries and migrations.
CloudKit sync integration and optional raw SQL macro.
Support for advanced patterns like CTEs and JSON aggregation.

Quick Start

Define a @Table model, insert a row, then query it using the provided macros.

Frequently Asked Questions about sqlitedata

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I build type-safe SQLite persistence for iOS with CloudKit sync?▼

SQLiteData provides type-safe SQLite persistence using @Table macros for model definitions, CloudKit synchronization via a SyncEngine, and support for iOS 17+ with Swift 6 strict concurrency. Define your models, use database.write blocks for mutations, and enable CloudKit sync for cross-device data consistency.

Can I use raw SQL queries with a type-safe SQLite model system?▼

Yes. SQLiteData supports raw SQL through #sql macros and SQL literals alongside its type-safe @Table models, letting you write advanced patterns like CTEs, full-text search, and JSON aggregation when needed while maintaining type safety for standard operations.

Does SQLiteData handle complex database operations like migrations and bulk inserts?▼

SQLiteData covers migrations, bulk fetches, inserts, updates, deletes, and complex predicates. Its macro system generates the scaffolding for these operations while enforcing type safety and nonisolated declarations required by Swift 6 concurrency.

What are the iOS version and concurrency requirements for SQLiteData?▼

SQLiteData requires iOS 17 or later and uses Swift 6 strict concurrency. It enforces nonisolated declarations and database.write blocks to ensure thread-safe mutations and comply with modern Swift concurrency rules.

How does CloudKit synchronization work in SQLiteData?▼

CloudKit sync is integrated through a SyncEngine component that enables optional bidirectional synchronization of your type-safe models. Configure it alongside your @Table definitions to keep local SQLite data in sync across devices without manual conflict resolution logic.