kotlin-exposed-patterns
JetBrains Exposed ORM patterns including DSL queries, DAO pattern, transactions
by affaan-mFree
Description
kotlin-exposed-patterns is an agent skill from the ECC collection by affaan-m, listed on skills.sh. It sets out patterns for database access in Kotlin with the JetBrains Exposed ORM. It covers its two query styles, the DSL, which expresses SQL-like queries, and the DAO pattern, which manages entity lifecycles. It also covers transactions, HikariCP connection pooling, Flyway versioned migrations that run at startup, JSON columns, complex queries and the repository pattern. The skill explains that all database work runs inside suspended transactions for coroutine safety and atomicity, and that the repository pattern keeps business logic apart from the data layer so tests can use an in-memory H2 database. It applies to setting up database access with Exposed, writing queries in DSL or DAO style, configuring the pool, creating migrations, and wrapping queries in repositories. A skill is a SKILL.md file of instructions that an AI agent loads when a task calls for it. It is free and open source, and the skills.sh listing shows all three security audits passing.…
Highlights
- DSL and DAO query styles
- Suspended transactions for coroutine safety
- HikariCP pooling and Flyway migrations
- Repository pattern with in-memory H2 tests
Ratings & Reviews
No ratings yet
Be the first to rate kotlin-exposed-patterns.
People also visit
prisma-cli
Complete reference for Prisma CLI commands, options, and workflows across setup
android-clean-architecture
Clean Architecture patterns for Android and Kotlin Multiplatform projects
compose-multiplatform-patterns
Compose Multiplatform and Jetpack Compose patterns for KMP projects
database-migrations
Safe, reversible database migration patterns: forward-only production changes
kotlin-exposed-patterns FAQ
What does the kotlin-exposed-patterns skill do?
It guides an agent in using the JetBrains Exposed ORM in Kotlin, including its query styles, transactions, pooling, migrations and repositories.
What is the difference between DSL and DAO here?
DSL writes SQL-like expressions directly, while DAO manages entities and their lifecycle.
How are tests run?
The repository pattern lets tests use an in-memory H2 database, according to the listing.
How do I install it?
Run: npx skills add https://github.com/affaan-m/ecc --skill kotlin-exposed-patterns
Is it free?
Yes. It is free and open source.
Are there security findings?
The skills.sh listing shows Gen Agent Trust Hub, Socket and Snyk all passing.
What are the best kotlin-exposed-patterns alternatives?
Popular alternatives to kotlin-exposed-patterns include prisma-patterns, prisma-cli and android-clean-architecture. See all kotlin-exposed-patterns alternatives