Execute raw SQL against SQLite databases using GRDB in Swift.
npx skills add https://github.com/CharlesWiltgen/Axiom --skill grdb
Please help me install this Agent Skill. Skill: grdb Source: https://github.com/CharlesWiltgen/Axiom/tree/main/.claude-plugin/plugins/axiom/skills/grdb Command: npx skills add https://github.com/CharlesWiltgen/Axiom --skill grdb
Direct SQLite access with type-safe queries, migrations, and reactive observations when you need complex joins, aggregations, or fine-grained performance control.
Prompt: "Show me a JOIN across messages and authors with a group count."
High-intent search queries and answers about installing and using this skill.
GRDB provides type-safe SQLite query execution with complex joins across multiple tables. Use raw SQL wrapped in typed interfaces with Codable or PersistableRecord to maintain compile-time safety while joining messages, authors, and other tables with aggregations and filtering.
Yes. GRDB's ValueObservation enables reactive UI updates by observing SQLite query results and automatically notifying your app when data changes, eliminating manual refresh logic while maintaining type safety across iOS 13+ and macOS.
GRDB's DatabaseMigrator pattern manages schema upgrades sequentially and safely. Define migrations as versioned steps, apply them automatically on app launch, and roll back failed migrations to prevent data corruption during app updates.
GRDB supports DatabaseQueue for single-threaded apps and DatabasePool for concurrent access, giving you explicit control over performance trade-offs. Profile complex joins and aggregations to tune query execution and manage contention across iOS and macOS targets.
Yes, GRDB accesses existing SQLite databases directly with raw SQL and typed interfaces. It requires iOS 13+ and Swift 5.7+, supports both DatabaseQueue and DatabasePool for different concurrency models, and integrates migrations for schema evolution.
Use GRDB's raw SQL when you need complex joins, custom aggregations, or fine-grained performance control that query builders obscure. Type-safe wrappers prevent runtime errors while preserving SQL's expressiveness for sophisticated multi-table operations.
CharlesWiltgenExecute raw SQL against SQLite databases using GRDB in Swift.
besoeasyQuery SQLite, PostgreSQL, and MySQL databases and export results to CSV or JSON.
dragoscirjanEnforce Google Swift Style and modern Swift practices for consistent code.
albertdobmeyerManage SQL database tasks across SQLite, PostgreSQL, and MySQL.
