kotlin-exposed-patterns

Name: kotlin-exposed-patterns
Availability: InStock
Author: ramblerainbow

Implement coroutine-safe database access layers with JetBrains Exposed ORM.

Updated May 9, 2026

Search Tags:#repository pattern #kotlin #flyway #database access #kotlin coroutines #hikaricp #exposed orm

Ready to run

npx skills add https://github.com/RambleRainbow/jd --skill kotlin-exposed-patterns-ramblerainbow

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: kotlin-exposed-patterns
Source: https://github.com/RambleRainbow/jd/tree/main/.claude/skills/kotlin-exposed-patterns
Command: npx skills add https://github.com/RambleRainbow/jd --skill kotlin-exposed-patterns-ramblerainbow

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill eliminates the complexity of building maintainable, production-ready database access layers for Kotlin applications using JetBrains Exposed ORM, reducing boilerplate and ensuring coroutine-safe, atomic database operations without manual SQL writing.

Core Features & Use Cases

Dual Query Patterns: Supports both Exposed DSL for direct SQL-like queries and DAO pattern for entity lifecycle management.
Production Configuration: Includes pre-built patterns for HikariCP connection pooling, Flyway database migrations, and configurable transaction isolation levels.
Use Case: For example, use this Skill to quickly implement a testable user repository with pagination, JSONB column support, and in-memory H2 testing for a Kotlin microservice.

Quick Start

Use the kotlin-exposed-patterns skill to generate a coroutine-safe user repository with pagination and HikariCP connection pooling for your Kotlin application.

Frequently Asked Questions about kotlin-exposed-patterns

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

FAQPage Schema

How do I implement a coroutine-safe database access layer using Kotlin Exposed?▼

To implement a coroutine-safe database access layer with Kotlin Exposed, use repository patterns that ensure transaction safety and atomic database operations without manual SQL. This approach configures HikariCP connection pooling to manage concurrent data access.

Can I use Kotlin Exposed with Flyway for database migrations and HikariCP for connection pooling?▼

Yes, Kotlin Exposed works seamlessly with Flyway for database migrations and HikariCP for connection pooling. This combination provides production-ready configuration, ensuring reliable database schema management and efficient connection handling.

What is the best way to structure Kotlin Exposed queries using DSL versus DAO patterns?▼

Choosing between DSL and DAO patterns in Kotlin Exposed depends on your needs: use DSL for direct SQL-like queries and DAO for entity lifecycle management. Combining both allows flexible, maintainable data access layers.

How do I handle JSONB columns and pagination in a Kotlin Exposed repository?▼

Handling JSONB columns and pagination in a Kotlin Exposed repository involves utilizing built-in support for JSONB data types and implementing batch operations. This enables efficient querying and processing of complex data structures.

How do you test Kotlin Exposed repositories using an in-memory H2 database?▼

Testing Kotlin Exposed repositories uses an in-memory H2 database to provide testable data access. This method ensures isolated, fast, and reliable testing of your data access layers without requiring a full external database setup.