kotlin-exposed-patterns

Provide Kotlin patterns for JetBrains Exposed ORM database access.

1|Updated Apr 21, 2026

Search Tags:#transaction management #Kotlin #database access #Exposed ORM #Kotlin DSL

Ready to run

npx skills add https://github.com/ROYCE-8425/ai-marketing-hub --skill kotlin-exposed-patterns-royce-8425

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: kotlin-exposed-patterns
Source: https://github.com/ROYCE-8425/ai-marketing-hub/tree/main/skills/kotlin-exposed-patterns
Command: npx skills add https://github.com/ROYCE-8425/ai-marketing-hub --skill kotlin-exposed-patterns-royce-8425

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires org.jetbrains.exposed:exposed-core, org.jetbrains.exposed:exposed-dao, org.jetbrains.exposed:exposed-jdbc, org.jetbrains.exposed:exposed-kotlin-datetime, org.jetbrains.exposed:exposed-json, org.postgresql:postgresql, com.zaxxer:HikariCP, org.flywaydb:flyway-core, org.h2:h2, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill addresses the complexities of database access with Kotlin Exposed ORM, providing patterns for efficient querying, transaction management, and schema evolution.

Core Features & Use Cases

DSL Queries: Execute complex SQL-like queries using Kotlin DSL.
DAO Pattern: Manage entity lifecycle and enforce separation of concerns.
Transactions: Ensure atomicity and consistency in database operations.
Connection Pooling: Leverage HikariCP for efficient connection management.
Migrations: Implement schema changes with Flyway migrations.
Repository Pattern: Abstract database access for business logic, enabling testability.
Use Case: If you're building a Kotlin application with a relational database and need a robust, efficient, and maintainable data access layer, this Skill will be invaluable.

Quick Start

Start by setting up your database connection and execute a query using the DSL.

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 database transactions in Kotlin Exposed ORM?▼

Implement the DAO pattern in Kotlin Exposed to manage entity lifecycle and enforce separation of concerns. This Skill provides structural patterns to abstract database rows into domain objects, making your data access layer more maintainable and testable for relational databases.

Does Kotlin Exposed ORM work with HikariCP for connection pooling?▼

Use Flyway database migrations with Kotlin Exposed to implement controlled schema changes and versioning. This Skill covers integrating Flyway alongside your Exposed data access layer, ensuring reliable schema evolution without manual database intervention.

What's the best way to structure a data access layer using Kotlin Exposed DSL?▼

The best way to structure a data access layer using Kotlin Exposed DSL is by applying the repository pattern to abstract database access from business logic. This Skill provides patterns to map DSL queries into repositories, significantly enhancing application testability.

Can I use Kotlin Exposed ORM for complex SQL-like queries?▼

Yes, you can use Kotlin Exposed ORM to execute complex SQL-like queries using the Kotlin DSL. This Skill offers comprehensive patterns for constructing type-safe DSL queries, enabling efficient and expressive database access directly within Kotlin applications.