Use when writing raw SQL with GRDB, complex joins across 4+ tables, window functions, ValueObservation for reactive queries, or dropping down from SQLiteData for performance. Direct SQLite access for iOS/macOS with type-safe queries and migrations.

GitHub
安装命令
npx skhub add johnrogers/grdb
Markdown
SKILL.md

GRDB

Direct SQLite access using GRDB.swift - type-safe Swift wrapper with full SQLite power when you need it.

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.

ReferenceLoad When
Getting StartedSetting up DatabaseQueue or DatabasePool
QueriesWriting raw SQL, Record types, type-safe queries
Value ObservationReactive queries, SwiftUI integration
MigrationsDatabaseMigrator, schema evolution
PerformanceEXPLAIN QUERY PLAN, indexing, profiling

When to Use GRDB vs SQLiteData

ScenarioUse
Type-safe @Table modelsSQLiteData
CloudKit sync neededSQLiteData
Complex joins (4+ tables)GRDB
Window functions (ROW_NUMBER, RANK)GRDB
Performance-critical raw SQLGRDB
Reactive queries (ValueObservation)GRDB

Core Workflow

  1. Choose DatabaseQueue (single connection) or DatabasePool (concurrent reads)
  2. Define migrations with DatabaseMigrator
  3. Create Record types (Codable, FetchableRecord, PersistableRecord)
  4. Write queries with raw SQL or QueryInterface
  5. Use ValueObservation for reactive updates

Requirements

  • iOS 13+, macOS 10.15+
  • Swift 5.7+
  • GRDB.swift 6.0+

Common Mistakes

  1. Performance assumptions without EXPLAIN PLAN — Assuming your query is fast or slow without checking EXPLAIN QUERY PLAN is guessing. Always profile queries with EXPLAIN before optimizing.

  2. Missing indexes on WHERE clauses — Queries filtering on non-indexed columns scan the entire table. Index any column used in WHERE, JOIN, or ORDER BY clauses for large tables.

  3. Improper migration ordering — Running migrations out of order or skipping intermediate versions breaks schema consistency. Always apply migrations sequentially; never jump versions.

  4. Record conformance shortcuts — Not conforming Record types to PersistableRecord or FetchableRecord correctly leads to silent data loss or deserialization failures. Always implement all required protocols correctly.

  5. ValueObservation without proper cleanup — Forgetting to cancel ValueObservation when views disappear causes memory leaks and stale data subscriptions. Store the cancellable and clean up in deinit.

发现
标签

此技能尚未发布标签。

版本
最新版本元数据

版本

v2026.09.24

发布时间

Sep 24, 2026

分类

未分类

许可证

MIT

源路径

plugins/swift-engineering/skills/grdb

默认分支

main

最新提交

1dc2cf4

Tree SHA

01f1dca