skills.rest
contentbugvideoediting
contentbugvideoeditingCOMMUNITY
Explore all skills by this author →
GitHub

kotlin-exposed-patterns

Automate Kotlin database access with JetBrains Exposed ORM patterns.

Updated Aug 23, 2026
Search Tags:#orm#transactions#kotlin#flyway#exposed#dsl-queries#dao-pattern
One-click install
npx skills add https://github.com/contentbugvideoediting/cb-project-assistant --skill kotlin-exposed-patterns-contentbugvideoediting
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: kotlin-exposed-patterns
Source: https://github.com/contentbugvideoediting/cb-project-assistant/tree/main/services/cb-s-claude/vendor/s-claude/skills-library/kotlin-exposed-patterns
Command: npx skills add https://github.com/contentbugvideoediting/cb-project-assistant --skill kotlin-exposed-patterns-contentbugvideoediting

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Exposed ORM is a robust tool for building Kotlin-based data layers, but teams often struggle with integrating DSL queries, DAO entities, transaction management, and migrations in a cohesive pattern. This skill consolidates best practices into a single reference to accelerate safe, scalable data access.

Core Features & Use Cases

  • DSL Queries: Write type-safe SQL-like queries using Exposed DSL.
  • DAO Pattern: Manage entity lifecycles with Exposed DAO entities.
  • Transaction & Isolation: Use newSuspendedTransaction and customizable isolation levels for coroutine-safe operations.
  • Migration & Configuration: Integrate Flyway migrations and HikariCP connection pooling for production readiness.
  • Repository Pattern: Encapsulate data access behind a clean interface for testability.

Quick Start

Create a Kotlin project and implement a sample User entity using Exposed DSL, DAO, and Flyway migrations.

Frequently Asked Questions about kotlin-exposed-patterns

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

FAQPage Schema
How do I manage coroutine-safe transactions with Kotlin Exposed?▼

Structure Kotlin Exposed data access by encapsulating logic behind a repository pattern. This provides a clean interface for data operations, separating query execution from business logic and ensuring the data layer remains fully testable.

What is the best way to configure Flyway migrations and HikariCP with Kotlin Exposed?▼

Configure Flyway migrations and HikariCP connection pooling alongside Kotlin Exposed to achieve production-ready database access. This integration manages schema evolution and efficient connection distribution for scalable applications.

Does Kotlin Exposed support both DSL queries and the DAO pattern?▼

Kotlin Exposed supports both type-safe SQL-like DSL queries and the DAO pattern for managing entity lifecycles. Teams can combine both approaches within a single cohesive data access layer to handle varying query complexity.

How do I structure repository encapsulation for testable data access in Kotlin?▼

Structure Kotlin Exposed data access by encapsulating logic behind a repository pattern. This provides a clean interface for data operations, separating query execution from business logic and ensuring the data layer remains fully testable.

Related Skills

Explore More Software Engineering Skills→
KimjimanKimjiman

kotlin-exposed-patterns

Demonstrate database interaction patterns with JetBrains Exposed ORM in Kotlin.

Community
Advanced
twentyhqtwentyhq
54.6k

syncable-entity-integration

Integrate syncable entity services and resolvers into NestJS modules for Twenty entities.

Official
Advanced
TeiNamTeiNam
12

kotlin-exposed-patterns

Implement Kotlin Exposed ORM patterns for database access with HikariCP and Flyway.

Community
Intermediate
OpenAEC-FoundationOpenAEC-Foundation
163

erpnext-database

Guide ERPNext database interactions across ORM, queries, and raw SQL.

Official
Advanced