What problem does it solve? Setting up database access in Kotlin backend services requires coordinating ORM queries, connection pooling, schema migrations, and transaction management, which is error-prone when done from scratch. This Skill provides ready-to-apply patterns for the JetBrains Exposed ORM so you can build a consistent, coroutine-safe data layer quickly. ## Core Features & Use Cases - DSL and DAO Query Patterns: Write CRUD operations, joins, aggregations, subqueries, pagination, batch inserts, and upserts using either Exposed's SQL-like DSL or its entity-based DAO style. - Production Database Setup: Configure HikariCP connection pooling, run versioned Flyway migrations at startup, and define tables with JSONB columns via kotlinx.serialization. - Repository Pattern & Testing: Wrap Exposed queries behind repository interfaces and test them against an in-memory H2 database in PostgreSQL compatibility mode. - Use Case: You are building a Ktor service backed by PostgreSQL. Use this Skill to scaffold the UsersTable definition, a paginated ExposedUserRepository, Flyway migration scripts, and H2-based unit tests in one pass. ## Quick Start Ask the AI to create an Exposed repository with HikariCP configuration and Flyway migrations for a PostgreSQL users table.
