How does it handle database migrations?

The skill includes standard patterns for integrating Flyway to manage versioned SQL migration scripts within a Kotlin environment.

Does it support PostgreSQL-specific features like JSONB?

Yes, the patterns include examples for handling JSONB columns and mapping them to Kotlin serialization-ready objects.

Does this skill support both DSL and DAO styles?

Yes, it provides patterns for both Exposed DSL (SQL-like) and DAO (Entity-based) approaches to suit different architectural needs.

Can I use this for production database configurations?

Absolutely; the skill provides configurations for HikariCP, transaction isolation levels, and connection pooling optimized for production.

Is it compatible with Kotlin Coroutines?

Yes, all implementation patterns emphasize the use of newSuspendedTransaction for non-blocking database operations.

Kotlin Exposed ORM Patterns

Name: Kotlin Exposed ORM Patterns
Author: LuciferDono

byLuciferDono

•

データベース管理

Provides comprehensive patterns for database access using JetBrains Exposed ORM, including DSL, DAO, and production-ready configurations.

Kotlin Exposed ORM Patterns is a specialized skill for Claude Code that equips developers with production-grade implementation patterns for the JetBrains Exposed framework. It covers the full database lifecycle, from configuring HikariCP connection pooling and executing Flyway migrations to writing efficient DSL queries and managing complex DAO entities. This skill is ideal for building robust, type-safe data layers, offering guidance on coroutine-safe transactions, advanced joins, pagination, and the repository pattern to ensure business logic remains decoupled from the database.

主な機能

01Automated Flyway migration setup and versioning

02DSL and DAO query patterns for flexible data access

031 GitHub stars

04Production-ready HikariCP connection pool configuration

05Advanced query techniques including joins, subqueries, and pagination

06Coroutine-safe transaction management with newSuspendedTransaction

ユースケース

01Implementing type-safe, asynchronous database repositories

02Managing complex database schema migrations using Flyway

03Setting up a new Kotlin backend service with a PostgreSQL database

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add luciferdono/labs kotlin-exposed-patterns

For use in Claude.ai and ChatGPT

主な機能

01Automated Flyway migration setup and versioning

02DSL and DAO query patterns for flexible data access

031 GitHub stars

04Production-ready HikariCP connection pool configuration

05Advanced query techniques including joins, subqueries, and pagination

06Coroutine-safe transaction management with newSuspendedTransaction

ユースケース

01Implementing type-safe, asynchronous database repositories

02Managing complex database schema migrations using Flyway

03Setting up a new Kotlin backend service with a PostgreSQL database

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add luciferdono/labs kotlin-exposed-patterns

For use in Claude.ai and ChatGPT