Does this skill work with Spring Boot applications?

Yes, it is specifically designed to review @Transactional boundaries in Spring Boot, identifying issues like missing rollbackFor declarations and N+1 queries inside transactions.

When should I use the Transaction Boundary Reviewer?

Use this skill when you encounter data inconsistencies after failures, experience database lock timeouts, or need to ensure that multiple writes succeed or fail as a single unit.

Can it help reduce database deadlocks?

Yes, by identifying 'wide transactions' that hold locks during long-running tasks like external API calls, it provides strategies to narrow the transaction scope and reduce contention.

How does it handle distributed transactions across microservices?

It identifies where distributed transactions might fail and recommends modern patterns like the Transactional Outbox or Saga (orchestration/choreography) to maintain eventual consistency.

Does it optimize raw SQL query performance?

No, this skill focuses on the logic and boundaries of transactions. For optimizing slow SQL queries themselves, you should use a dedicated query tuning skill like sql-pro.

Transaction Boundary Reviewer

Name: Transaction Boundary Reviewer
Author: newkayak12

bynewkayak12

0•

データベース管理

Audits and optimizes database transaction scopes to ensure data integrity and prevent performance bottlenecks in complex applications.

The Transaction Boundary Reviewer is a specialized tool designed to solve data consistency issues and performance degradation caused by improper transaction management. It analyzes your code to identify ACID property violations, detects dangerous anti-patterns like holding locks during external I/O, and recommends the ideal isolation levels for your specific concurrency needs. Whether you are debugging partial failure scenarios in a monolithic Spring Boot app or designing resilient distributed patterns like Sagas and Outbox for microservices, this skill provides the architectural guidance and code corrections necessary to maintain a reliable data layer.

主な機能

01Provides implementation templates for Outbox and Saga distributed patterns

02Detects common anti-patterns like overly wide transactions and missing rollbacks

03Recommends optimal isolation levels based on specific concurrency requirements

040 GitHub stars

05Identifies ACID property risks including atomicity gaps and isolation anomalies

06Generates optimized code to narrow transaction scopes and reduce lock contention

ユースケース

01Architecting reliable cross-service data updates in microservices environments

02Fixing data inconsistencies that occur after partial system failures

03Reducing database lock contention and timeout errors under high concurrent load

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add newkayak12/claude-skills transaction-boundary-reviewer

For use in Claude.ai and ChatGPT

主な機能

01Provides implementation templates for Outbox and Saga distributed patterns

02Detects common anti-patterns like overly wide transactions and missing rollbacks

03Recommends optimal isolation levels based on specific concurrency requirements

040 GitHub stars

05Identifies ACID property risks including atomicity gaps and isolation anomalies

06Generates optimized code to narrow transaction scopes and reduce lock contention

ユースケース

01Architecting reliable cross-service data updates in microservices environments

02Fixing data inconsistencies that occur after partial system failures

03Reducing database lock contention and timeout errors under high concurrent load