kotlin-exposed-patterns

Implement type-safe Kotlin database access layers with JetBrains Exposed ORM.

2|Updated Apr 7, 2026
One-click install
npx skills add https://github.com/Zenobia000/ai-brainstorming --skill kotlin-exposed-patterns-zenobia000
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: kotlin-exposed-patterns
Source: https://github.com/Zenobia000/ai-brainstorming/tree/main/.claude/custom-rule%26skill/skills/kotlin-exposed-patterns
Command: npx skills add https://github.com/Zenobia000/ai-brainstorming --skill kotlin-exposed-patterns-zenobia000

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill eliminates the boilerplate and risk of implementing inconsistent, non-production-ready database access layers for Kotlin applications using JetBrains Exposed ORM, ensuring coroutine-safe, maintainable data operations.

Core Features & Use Cases

  • Dual Query Pattern Support: Provides ready-to-use patterns for both Exposed DSL (for ad-hoc SQL-like queries) and DAO (for entity lifecycle management) to fit different development needs.
  • Production-Grade Configuration: Includes pre-vetted setups for HikariCP connection pooling, Flyway database migrations, and configurable transaction isolation levels for reliable production deployments.
  • Use Case: Kotlin backend developers building PostgreSQL-backed services can use this Skill to quickly implement user repositories, order processing workflows, and complex join/aggregation queries without writing repetitive boilerplate code.

Quick Start

Use the kotlin-exposed-patterns skill to implement a coroutine-safe user repository with pagination and search functionality for your Kotlin backend 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 build a type-safe Kotlin database access layer with Exposed ORM?

To handle PostgreSQL JSONB columns with Exposed ORM, implement custom column definitions and serialization mappings within your DAO entities, enabling type-safe JSONB query implementation for complex data storage requirements.

How do I configure coroutine-safe transaction handling in Kotlin Exposed?

To configure coroutine-safe transaction handling in Kotlin Exposed, apply production-grade transaction isolation configurations and connection pooling setups, ensuring reliable database operations within concurrent Kotlin backend services.

What is the best way to set up HikariCP connection pooling and Flyway migrations for Kotlin Exposed?

The best way to set up HikariCP connection pooling and Flyway migrations for Kotlin Exposed is using pre-vetted production-grade configurations, ensuring reliable database connection management and schema migration tracking for backend deployments.

Does JetBrains Exposed support both DSL and DAO patterns for PostgreSQL integration?

Yes, JetBrains Exposed supports both DSL and DAO patterns for PostgreSQL integration, allowing developers to use DSL for ad-hoc SQL-like queries and DAO for structured entity lifecycle management within the same application.

How do I handle PostgreSQL JSONB columns with Exposed ORM in Kotlin?

To handle PostgreSQL JSONB columns with Exposed ORM in Kotlin, implement dedicated JSONB column handling patterns provided by the Skill, ensuring type-safe serialization and querying of JSON document data within your repository layer.