Does this skill support both DSL and DAO styles?

Yes, it provides comprehensive patterns and examples for both Exposed DSL queries and the DAO entity-based approach.

Can I use these patterns for non-blocking database calls?

Yes, the patterns utilize `newSuspendedTransaction` to ensure database operations work seamlessly with Kotlin Coroutines.

Does it include help for database migrations?

Yes, it includes implementation guides for Flyway to manage versioned SQL migrations and schema updates.

Is HikariCP configuration covered?

Yes, it provides production-ready configuration templates for HikariCP connection pooling to ensure optimal performance.

Kotlin Exposed ORM Patterns

Name: Kotlin Exposed ORM Patterns
Author: affaan-m

byaffaan-m

•

156,032

•

Database Management

Simplifies database access in Kotlin using JetBrains Exposed with ready-to-use patterns for DSL, DAO, and migrations.

This skill provides a comprehensive library of design patterns and implementation guides for JetBrains Exposed, the lightweight SQL library for Kotlin. It covers the full database lifecycle, from configuring HikariCP connection pooling and Flyway migrations to implementing complex DSL queries and the DAO (Data Access Object) pattern. By providing standardized templates for table definitions, batch operations, and pagination, this skill ensures type-safe database operations, efficient transaction handling with coroutines, and clean repository architectures that decouple business logic from the data layer.

Key Features

01Standardized repository pattern for clean architecture

02DSL and DAO query patterns for type-safe database access

03Coroutine-safe transaction handling via newSuspendedTransaction

04Production-ready HikariCP connection pool configuration

05156,032 GitHub stars

06Automated schema management with Flyway migrations

Use Cases

01Setting up a new Kotlin backend with PostgreSQL or H2 databases

02Implementing complex table relationships and join queries

03Refactoring raw SQL queries into type-safe Exposed DSL code

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add affaan-m/everything-claude-code kotlin-exposed-patterns

For use in Claude.ai and ChatGPT

Key Features

01Standardized repository pattern for clean architecture

02DSL and DAO query patterns for type-safe database access

03Coroutine-safe transaction handling via newSuspendedTransaction

04Production-ready HikariCP connection pool configuration

05156,032 GitHub stars

06Automated schema management with Flyway migrations

Use Cases

01Setting up a new Kotlin backend with PostgreSQL or H2 databases

02Implementing complex table relationships and join queries

03Refactoring raw SQL queries into type-safe Exposed DSL code

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add affaan-m/everything-claude-code kotlin-exposed-patterns

For use in Claude.ai and ChatGPT