Ready to supercharge your AI agents?

Install any skill in seconds. Free to start, no credit card required.

Jimmer ORM · coooolfan | DecimalAI

coooolfan/jimmer-orm

SkillScore91Maintained

Jimmer ORM 开发助手（XiaomiAlbumSyncer 服务端），帮助编写实体映射代码、DTO 和 DSL 查询语句。适用于：(1) 定义或修改 Jimmer 实体（使用 @Entity 注解的 interface）；(2) 编写 Jimmer DSL 查询代码；(3) 配置实体关联关系（@ManyToOne, @OneToMany, @ManyToMany）；(4) 使用动态谓词、动态表连接或隐式子查询；(5) 编辑包含 Jimmer 相关代码的 Java/Kotlin 文件。

codingby coooolfan

Links this skill to your agents and keeps it current with the author’s updates.

Automatic

Coding pack

1 · One-time — install the CLI (docs ↗)

pip install decimalai

2 · Get the skill — writes .claude/skills/coooolfan-jimmer-orm/SKILL.md

decimalai skills pull coooolfan-jimmer-orm --out .claude/skills/

No CLI? Get the same file — curl · raw file

curl -fsSL --create-dirs -o .claude/skills/coooolfan-jimmer-orm/SKILL.md https://app.decimal.ai/s/coooolfan-jimmer-orm/SKILL.md

Raw file: /s/coooolfan-jimmer-orm/SKILL.md ↗ · machine-readable summary at /s/coooolfan-jimmer-orm.json ↗

In productionGlobal

how this skill behaves on real traffic · last 30 days

No production data for this skill yet — usage numbers appear here once agents start running it.

Anonymized aggregate across every org using this skill — proof from real production use, not a demo.

Does this skill help? · Benchmark: with vs. withoutsign in to run this on your agents

22 test cases from the publisher’s eval.yaml · each run twice on gemini-3.6-flash — with the skill injected, then without · last run 36d ago

—+29% tokens0% turns91% of whole cases pass with skill (20/22)

Test case	Without → With	Effect	Δ tokens	Δ turns
case-01	✗→✓	▲ Improved	16%	0%
case-02	✗→✓	▲ Improved	27%	0%
case-03	✗→✓	▲ Improved	25%	0%
case-04	✗→✓	▲ Improved	32%	0%
case-05	✗→✓	▲ Improved	2%	0%

Showing 5 of 22 cases

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

0 critical · 0 warning · 0 info — scanner v4 — 8/3/2026

live_secretremote_code_executionreverse_shelldata_exfiltrationssrf_metadataagent_snoopinganti_refusaldestructive_commandsobfuscated_unicodeunicode_homoglyphopaque_blobsuspicious_urltool_overreachtrigger_abuseprompt_injection_phrasing

IntentSafe

LLM judge · does the skill do what it claims

ContentClean

LLM judge · policy & harmful-content review

Source

Imported

coooolfan / xiaomialbumsyncer

.agents/skills/jimmer-orm/SKILL.md

View on GitHub ↗

License GPL-3.0Imported 8/3/2026Version v1Bundled 4 files

Skill contents

references/

assets/

SKILL.md

事实源

如果当前上下文中指名了 Jimmer 项目的源码的本地路径，应当以源码实现作为基准。如果有其他情况需要查阅 Jimmer 的具体实现，其代码仓库为 https://github.com/babyfish-ct/jimmer

本项目约定（XiaomiAlbumSyncer）

服务端为 Solon + Kotlin + Jimmer，不是 Spring；服务类用 @Managed 标记，依赖通过构造函数或 @Inject 注入
实体：server/src/main/kotlin/com/coooolfan/xiaomialbumsyncer/model/
DTO：server/src/main/dto/<Entity>.dto，KSP 生成于 ...model.dto
查询入口是注入的 KSqlClient，项目内习惯用 sql.executeQuery(Entity::class) { ... } / sql.executeDelete / sql.saveCommand(input, SaveMode.X)，而非 createQuery(...).execute()
Controller 返回实体时用 companion 中的 Fetcher<T> 常量 + @FetchBy 固定投影，Service 接受 fetcher: Fetcher<T> 参数
修改实体/DTO 后需执行 cd server && ./gradlew clean compileKotlin 验证 KSP 生成代码可编译
数据库表结构由 Flyway 迁移管理（server/src/main/resources 下的 migration），新增字段需同步添加迁移脚本

