How does it handle database transactions with coroutines?

The skill emphasizes the use of newSuspendedTransaction to ensure that database operations are non-blocking and safe to use within Kotlin coroutines.

Does this skill support both DSL and DAO styles in Exposed?

Yes, it provides comprehensive patterns and code examples for both the SQL-like DSL approach and the entity-based DAO approach.

Does it include help for database migrations?

Yes, it provides integration patterns for Flyway, allowing you to manage versioned SQL migrations alongside your Kotlin code.

Can I use this for setting up production database connections?

Absolutely. It includes standardized configurations for HikariCP, which is the industry standard for high-performance connection pooling in JVM applications.

Kotlin Exposed ORM Patterns

Name: Kotlin Exposed ORM Patterns
Author: saar120

bysaar120

0•

Database Management

Implements production-ready database patterns using JetBrains Exposed ORM for Kotlin applications, including DSL, DAO, and migrations.

This skill provides a comprehensive suite of implementation patterns for JetBrains Exposed, the lightweight SQL library for Kotlin. It bridges the gap between raw SQL and type-safe code by offering structured guidance on both DSL and DAO query styles, HikariCP connection pool optimization, and Flyway migration integration. Whether building high-performance asynchronous backends with Ktor or structured enterprise services, this skill ensures your data layer follows best practices for transaction management, coroutine safety, and repository decoupling.

Key Features

010 GitHub stars

02Type-safe DSL and DAO query patterns

03Production-ready HikariCP connection pool configuration

04Advanced data patterns for pagination, batching, and JSONB columns

05Automated database migrations with Flyway integration

06Coroutine-safe transaction management using newSuspendedTransaction

Use Cases

01Refactoring legacy SQL queries into type-safe Kotlin code using Exposed DSL

02Implementing automated database schema versioning and migration workflows

03Developing a robust data access layer for Ktor or Spring Boot microservices

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add saar120/skillgate-registry kotlin-exposed-patterns

For use in Claude.ai and ChatGPT

Key Features

010 GitHub stars

02Type-safe DSL and DAO query patterns

03Production-ready HikariCP connection pool configuration

04Advanced data patterns for pagination, batching, and JSONB columns

05Automated database migrations with Flyway integration

06Coroutine-safe transaction management using newSuspendedTransaction

Use Cases

01Refactoring legacy SQL queries into type-safe Kotlin code using Exposed DSL

02Implementing automated database schema versioning and migration workflows

03Developing a robust data access layer for Ktor or Spring Boot microservices

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add saar120/skillgate-registry kotlin-exposed-patterns

For use in Claude.ai and ChatGPT