What problem does it solve? Setting up database access in Kotlin backend services involves many decisions: choosing between DSL and DAO query styles, configuring connection pooling, managing schema migrations, and structuring testable data layers. This Skill provides production-oriented patterns for all of these with JetBrains Exposed ORM. ## Core Features & Use Cases - DSL and DAO Query Patterns: Covers CRUD operations, joins, aggregations, subqueries, pagination, batch inserts, and upserts using both Exposed DSL and DAO entity styles. - Production Database Setup: Includes HikariCP connection pool configuration, Flyway versioned migrations, and coroutine-safe transactions via newSuspendedTransaction. - Repository Pattern & Testing: Shows how to wrap Exposed behind a repository interface and test against an in-memory H2 database in PostgreSQL compatibility mode. - Use Case: When building a Ktor or Spring-less Kotlin service backed by PostgreSQL, use this Skill to scaffold the table definitions, repository layer, migrations, and tests in one consistent style. ## Quick Start Ask the AI to set up an Exposed-based user repository with HikariCP pooling, Flyway migrations, and H2-backed tests for a Kotlin project.