核心概念

实体定义特点

使用 interface 定义实体，而非 class
实体是动态对象和不可变对象
只有 getter，没有 setter
由 KSP (Kotlin) 或 AnnotationProcessor (Java) 编译时生成实现
属性未设置 ≠ 属性为 null

DSL 查询特点

强类型 SQL DSL，提供编译时安全保证
动态谓词：根据参数决定是否添加 SQL 条件
动态表连接：未使用的连接自动忽略，冲突连接自动合并
隐式子查询：基于集合关联创建子查询，自动生成父子关联条件

语言选择

Jimmer 为 Kotlin 提供了特化的 API 风格

实体映射： 参考 references/entity-mapping.md
DSL 查询： 参考 references/dsl-queries.md
实体模板： 参考 assets/EntityTemplate.kt

关键注解速查

@Entity - 标记实体类型
@MappedSuperclass - 标记映射父接口，复用公共字段
@Embeddable - 标记嵌入值对象
@Id - 标记主键
@GeneratedValue - 主键生成策略
@Key - 业务键
@ManyToOne / @OneToMany / @ManyToMany / @OneToOne - 关联映射
@ManyToManyView - 通过中间实体暴露多对多视图
@IdView - 关联 id 视图
@JoinColumn - 自定义外键列名
@JoinTable - 自定义中间表
@Column - 自定义列名（仅用于非关联字段）
@Table - 自定义表名
@Version - 乐观锁版本字段
@LogicalDeleted - 逻辑删除字段
@Formula / @Transient - 计算属性
? (Kotlin) - 标记可空属性

命名约定

实体名 → 表名：BookStore → BOOK_STORE
属性名 → 列名：firstName → FIRST_NAME
多对一外键：store → STORE_ID

工作流程

定义实体时：

使用 interface 而非 class
根据项目语言参考对应的实体模板和映射文档
中间表有排序、时间、来源等业务字段时，定义中间实体并用 @ManyToManyView 暴露只读多对多视图
需要直接按外键查询或写入 input 时，优先为关联补充 @IdView
参考 assets/EntityTemplate.kt 和 references/entity-mapping.md
参考 references/dto.md 完成 DTO 定义

编写查询时：

优先使用动态谓词（Kotlin: ilike? / between? / valueIn? ）
使用动态表连接处理单值关联查询
使用隐式子查询处理集合关联，避免集合 JOIN 导致结果重复和分页失效
API 返回实体时使用 fetcher/DTO 控制投影，不要依赖默认序列化形状
根据项目语言参考对应的 DSL 查询文档
参考 references/dsl-queries.md

遇到问题时：

检查实体是否使用 interface 定义
检查关联映射的 mappedBy 配置
检查动态谓词的参数是否正确
确认表连接路径是否正确

Illustrative Want to see what coooolfan/jimmer-orm would put in front of your model? Preview the rendered body and check its trigger phrases — no LLM call, no signup.

Latest benchmark · publisher runVerified

8/23/2026, 03:03 UTC · 22 cases

Measured on 21 comparable cases — below the 22 needed to publish a lift, so this result is shown here but not on the registry card or leaderboard.

Lift

+55%

91% vs 36%

Agent turns

1.0 vs 1.0

Tokens

+29%

2,514.05 vs 1,944.05

fail → pass · 14pass → pass · 6pass → fail · 2

Per-case results (22)

