kotlin-exposed-patterns

Implement JetBrains Exposed ORM patterns for Kotlin database access.

1|Updated May 12, 2026
One-click install
npx skills add https://github.com/Manvendra08/TradingBot --skill kotlin-exposed-patterns-manvendra08
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: kotlin-exposed-patterns
Source: https://github.com/Manvendra08/TradingBot/tree/main/_agent/skills/kotlin-exposed-patterns
Command: npx skills add https://github.com/Manvendra08/TradingBot --skill kotlin-exposed-patterns-manvendra08

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill eliminates the tedious, error-prone work of writing repetitive database boilerplate for Kotlin applications, removing the need to manually manage JDBC connections, raw SQL queries, and entity-to-model mapping for common data access tasks.

Core Features & Use Cases

  • Type-Safe Query Patterns: Use Exposed's DSL for SQL-like type-safe queries or DAO pattern for entity lifecycle management, covering all common CRUD operations.
  • Production-Ready Setup: Includes ready-to-use configurations for HikariCP connection pooling, Flyway database migrations, and coroutine-safe transaction handling.
  • Use Case: A Kotlin microservice team can use this Skill to implement a fully testable user repository with pagination, JSONB metadata support, and in-memory H2 testing in a fraction of the time it would take to build from scratch.

Quick Start

Use the kotlin-exposed-patterns skill to implement a coroutine-safe user repository with pagination and JSONB metadata support for a Kotlin PostgreSQL service.

Frequently Asked Questions about kotlin-exposed-patterns

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

FAQPage Schema
How do I set up JetBrains Exposed ORM with HikariCP connection pooling in Kotlin?

To set up JetBrains Exposed ORM with HikariCP, configure connection pooling alongside Flyway migrations and coroutine-safe transaction handling to establish production-ready database access workflows in Kotlin applications.

What's the best way to implement the repository pattern in Kotlin using Exposed ORM?

The best way to implement the repository pattern with Exposed ORM is using structured type-safe DSL queries or DAO patterns for entity lifecycle management, covering CRUD operations, pagination, and batch operations.

Does Exposed ORM support JSONB column handling and pagination for PostgreSQL?

Yes, Exposed ORM supports JSONB column handling and pagination for PostgreSQL databases. It provides structured patterns for type-safe queries and batch operations specifically designed for PostgreSQL and H2 database environments.

Can I use Kotlin coroutines with Exposed ORM for database transactions?

Yes, you can use Kotlin coroutines with Exposed ORM for database transactions. The framework provides coroutine-safe transaction handling patterns that ensure safe concurrent database access within Kotlin applications.

How do I configure in-memory H2 database testing with Exposed ORM in Kotlin?

To configure in-memory H2 database testing with Exposed ORM, set up H2 in-memory test environments alongside Exposed's type-safe DSL patterns and Flyway migrations to enable fully testable repository implementations in Kotlin microservices.

Do I need Flyway database migrations for Kotlin Exposed ORM setup?

Flyway database migrations are included in the production-ready setup for Kotlin Exposed ORM. They provide structured schema management alongside HikariCP connection pooling and coroutine-safe transactions for complete database access workflows.