Kotlin Exposed ORM Patterns
Database access with JetBrains Exposed: DSL and DAO queries, coroutine-safe transactions, HikariCP pooling, Flyway migrations, and the repository pattern.
- What
- Database access with JetBrains Exposed: DSL and DAO queries, coroutine-safe transactions, HikariCP pooling, Flyway migrations, and the repository pattern.
- Cost
- Free
- Needs
- Pinned version: install the code at commit 4eb71d92a39cab44ad40ac9d8a6a5ccb4029d6c2 exactly (Skill Harbor tested this version). Do not substitute a newer version. If this commit is unreachable, stop and tell me.
- Level
- Beginner — Pinned version: install the code at commit…
- Install
- Copy the installer prompt below into your Muse — your agent does the rest.
Curated by Skill Harbor: comprehensive patterns for database access with the JetBrains Exposed ORM. Exposed offers two query styles: DSL for direct SQL-like expressions and DAO for entity lifecycle management. HikariCP manages a pool of reusable database connections configured via HikariConfig; Flyway runs versioned SQL migration scripts at startup to keep the schema in sync; all database operations run inside newSuspendedTransaction blocks for coroutine safety and atomicity. The repository pattern wraps Exposed queries behind an interface so business logic stays decoupled from the data layer and tests can run against an in-memory H2 database. Covers JSON columns, complex queries, setting up database access from scratch, and writing SQL with the DSL or the DAO. By @affaan-m, listed here with credit to its creator. From the affaan-m/ECC repository (MIT). Honest caveats: assumes a Kotlin plus Exposed stack; pooling and migration tuning depend on your database and load. Skill Harbor never reviews the code, review it yourself before use.
Version:
Quick answer
Kotlin Exposed ORM Patterns is a free Muse skill with comprehensive patterns for database access with the JetBrains Exposed ORM. Exposed offers two query styles: DSL for SQL-like expressions and DAO for entity lifecycle management. HikariCP manages a pool of reusable connections via HikariConfig, Flyway runs versioned SQL migrations, and the repository pattern organizes access.
Install
Copy the install package below, then paste it into Muse🧪 Install ran in our test sandbox · Nov 11, 2026📌 Pinned version: commit 4eb71d9Pinned version: install the code at commit 4eb71d92a39cab44ad40ac9d8a6a5ccb4029d6c2 exactly (Skill Harbor tested this version). Do not substitute a newer version. If this commit is unreachable, stop and tell me. Use "Kotlin Exposed ORM Patterns" with your Muse. 1. Open the skill: https://raw.githubusercontent.com/affaan-m/ECC/4eb71d92a39cab44ad40ac9d8a6a5ccb4029d6c2/skills/kotlin-exposed-patterns/SKILL.md and copy the full SKILL.md text. 2. Paste it into a chat with Muse and add: "Set up Exposed database access with HikariCP and Flyway for [project]" or "Write a repository with Exposed DSL for [entity]." 3. Keep every database call inside newSuspendedTransaction and keep business logic behind the repository interface. Tip: start with the DSL for queries you can read as SQL, then move to the DAO when entity lifecycles get complicated; mixing both is normal. Safety: a skill is plain-text instructions; it runs nothing by itself. Keep database credentials out of any chat.
Saved to your recent installs. Find it anytime on /connect.
🔒 Security, provenance and what this touches
The install prompt below already includes the vetting steps: your agent follows the community checklist before installing anything with executable code. Want more?
Verification certificate
Dated facts about what was checked for this listing, and how. This is not a safety certification.
- Pinned version
- 4eb71d9 · 2026-10-13
- Sandbox install test
- Install ran in our test sandbox · Nov 11, 2026
- Creator identity
- Not verified
- Fingerprint watch
- Last checked · Nov 21, 2026 : no change detected in the files linked by this install prompt
- Install prompt analysis
- 2026-10-13 : No commands, network calls, packages, file writes or API keys detected.
Skill Harbor never reviews the code of a listed skill. These are dated facts about the install prompt and our install test, not a safety certification. Review a skill yourself before you install it. How we verify
Questions
How do I install a skill?
Every product page includes a copy-paste install prompt. Paste it into your Muse and it sets the skill up for you — no manual configuration.
Where does my money go?
Straight to the seller. Skill Harbor never processes payments: checkout happens on the seller’s own page, usually Stripe.
What does the ✓ next to a creator’s name mean?
It means we confirmed the identity of the person behind the listing. It says nothing about the code itself — always check a skill before installing it.