Axiom Grdb

What it does

This skill, Axiom Grdb, provides direct access to SQLite databases using GRDB.swift, a toolkit for SQLite that offers type-safe queries, migrations, and reactive observation capabilities. It allows AI agents to perform complex database operations when full control over SQL is needed, offering the power of raw SQL alongside Swift's type safety. This skill requires iOS 13+ and Swift 5.7+.

When to use it

This skill is best suited for scenarios requiring advanced SQLite functionality:

• Complex SQL joins across four or more tables.
• Using window functions (ROW_NUMBER, RANK, LAG/LEAD).
• Implementing reactive queries with ValueObservation.
• Needing full control over SQL for performance optimization.
• Executing advanced migration logic beyond simple schema changes.

Key capabilities

• Type-safe Swift wrapper around raw SQL.
• Support for complex SQL joins and aggregations.
• Reactive query updates using ValueObservation.
• Customizable database migrations with rollback patterns.
• Query profiling and optimization via EXPLAIN QUERY PLAN and database.trace.

Example prompts

Here are some example prompts an AI agent with this skill could respond to:

1. "I need to query messages with their authors and count of reactions in one query. How do I write the JOIN?"
2. "I want to observe a filtered list and update the UI whenever notes with a specific tag change."
3. "My query is slow (takes 10+ seconds). How do I profile and optimize it?"

Tips & gotchas

• This skill requires iOS 13+ and Swift 5.7+.
• Consider using SQLiteData instead if type-safe @Table models are sufficient or CloudKit sync is needed.
• For safe schema evolution patterns, refer to the axiom-database-migration skill.