kotlin-exposed-patterns

Structure Kotlin data access with JetBrains Exposed DSL and DAO patterns.

Updated Mar 25, 2026
One-click install
npx skills add https://github.com/SOLEROM/cldlab --skill kotlin-exposed-patterns-solerom
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: kotlin-exposed-patterns
Source: https://github.com/SOLEROM/cldlab/tree/main/ecc/ref_claude/skills/kotlin-exposed-patterns
Command: npx skills add https://github.com/SOLEROM/cldlab --skill kotlin-exposed-patterns-solerom

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Structuring robust, production-grade data access in Kotlin applications using JetBrains Exposed, covering DSL queries, DAO lifecycle, transactions, and migrations.

Core Features & Use Cases

  • DSL Queries: Build expressive, type-safe SQL-like queries with the Exposed DSL.
  • DAO Pattern & Repositories: Use entity lifecycle management and repository abstractions to decouple business logic from data access.
  • Transactions & Isolation: Ensure atomic operations inside coroutine-safe transactions with proper isolation handling.
  • Migrations & Pooling: Manage migrations with Flyway and configure efficient connection pooling with HikariCP.

Quick Start

Start by wiring Exposed with a database, define your Tables and Entities, and implement a repository using the Exposed patterns.

Frequently Asked Questions about kotlin-exposed-patterns

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I structure production-grade data access in Kotlin using JetBrains Exposed?

Production-grade data access in Kotlin using JetBrains Exposed requires structuring DSL queries, DAO lifecycle management, transactional integrity, and schema migrations. You implement repository abstractions to decouple business logic from data access layers.

How do I handle coroutine-safe transactions with Exposed to ensure isolation?

Coroutine-safe transactions with Exposed ensure atomic operations by handling proper transaction isolation within coroutine contexts. This approach maintains transactional integrity while executing database operations concurrently across Kotlin coroutines.

What's the best way to configure HikariCP connection pooling with Kotlin Exposed?

Configuring HikariCP connection pooling with Kotlin Exposed involves setting up efficient connection management for your database access layer. This production-grade setup ensures reliable connection handling alongside Flyway migrations for schema evolution.

Does the DAO pattern work with Kotlin Exposed for repository-based data access?

The DAO pattern works with Kotlin Exposed by providing entity lifecycle management and repository abstractions. This decouples business logic from data access, allowing you to build type-safe SQL-like queries using the Exposed DSL.

How do I manage database migrations with Flyway alongside Kotlin Exposed?

Managing database migrations with Flyway alongside Kotlin Exposed involves coordinating schema evolution with your data access layer configuration. This setup integrates HikariCP pooling and coroutine-safe transactions for production-grade reliability.

Can I build type-safe SQL queries using the Exposed DSL in Kotlin?

You can build expressive, type-safe SQL-like queries using the Exposed DSL in Kotlin. This approach forms the foundation of robust data access patterns, complementing DAO lifecycle management and transactional integrity for production applications.