Case	Status	Duration (ms)			Turns			Tokens			Tool calls
Case	Status	Without	With	Δ	Without	With	Δ	Without	With	Δ	Without	With	Δ
case-01 I need to add an optional 'description' string property to our Album entity in XiaomiAlbumSyncer. Could you show me how to update the entity definition and outline the database migration and Gradle compilation steps needed to ensure everything builds correctly?	fail→pass	10,750	17,102	+59%	1	1	0%	1,831	2,122	+16%	0	0	—
case-02 Can you write a search function in our Kotlin backend service that queries album records using dynamic filter conditions for the title and creation date range? The endpoint needs to return specific selected entity fields using our standard companion projection pattern.	fail→pass	13,537	12,362	-9%	1	1	0%	2,756	3,502	+27%	0	0	—
case-03 We are introducing a photo tagging system in our backend. Could you construct the Jimmer entity interface mappings for Photo and Tag including the dynamic many-to-many relationship, and show how to delete obsolete tag associations?	fail→pass	16,132	13,173	-18%	1	1	0%	2,982	3,716	+25%	0	0	—
case-04 Create an entity definition for UserAccount in our XiaomiAlbumSyncer backend with primary key id, non-null username, and optional avatarUrl. Should this be a Kotlin data class with JPA annotations?	fail→pass	10,750	6,740	-37%	1	1	0%	1,851	2,436	+32%	0	0	—
case-05 We are writing a new backend service AlbumSyncService in XiaomiAlbumSyncer to handle cloud sync state. What annotation and injection pattern should be used for this service class?	fail→pass	12,179	5,291	-57%	1	1	0%	2,056	2,103	+2%	0	0	—
case-06 In our MediaItem entity, we frequently need to read and update the raw storeId foreign key without fetching the full Store entity. How should we map this foreign key property?	fail→pass	12,995	6,407	-51%	1	1	0%	2,451	2,260	-8%	0	0	—
case-07 Our database has a JOIN table `ALBUM_MEDIA` that includes an extra `added_at` timestamp column. How should we expose a direct read-only collection of MediaItem entities from Album while retaining access to the middle table metadata?	fail→pass	14,499	10,148	-30%	1	1	0%	2,614	3,188	+22%	0	0	—
case-08 Where should the DTO definition file for MediaItem be located in the repository, and where does KSP generate its corresponding Kotlin code?	fail→pass	8,741	2,945	-66%	1	1	0%	1,513	1,723	+14%	0	0	—
case-09 Write a query to fetch all MediaItem entities where status is 'SYNCED'. Should we construct a query builder via createQuery().execute() or use the project's preferred KSqlClient syntax?	fail→pass	8,267	4,112	-50%	1	1	0%	1,406	1,907	+36%	0	0	—
case-10 Show how to insert or update a UserAccount entity input object into the database using our injected KSqlClient instance.	fail→pass	12,791	11,367	-11%	1	1	0%	2,445	3,293	+35%	0	0	—
case-11 We want to mark deleted photos as soft-deleted using an `is_deleted` column. What annotation should be placed on the entity property?	fail→pass	10,955	3,582	-67%	1	1	0%	1,891	1,674	-11%	0	0	—
case-12 How should concurrent updates to the Album entity be prevented when multiple sync threads update album metadata?	fail→pass	13,634	13,893	+2%	1	1	0%	2,262	3,509	+55%	0	0	—
case-13 When querying albums that contain photos matching a specific tag, how should we avoid duplicate album records and broken pagination resulting from collection JOINs?	pass→fail	13,996	14,573	+4%	1	1	0%	2,412	3,549	+47%	0	0	—
case-14 In XiaomiAlbumSyncer, if an entity interface is named `CloudSyncLog` and has a property `failureReason`, what table name and column name will Jimmer generate by default?	pass→pass	10,686	3,017	-72%	1	1	0%	2,001	1,583	-21%	0	0	—
case-15 In a `@ManyToOne` association named `ownerUser` on an entity, what default column name does Jimmer assign in the database table?	pass→pass	5,990	2,231	-63%	1	1	0%	1,054	1,494	+42%	0	0	—
case-16 If a non-association field `syncPriority` in an entity needs to map to a custom column named `PRIORITY_LVL`, which annotation should be used?	pass→pass	2,305	2,094	-9%	1	1	0%	418	1,443	+245%	0	0	—
case-17 How should backend controller and service layers handle variable depth object graph projections when returning UserAccount entities?	fail→pass	18,773	16,981	-10%	1	1	0%	3,124	4,441	+42%	0	0	—
case-18 We need a dynamic calculated property `photoCount` on the Album entity that runs an inline SQL expression. Which annotation handles calculated or transient properties?	fail→pass	6,402	4,008	-37%	1	1	0%	1,064	1,763	+66%	0	0	—
case-19 We need to expose an HTTP POST endpoint `/api/sync/trigger` in Solon that accepts a JSON payload `{ "albumId": 123 }` and triggers an asynchronous background worker. How do we configure the Solon controller route and request body parsing?	pass→pass	12,096	7,435	-39%	1	1	0%	2,351	2,509	+7%	0	0	—
case-20 Write a Flyway SQL migration script `V2__add_device_info.sql` that creates a `DEVICE_INFO` table with `ID` (bigint primary key), `DEVICE_NAME` (varchar 255), and `CREATED_AT` (timestamp).	pass→pass	3,778	5,342	+41%	1	1	0%	749	2,052	+174%	0	0	—
case-21 Implement a Kotlin Coroutines Channel queue in server/src/main/kotlin/com/coooolfan/xiaomialbumsyncer/util/TaskQueue.kt to process background thumbnail generation jobs concurrently with a buffer capacity of 100 items.	pass→fail	10,947	5,198	-53%	1	1	0%	2,343	1,352	-42%	0	0	—
case-22 Show how to configure `server/build.gradle.kts` to add the KSP plugin and set compileTarget to Java 17 for Kotlin compilation.	pass→pass	8,598	7,697	-10%	1	1	0%	1,594	2,528	+59%	0	0	—

