bill-kotlin-code-review-persistence

Review Kotlin persistence for transaction boundaries, migrations, and data-consistency risks.

13|1|Updated Mar 16, 2026
One-click install
npx skills add https://github.com/Sermilion/skill-bill --skill bill-kotlin-code-review-persistence
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: bill-kotlin-code-review-persistence
Source: https://github.com/Sermilion/skill-bill/tree/main/platform-packs/kotlin/code-review/bill-kotlin-code-review-persistence
Command: npx skills add https://github.com/Sermilion/skill-bill --skill bill-kotlin-code-review-persistence

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Kotlin backend persistence often suffers from data integrity risks during transactions, migrations, and ORM mappings. This skill provides a structured approach to identifying and mitigating persistence-related issues that can compromise correctness and reliability.

Core Features & Use Cases

  • Transaction boundary validation: ensure atomicity and correct commit/rollback behavior across repositories and DAOs.
  • Migration safety checks: review schema changes for nullability, data loss, and rollout compatibility.
  • ORM/SQL mapping consistency: verify mappings between Kotlin entities and database schemas to prevent stale reads or writes.
  • Risk-focused reviews: detect lost updates, race conditions, non-idempotent writes, and tenant-filter gaps.
  • Use Case: when a Kotlin service touches persistence, run this skill to surface high-risk changes before merging.

Quick Start

Review the touched Kotlin persistence modules to identify major risk areas.

Frequently Asked Questions about bill-kotlin-code-review-persistence

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

FAQPage Schema
How do I review Kotlin persistence layers for data consistency risks?

To review Kotlin persistence, you examine repository and DAO modules to validate transaction boundaries, verify ORM mapping consistency, and check migrations for data loss risks before merging high-risk persistence changes.

What is transaction boundary validation in Kotlin backend persistence?

Transaction boundary validation ensures atomicity and correct commit/rollback behavior across repositories and DAOs. It detects data integrity risks by verifying transactional scopes prevent partial writes, race conditions, and non-idempotent operations.

How do I check database migration safety for nullability and data loss in Kotlin?

Checking migration safety involves reviewing schema changes for nullability constraints, data loss, and rollout compatibility. You audit migration scripts to ensure schema updates do not break ORM mappings or compromise persistence integrity.

Can I detect race conditions and lost updates in Kotlin ORM mappings?

You detect race conditions and lost updates by verifying ORM and SQL mapping consistency between Kotlin entities and database schemas. This surfaces non-idempotent writes and stale read risks to maintain data integrity.

When do I need to run a persistence review for Kotlin services?

You need a persistence review whenever a Kotlin service touches persistence layers. Run it to surface high-risk changes in repositories, DAOs, and migrations before merging, ensuring transactional boundaries and tenant filters are enforced.

Does this persistence review cover tenant filters and deterministic reporting?

Yes, the review enforces requirements for tenant filters and deterministic reporting. It audits Kotlin persistence modules to identify tenant-filter gaps and ensure deterministic behavior across transaction boundaries and ORM layers.