skills.rest
thangvawn
thangvawnCOMMUNITY
Explore all skills by this author →
GitHub

kotlin-exposed-patterns

Provide Kotlin database access patterns using JetBrains Exposed ORM.

Updated Apr 6, 2026
Search Tags:#transactions#Kotlin#database access#Exposed ORM#DSL queries#DAO pattern
One-click install
npx skills add https://github.com/thangvawn/agent_financial --skill kotlin-exposed-patterns-thangvawn
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: kotlin-exposed-patterns
Source: https://github.com/thangvawn/agent_financial/tree/main/.cursor/skills/kotlin-exposed-patterns
Command: npx skills add https://github.com/thangvawn/agent_financial --skill kotlin-exposed-patterns-thangvawn

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires org.jetbrains.exposed:exposed-core, org.jetbrains.exposed:exposed-dao, org.jetbrains.exposed:exposed-jdbc, org.jetbrains.exposed:exposed-kotlin-datetime, org.jetbrains.exposed:exposed-json, org.postgresql:postgresql, com.zaxxer:HikariCP, org.flywaydb:flyway-core, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides patterns for efficient database access in Kotlin using JetBrains Exposed ORM, streamlining SQL queries, transactions, and configuration.

Core Features & Use Cases

  • DSL Queries: Write SQL-like queries using Kotlin DSL for direct expressions.
  • DAO Pattern: Implement entity lifecycle management with the DAO pattern.
  • Transactions: Ensure atomicity and safety with transaction management.
  • HikariCP: Configure connection pooling with HikariCP for performance.
  • Flyway Migrations: Manage database schema changes with Flyway migrations.
  • Repository Pattern: Encapsulate Exposed queries for decoupled business logic.
  • Use Case: For a Kotlin developer, this Skill can be used to build a robust, efficient database-driven application with clear separation of concerns and strong data handling capabilities.

Quick Start

Run the skill to explore Kotlin Exposed patterns for database access.

Frequently Asked Questions about kotlin-exposed-patterns

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

FAQPage Schema
How do I configure database connection pooling with Kotlin Exposed and HikariCP?▼

Implement the repository pattern with Kotlin Exposed by encapsulating DSL queries and DAO operations within dedicated repository classes. This Skill demonstrates how to decouple business logic from direct database access using structured repository implementations.

What is the difference between DSL queries and the DAO pattern in JetBrains Exposed?▼

Manage database schema changes with Flyway migrations in a Kotlin Exposed project by versioning SQL scripts and executing them during application startup. This Skill includes patterns to integrate Flyway seamlessly alongside your Exposed database configuration.

Can I use Flyway migrations with Kotlin Exposed for schema management?▼

Yes, you can use Flyway migrations with Kotlin Exposed to handle schema evolution. This Skill provides patterns to configure Flyway within your Kotlin application, ensuring database schema changes are tracked and applied safely.

How do I manage database transactions safely using the Kotlin Exposed ORM?▼

Manage database transactions safely using the Kotlin Exposed ORM by wrapping your database operations within explicit transaction blocks. This Skill provides transaction management patterns to ensure atomicity and safety across your DSL queries and DAO operations.

Related Skills

Explore More Software Engineering Skills→
FindMalekFindMalek
9

prisma-database-setup

Configure Prisma for multiple database providers and set up the client.

Community
Intermediate
jinwoonghongjinwoonghong

moai-domain-backend

Design REST or GraphQL APIs with authentication and database integration.

Community
Advanced
devs6186devs6186

kotlin-exposed-patterns

Configure Kotlin data access with JetBrains Exposed DSL and DAO patterns.

Community
Advanced
ROYCE-8425ROYCE-8425
1

kotlin-exposed-patterns

Provide Kotlin patterns for JetBrains Exposed ORM database access.

Community
Advanced