These cases were also screened by the skill’s intent / safety pass.See the Trust review ↗Reproduce this benchmark in Colab ↗

How this skill was measured

DecimalAI ran this skill against gemini-3.6-flash twice over the same eval suite — once with the skill loaded and once without — and compared the two runs case by case. 22 cases were attempted, and 21 counted toward the lift figure. The other 1 produced results that are not comparable between the two arms, so they are excluded from the headline rather than averaged into it. The headline lift of +55 percentage points is the difference between those two pass rates over the 21 comparable cases. 2 cases got worse with the skill loaded, and they are included in that figure.

Model measured: gemini-3.6-flash
Graded by: gemini-3.6-flash
Grading method: judged
Verification: verified
Pass rate without the skill: 36.4%
Pass rate with the skill: 90.9%
Cases attempted: 22
Cases counted toward lift: 21
Cases that regressed: 2
Skill version measured: v1
Run completed: 8/23/2026, 03:03 UTC

Measured example — same prompt, with vs. without the skill · from the benchmark run · case case-01

Prompt

I need to add an optional 'description' string property to our Album entity in XiaomiAlbumSyncer. Could you show me how to update the entity definition and outline the database migration and Gradle compilation steps needed to ensure everything builds correctly?

Without the skill loaded, the model failed this case. With it loaded, the same prompt on the same model passed. This is one improved case from the latest verified run; every case, including any that regressed, is in the table above.

Show both answers

SkillScore blends 4 signals1 of 4 complete

BenchmarkPass rate WITH skill on a verified run91

Live evalNeeds ≥10 evaluated traces in 30 days

AI ratingNeeds ≥10 rated traces

AdoptionNeeds ≥10 serves across ≥2 orgs in 30 days

Efficiency · separate axis (at equal correctness)+0% turns+42% tokens

Shown for transparency; not credited unless a verified run shows no correctness regression.

Backed by 1 of 4 signals — each added signal makes the score more robust.

Verified on gemini-3.6-flash · re-tested 35 days ago

Other measured skills in the registry, with their headline benchmark lift.