sqlitedata

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

1.1k|81|Updated Nov 30, 2025
One-click install
npx skills add https://github.com/CharlesWiltgen/Axiom --skill sqlitedata
Or copy as Structured Prompt for Agent
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.