Construct type-safe SQL queries in Swift using GRDB and swift-structured-queries.
npx skills add https://github.com/wyattjoh/skills --skill swift-sql
Please help me install this Agent Skill. Skill: swift-sql Source: https://github.com/wyattjoh/skills/tree/main/skills/swift-sql Command: npx skills add https://github.com/wyattjoh/skills --skill swift-sql
This skill addresses the complexity of writing type-safe database queries in Swift, providing a unified approach to using the swift-structured-queries DSL, GRDB.swift, and the #sql macro.
Use the swift-sql skill to generate a type-safe query for fetching active records with a specific filter and ordering.
High-intent search queries and answers about installing and using this skill.
Type-safe SQL queries in Swift are constructed using closures and DSLs to ensure compile-time safety for filters, joins, and ordering. This approach prevents runtime errors by validating query structure during compilation.
GRDB supports advanced SQL features like window functions and CTEs through the #sql macro. This macro enables complex subqueries that exceed standard DSL capabilities while maintaining type safety.
SQLite performance in iOS Swift applications is optimized by implementing covering indexes, enabling WAL mode, and using efficient aggregation patterns. These strategies ensure high-performance database interactions for robust data access layers.
The swift-structured-queries DSL can be used for server-side Swift projects to facilitate complex database operations. It provides robust, performant, and maintainable data access layers suitable for both iOS and server-side environments.
Complex subqueries in Swift SQL are best handled using the #sql macro, which allows you to write window functions, CTEs, and complex subqueries that exceed standard DSL capabilities while maintaining type safety.
The #sql macro should be used instead of the standard Swift SQL DSL when you need window functions, CTEs, or complex subqueries that exceed standard DSL capabilities. It bridges the gap between type safety and advanced SQL features.
harivansh-afkWrite and optimize raw SQL queries with GRDB.swift in Swift projects.
jayantrohila57Define SQL schemas and write type-safe queries with Drizzle ORM.
jg-chalk-ioImplement Swift 6.0 patterns for async/await, SwiftUI, Combine, and Vapor.
joelhooksGuide SwiftData persistence with @Model, @Query, and CloudKit integration.
