Swiftdata Architecture
KartikLabhshetwar/better-shot
Deep dive into SwiftData design patterns and best practices.
A skill your agent uses when working with SQLiteData library (@Table, @FetchAll, @FetchOne macros) for SQLite persistence, queries, writes, migrations, or CloudKit private database sync.
Install Sqlite Data
$ npx skills add johnrogers/claude-swift-engineering --skill sqlite-data -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install johnrogers/claude-swift-engineering sqlite-data --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/johnrogers/claude-swift-engineering.git skills-src && mkdir -p .claude/skills && cp -r skills-src/plugins/swift-engineering/skills/sqlite-data .claude/skills/sqlite-data && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "sqlite-data" agent skill from https://github.com/johnrogers/claude-swift-engineering/tree/main/plugins/swift-engineering/skills/sqlite-data into .claude/skills/sqlite-data/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sqlite-data", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/johnrogers/claude-swift-engineering/tree/main/plugins/swift-engineering/skills/sqlite-dataType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add johnrogers/claude-swift-engineering --skill sqlite-data -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install johnrogers/claude-swift-engineering sqlite-data --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/johnrogers/claude-swift-engineering.git skills-src && mkdir -p .agents/skills && cp -r skills-src/plugins/swift-engineering/skills/sqlite-data .agents/skills/sqlite-data && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "sqlite-data" agent skill from https://github.com/johnrogers/claude-swift-engineering/tree/main/plugins/swift-engineering/skills/sqlite-data into .agents/skills/sqlite-data/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sqlite-data", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add johnrogers/claude-swift-engineering --skill sqlite-data -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install johnrogers/claude-swift-engineering sqlite-data --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/johnrogers/claude-swift-engineering.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/plugins/swift-engineering/skills/sqlite-data .cursor/skills/sqlite-data && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "sqlite-data" agent skill from https://github.com/johnrogers/claude-swift-engineering/tree/main/plugins/swift-engineering/skills/sqlite-data into .cursor/skills/sqlite-data/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sqlite-data", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/johnrogers/claude-swift-engineering.git --path plugins/swift-engineering/skills/sqlite-data--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add johnrogers/claude-swift-engineering --skill sqlite-data -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install johnrogers/claude-swift-engineering sqlite-data --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/johnrogers/claude-swift-engineering.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/plugins/swift-engineering/skills/sqlite-data .gemini/skills/sqlite-data && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "sqlite-data" agent skill from https://github.com/johnrogers/claude-swift-engineering/tree/main/plugins/swift-engineering/skills/sqlite-data into .gemini/skills/sqlite-data/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sqlite-data", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install johnrogers/claude-swift-engineering sqlite-dataInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add johnrogers/claude-swift-engineering --skill sqlite-data -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/johnrogers/claude-swift-engineering.git skills-src && mkdir -p .github/skills && cp -r skills-src/plugins/swift-engineering/skills/sqlite-data .github/skills/sqlite-data && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "sqlite-data" agent skill from https://github.com/johnrogers/claude-swift-engineering/tree/main/plugins/swift-engineering/skills/sqlite-data into .github/skills/sqlite-data/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sqlite-data", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add johnrogers/claude-swift-engineering --skill sqlite-data -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install johnrogers/claude-swift-engineering sqlite-data --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/johnrogers/claude-swift-engineering.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/plugins/swift-engineering/skills/sqlite-data .opencode/skills/sqlite-data && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "sqlite-data" agent skill from https://github.com/johnrogers/claude-swift-engineering/tree/main/plugins/swift-engineering/skills/sqlite-data into .opencode/skills/sqlite-data/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "sqlite-data", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
sqlite-data- GitHub stars
- 231
- Token cost
- ~924 tokens
- SKILL.md length
- 375 words
- Files
- 14 (incl. references)
- Skills in repo
- 17
- Repo updated
- First seen
- Licence
- MIT
At a glance
A skill your agent uses when working with SQLiteData library (@Table, @FetchAll, @FetchOne macros) for SQLite persistence, queries, writes, migrations, or CloudKit private database sync.
- Works in 5 steps: Define table models with @Table macro → Use @FetchAll/@FetchOne property… → Access database via… → …
- Working with SQLiteData library (@Table
- SKILL.md covers Reference Loading Guide, Core Workflow and Common Mistakes
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
What it does
Sqlite Data is an agent skill from johnrogers/claude-swift-engineering. Use when working with SQLiteData library (@Table, @FetchAll, @FetchOne macros) for SQLite persistence, queries, writes, migrations, or CloudKit private database sync.
Its SKILL.md is about 920 tokens, which your agent loads only when the skill is triggered. The skill folder holds 14 other files, including reference files (for example `references/advanced-optimization.md`, `references/advanced-queries.md` and `references/cloudkit.md`).
It sits in Databases, covering iOS development. It works with SQLite and SwiftUI. The repository describes itself as: A collection of agents and skills to aid in the planning, implementation, documentation and testing of Swift/TCA code. The licence is MIT.
When your agent uses it
- Working with SQLiteData library (@Table
- @FetchOne macros) for SQLite persistence
- CloudKit private database sync
Example prompts
- “/sqlite-data”
Workflow steps
5 steps, taken from the first numbered list in SKILL.md.
- Define table models with @Table macro
- Use @FetchAll/@FetchOne property wrappers in views or @Observable models
- Access database via @Dependency(.defaultDatabase)
- Perform writes in database.write { } transactions
- Set up migrations before first use
What it can do on your machine
Read from SKILL.md and the folder at commit 1dc2cf4. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md.
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Sqlite Data loads about 924 tokens when it runs, and up to ~16k if it reads all its reference files. Until then it costs about 45 tokens; SKILL.md has 375 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check passed
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
The full file from johnrogers/claude-swift-engineering at commit 1dc2cf4, republished under its MIT licence (© johnrogers). 375 words, ~924 tokens.
Download SKILL.mdSave it as
.claude/skills/sqlite-data/SKILL.md (or your agent's skills folder). This skill also uses 13 other files; get the full folder from GitHub.- name
- sqlite-data
- description
- Use when working with SQLiteData library (@Table, @FetchAll, @FetchOne macros) for SQLite persistence, queries, writes, migrations, or CloudKit private database sync.
SQLite Data
SQLiteData provides type-safe SQLite access through Swift macros, simplifying database modeling and queries while handling CloudKit sync, migrations, and async patterns automatically.
Reference Loading Guide
ALWAYS load reference files if there is even a small chance the content may be required. It's better to have the context than to miss a pattern or make a mistake.
| Reference | Load When |
|---|---|
| Table Models | Defining tables with @Table, setting up primary keys, columns, or enums |
| Queries - Basics | Using @FetchAll, @FetchOne, @Selection, filtering, ordering, or joins |
| Queries - Advanced | Using @Fetch with FetchKeyRequest, dynamic queries, recursive CTEs, or direct reads |
| Writes | Inserting, updating, upserting, deleting records, or managing transactions |
| Views - SwiftUI | Using @FetchAll/@FetchOne in SwiftUI views, @Observable models, or animations |
| Views - Integration | UIKit integration, dynamic query loading, TCA integration, or observe {} |
| Migrations | Creating database migrations with DatabaseMigrator or #sql() macro |
| CloudKit Sync | Setting up CloudKit private database sync, sharing, or sync delegates |
| Dependencies | Injecting database/sync engine via @Dependency, bootstrap patterns, or TCA integration |
| Testing | Setting up test databases, seeding data, or writing assertions for SQLite code |
| Advanced - Queries | Implementing triggers, custom database functions, or full-text search (FTS5) |
| Advanced - Optimization | Performance tuning, indexes, custom aggregates, JSON aggregation, or self-joins |
| Schema Composition | Using @Selection column groups, single-table inheritance, or database views |
Show full SKILL.md (169 more words)Show less
Core Workflow
When working with SQLiteData:
- Define table models with
@Tablemacro - Use
@FetchAll/@FetchOneproperty wrappers in views or@Observablemodels - Access database via
@Dependency(\.defaultDatabase) - Perform writes in
database.write { }transactions - Set up migrations before first use
Common Mistakes
N+1 query patterns — Loading records one-by-one in a loop (e.g., fetching user then fetching all their posts separately) kills performance. Use joins or batch fetches instead.
Missing migrations on schema changes — Modifying
@Tablewithout creating a migration causes crashes at runtime. Always create migrations for schema changes before deploying.Improper transaction handling — Long-running transactions outside of
database.write { }block can cause deadlocks or data loss. Keep write blocks short and focused.Ignoring CloudKit sync delegates — Setting up CloudKit sync without implementing
SyncDelegatemeans you miss error handling and conflict resolution. Implement all delegate methods for production.Over-fetching in SwiftUI views — Using
@FetchAllwithout filtering/limiting can load thousands of records, freezing the UI. Use predicates, limits, and sorting to keep in-memory footprint small.
© johnrogers, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Files
SKILL.md and 13 other files (references) in plugins/swift-engineering/skills/sqlite-data of johnrogers/claude-swift-engineering.
- SKILL.md
- references/advanced-optimization.md
- references/advanced-queries.md
- references/cloudkit.md
- references/dependencies.md
- references/migrations.md
- references/models.md
- references/queries-advanced.md
- references/queries-basics.md
- references/schema-composition.md
- references/testing.md
- references/views-integration.md
- references/views-swiftui.md
- references/writes.md
Open the folder on GitHubat commit 1dc2cf4
Compare with similar skills
Sqlite Data next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Sqlite Data this skilljohnrogers/claude-swift-engineering | 231 | — | ~924 | Automated safety check: Pass | MIT | |
| Swiftdata ArchitectureKartikLabhshetwar/better-shot | 2.4k | 2 repos | ~1.2k | Automated safety check: Pass | Custom licence | |
| Init Tauri Appglebis/claude-skills | 390 | — | ~1.5k | Automated safety check: Pass | MIT | |
| Swiftui Protwostraws/SwiftUI-Agent-Skill | 5.2k | 2 repos | ~1.5k | Automated safety check: Pass | MIT | |
| Update Swiftui APIsAvdLee/SwiftUI-Agent-Skill | 3.7k | — | ~1.2k | Automated safety check: Pass | MIT | |
| Swiftui Liquid Glassharperreed/dotfiles | 334 | 8 repos | ~941 | Automated safety check: Pass | None |
Similar skills
Init Tauri App
glebis/claude-skills
Scaffold a new Tauri v2 project with the cenno/cull house conventions — delegates boilerplate to npm create tauri-app, then layers an opinionated core plus opt-in modules (CLI+MCP, SQLite…
Swiftui Pro
twostraws/SwiftUI-Agent-Skill
Comprehensively reviews SwiftUI code for best practices on modern APIs, maintainability, and performance.
Update Swiftui APIs
AvdLee/SwiftUI-Agent-Skill
Scan Apple's SwiftUI documentation for deprecated APIs and update the SwiftUI Expert Skill with modern replacements.
Swiftui Liquid Glass
harperreed/dotfiles
Implement, review, or improve SwiftUI features using the iOS 26+ Liquid Glass API.
Swiftui Expert Skill
omarshahine/HomeClaw
A skill your agent uses when writing, reviewing, or refactoring SwiftUI code for iOS or macOS, including state management, view composition, performance, Liquid Glass adoption, or Instruments .trace…
More from johnrogers/claude-swift-engineering
All 17 skills in this repoLocalization
johnrogers/claude-swift-engineering
A skill your agent uses when implementing internationalization (i18n), String Catalogs, pluralization, or right-to-left layout support.
Storekit
johnrogers/claude-swift-engineering
A skill your agent uses when implementing in-app purchases, StoreKit 2 subscriptions, consumables, non-consumables, or transaction handling.
Swift Style
johnrogers/claude-swift-engineering
Swift code style conventions for clean, readable code. An agent skill from johnrogers/claude-swift-engineering.
Composable Architecture
johnrogers/claude-swift-engineering
A skill your agent uses when building features with TCA (The Composable Architecture), structuring reducers, managing state, handling effects, navigation, or testing TCA features.
Foundation Models
johnrogers/claude-swift-engineering
A skill your agent uses when implementing on-device AI with Apple's Foundation Models framework (iOS 26+), building summarization/extraction/classification features, or using @Generable for…
Grdb
johnrogers/claude-swift-engineering
A skill your agent uses when writing raw SQL with GRDB, complex joins across 4+ tables, window functions, ValueObservation for reactive queries, or dropping down from SQLiteData for performance.
Related
Categories
Questions about Sqlite Data
What does Sqlite Data do?
A skill your agent uses when working with SQLiteData library (@Table, @FetchAll, @FetchOne macros) for SQLite persistence, queries, writes, migrations, or CloudKit private database sync. Sqlite Data is an agent skill from johnrogers/claude-swift-engineering. Use when working with SQLiteData library (@Table, @FetchAll, @FetchOne macros) for SQLite persistence, queries, writes, migrations, or CloudKit private database sync.
When should I use Sqlite Data?
Sqlite Data fits situations like: working with SQLiteData library (@Table; @FetchOne macros) for SQLite persistence; cloudKit private database sync.
How do I install Sqlite Data in Claude Code?
Run `npx skills add johnrogers/claude-swift-engineering --skill sqlite-data -a claude-code`. Or copy the skill folder (plugins/swift-engineering/skills/sqlite-data in johnrogers/claude-swift-engineering) into .claude/skills/sqlite-data in your project. Claude Code loads it when a task matches its description.
How do I install Sqlite Data in Codex?
Run `npx skills add johnrogers/claude-swift-engineering --skill sqlite-data -a codex`. Or copy the skill folder (plugins/swift-engineering/skills/sqlite-data in johnrogers/claude-swift-engineering) into .agents/skills/sqlite-data in your project. Codex loads it when a task matches its description.
Can I use Sqlite Data in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add johnrogers/claude-swift-engineering --skill sqlite-data -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/sqlite-data, .gemini/skills/sqlite-data, .github/skills/sqlite-data and .opencode/skills/sqlite-data in your project.
What does Sqlite Data need to run?
SKILL.md names no scripts, command-line tools or credentials: Sqlite Data is instructions for the agent only.
Does Sqlite Data access the network?
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Is Sqlite Data safe to install?
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
What licence does Sqlite Data use?
Sqlite Data is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
How many tokens does Sqlite Data use?
About 924 tokens (SKILL.md is roughly 3.7k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 15k tokens, read only when the agent opens those files.
What are the alternatives to Sqlite Data?
Skills that share tags, products or a category with Sqlite Data: Swiftdata Architecture (KartikLabhshetwar/better-shot, 2.4k stars), Init Tauri App (glebis/claude-skills, 390 stars), Swiftui Pro (twostraws/SwiftUI-Agent-Skill, 5.2k stars) and Update Swiftui APIs (AvdLee/SwiftUI-Agent-Skill, 3.7k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Sqlite Data?
johnrogers (a GitHub user) maintains it in johnrogers/claude-swift-engineering, which has 231 GitHub stars. The repository holds 17 skills in this directory. The repository was last updated on January 18, 2026.
Source: johnrogers/claude-swift-engineering on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.