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.