skills.rest
devs6186
devs6186COMMUNITY
Explore all skills by this author →
GitHub

kotlin-exposed-patterns

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

1|Updated Mar 19, 2026
Search Tags:#repository#orm#transactions#kotlin#flyway#exposed#hikaricp
One-click install
npx skills add https://github.com/devs6186/claude-private-skills-agents-commands --skill kotlin-exposed-patterns-devs6186
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: kotlin-exposed-patterns
Source: https://github.com/devs6186/claude-private-skills-agents-commands/tree/main/skills/kotlin-exposed-patterns
Command: npx skills add https://github.com/devs6186/claude-private-skills-agents-commands --skill kotlin-exposed-patterns-devs6186

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Exposes a production-grade approach to database access in Kotlin using JetBrains Exposed, covering both DSL queries and DAO patterns, with proper transaction handling and migrations to ensure schema consistency.

Core Features & Use Cases

  • DSL queries and DAO pattern for entity management
  • Transaction management using newSuspendedTransaction
  • HikariCP connection pooling configuration
  • Flyway migrations for versioned schema
  • Repository pattern to decouple business logic from data access
  • JSON column support and in-memory testing with Exposed on H2

Quick Start

Set up a Kotlin project with Exposed and implement a basic User repository using DSL or DAO in a coroutine-friendly transaction.

Frequently Asked Questions about kotlin-exposed-patterns

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

FAQPage Schema
How do I use Kotlin Exposed with coroutines for database transactions?▼

Kotlin Exposed supports coroutine-safe database transactions by using newSuspendedTransaction blocks, which allow you to execute DSL queries and DAO operations without blocking threads in your backend application.

What's the best way to structure Kotlin Exposed data access logic?▼

The repository pattern is the best way to structure Kotlin Exposed data access, as it decouples your business logic from data access implementation details and works cleanly with both DSL queries and DAO entities.

Does Kotlin Exposed work with Flyway for database schema migrations?▼

Yes, Kotlin Exposed works with Flyway to handle versioned schema migrations, ensuring database schema consistency across your application environments alongside HikariCP connection pooling.

Can I use Kotlin Exposed for JSON column support and in-memory testing?▼

Kotlin Exposed provides JSON column support through exposed-json and supports in-memory testing using an H2 database, allowing you to validate repository logic and entity management without a full PostgreSQL setup.

When should I choose between Exposed DSL queries and the DAO pattern?▼

Choose Exposed DSL queries for flexible, SQL-like syntax and the DAO pattern when you need object-oriented entity management, as both approaches integrate seamlessly with newSuspendedTransaction for coroutine-safe execution.

Related Skills

Explore More Software Engineering Skills→
bluetape4kbluetape4k
8

exposed-r2dbc

Implement reactive database access with Exposed, R2DBC, and Kotlin Coroutines.

Official
Advanced
K-Dense-AIK-Dense-AI
33.0k

paper-lookup

Search scholarly papers across 10 databases via REST APIs and return raw responses with endpoints.

Official
Advanced
hector-mannyhector-manny

kotlin-exposed-patterns

Provides Kotlin patterns for JetBrains Exposed ORM covering DSL, DAO, transactions, HikariCP, and Flyway.

Community
Advanced
JamkrisJamkris
86

kotlin-exposed-patterns

Automates Kotlin database access with Exposed DSL, DAO, coroutine-safe transactions, HikariCP pooling, Flyway migrations, and repositories.

Community
Advanced