skills.rest
tuliopc23
tuliopc23COMMUNITY
Explore all skills by this author →
Website𝕏@tuliopinheiro_GitHub

axiom-grdb

Execute raw SQL and manage SQLite databases on iOS and macOS with GRDB.swift.

Updated Dec 3, 2025
Search Tags:#performance#database#sqlite#ios#macos#sql#grdb
One-click install
npx skills add https://github.com/tuliopc23/flying-dutchman-app --skill axiom-grdb-tuliopc23
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: axiom-grdb
Source: https://github.com/tuliopc23/flying-dutchman-app/tree/main/.claude/skills/axiom-grdb
Command: npx skills add https://github.com/tuliopc23/flying-dutchman-app --skill axiom-grdb-tuliopc23

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill empowers developers to leverage the full power of SQLite directly within their iOS and macOS applications using GRDB.swift, especially for complex data operations that go beyond basic CRUD.

Core Features & Use Cases

  • Raw SQL Execution: Write and execute complex, high-performance SQL queries, including advanced joins and window functions.
  • Reactive Queries: Implement real-time data updates in your UI using GRDB's ValueObservation.
  • Database Migrations: Manage schema evolution safely and efficiently with GRDB's DatabaseMigrator.
  • Performance Optimization: Profile and optimize slow queries using EXPLAIN QUERY PLAN and strategic indexing.
  • Use Case: Efficiently query and display complex relationships between multiple tables (e.g., users, posts, comments, likes) with real-time updates as new content is added.

Quick Start

Use the axiom-grdb skill to set up a DatabaseQueue and fetch all tracks from the 'tracks' table.

Frequently Asked Questions about axiom-grdb

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I execute complex SQL queries with window functions in SQLite on iOS?▼

You can execute complex SQLite queries with window functions on iOS by writing raw SQL within GRDB.swift. This approach enables high-performance data manipulation and advanced custom join logic directly on the database layer.

What is the best way to implement real-time reactive queries for a SQLite database in macOS apps?▼

Reactive queries for SQLite in macOS apps are best implemented using GRDB's ValueObservation. This mechanism automatically observes database changes and triggers real-time UI updates whenever underlying data is modified.

How do I manage SQLite database migrations safely in an iOS application?▼

Manage SQLite database migrations safely in iOS applications using GRDB's DatabaseMigrator. It provides a robust, versioned schema evolution mechanism to apply structural changes without risking data corruption.

How can I profile and optimize slow SQLite queries on macOS?▼

Profile and optimize slow SQLite queries on macOS by running EXPLAIN QUERY PLAN alongside strategic indexing. GRDB.swift supports query profiling to identify performance bottlenecks in complex SQL operations.

Does GRDB.swift support advanced SQLite features like custom join logic for performance-critical apps?▼

Yes, GRDB.swift supports advanced SQLite features including custom join logic and window functions. It is specifically designed to handle complex data operations for performance-critical iOS and macOS applications.

Related Skills

Explore More Software Engineering Skills→
johnrogersjohnrogers
223

grdb

Configure GRDB DatabaseQueue or DatabasePool for type-safe SQLite queries and migrations.

Community
Advanced
HTRTanHTRTan

mysql-optimizer

Analyze MySQL execution plans and rewrite slow queries for better performance.

Community
Advanced
benfwallabenfwalla

convex-realtime

Build React UIs with Convex real-time subscriptions and optimistic updates.

Community
Advanced
bocanbocan
27

persistence-setup

Automate SwiftData or CoreData persistence with CloudKit iCloud sync for Apple platforms.

Community
Advanced