Does it support reactive UI updates?

Absolutely, it provides patterns for Flow-based queries that automatically emit updates to your UI components whenever the underlying database data changes.

What is SQLDelight in the context of KMP?

SQLDelight is a library that generates type-safe Kotlin APIs from your SQL statements, ensuring compile-time safety across Android, iOS, and other platforms within a Kotlin Multiplatform project.

How does this skill handle platform-specific drivers?

It provides standardized setup patterns for AndroidSqliteDriver and NativeSqliteDriver to ensure consistent database access across different mobile and desktop environments.

Can I use this for offline-first applications?

Yes, the skill includes advanced sync patterns, including soft deletes, version incrementing, and sync status tracking for building robust offline-first architectures.

How are database migrations managed?

The skill outlines the specific directory structure and naming conventions for .sqm migration files to ensure seamless and safe schema evolution over time.

SQLDelight KMP Database Integration

Name: SQLDelight KMP Database Integration
Author: pddhkt

bypddhkt

0•

Database Management

Generates type-safe Kotlin APIs from SQL schemas for robust cross-platform data persistence in Kotlin Multiplatform projects.

This skill empowers Claude to architect and implement SQLDelight-based database layers within Kotlin Multiplatform (KMP) applications. It provides standardized patterns for creating type-safe schemas, writing reactive SQL queries with Flow support, managing complex migrations, and implementing advanced synchronization workflows like soft deletes and version-based conflict resolution. Whether you are setting up platform-specific drivers for Android and iOS or integrating with Koin for dependency injection, this skill ensures your persistence layer follows industry best practices for performance and maintainability.

Key Features

01Automated migration script templates and version management

02Type-safe Kotlin API generation from native SQL files

03Cross-platform driver configuration for Android, iOS, JVM, and JS

040 GitHub stars

05Advanced sync patterns including soft deletes and versioning

06Reactive query patterns with Kotlin Coroutines Flow support

Use Cases

01Building local-first KMP applications with offline synchronization

02Architecting reactive UI layers that update automatically on database changes

03Implementing type-safe database migrations across multiple platforms

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add pddhkt/kotlin-kmp-skills sqldelight

For use in Claude.ai and ChatGPT

Download Skill