axiom-sqlitedata-ref

Explain advanced SQLiteData query patterns using GRDB and StructuredQueries in Swift.

Updated Dec 3, 2025

Search Tags:#database #data modeling #sqlite #swift #orm #querying #advanced patterns

Ready to run

npx skills add https://github.com/tuliopc23/flying-dutchman-app --skill axiom-sqlitedata-ref

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: axiom-sqlitedata-ref
Source: https://github.com/tuliopc23/flying-dutchman-app/tree/main/.claude/skills/axiom-sqlitedata-ref
Command: npx skills add https://github.com/tuliopc23/flying-dutchman-app --skill axiom-sqlitedata-ref

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides advanced techniques for using SQLiteData, enabling more complex data modeling, efficient querying, and robust application development with SQLite.

Core Features & Use Cases

Schema Composition: Utilize column groups and single-table inheritance for cleaner, reusable data models.
Advanced Querying: Master CTEs, custom aggregates, JSON functions, and full-text search for powerful data retrieval.
Use Case: Build a complex reporting dashboard by fetching multiple related data sets in a single database transaction using @Fetch, and then display aggregated string data from related tables using groupConcat.

Quick Start

Use the axiom-sqlitedata-ref skill to fetch all items created after a specific date.

Frequently Asked Questions about axiom-sqlitedata-ref

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

FAQPage Schema

How do I implement recursive CTEs in SQLite using Swift?▼

Recursive CTEs in SQLite using Swift can be implemented leveraging StructuredQueries and GRDB within SQLiteData. This Skill explains query composition techniques, enabling hierarchical data retrieval and robust complex database operations natively.

What is single-table inheritance in SQLite data modeling?▼

Single-table inheritance in SQLite data modeling allows multiple entity types to share a single database table using column groups for cleaner schemas. This Skill details structuring these reusable data models efficiently within your Swift application architecture.

Can I use JSON functions and custom aggregates in GRDB queries?▼

Yes, JSON functions and custom aggregates work in GRDB queries. This Skill details leveraging SQLiteData for data retrieval, covering JSON functions, string aggregation with groupConcat, and building custom aggregate functions for complex Swift reporting.

How do I perform TableAlias self-joins in StructuredQueries?▼

TableAlias self-joins in StructuredQueries are performed by referencing the same table multiple times using aliases. This Skill demonstrates advanced SQLiteData query composition patterns for comparing records within the same table directly in Swift.

Does SQLiteData support creating database views in Swift?▼

SQLiteData supports creating database views in Swift. This Skill explains advanced SQLite patterns including database views, allowing you to encapsulate complex query logic and securely expose simplified data representations to your Swift application.

What are the limitations of using SQLiteData for complex querying?▼

Limitations of SQLiteData for complex querying involve managing intricate recursive CTEs and custom aggregates. This Skill explains advanced SQLite patterns and edge cases to navigate constraints when building robust Swift applications with complex data modeling requirements.