idempotency-handling

Idempotent API operations with idempotency keys, Redis caching, DB constraints. Use for payment systems, webhook retries, safe retries, or encountering duplicate processing, race conditions, key expiry errors.

1.35x

Quality

96%

Does it follow best practices?

Impact

100%

1.35x

Average score across 3 eval scenarios

Securityby

Passed

No known issues

Evaluation results

100%

27%

Payment API Idempotency Middleware

Redis idempotency middleware

Criteria

Without context

With context

Redis package

100%

Key prefix format

33%

100%

TTL is 86400

25%

100%

Caches status + body

100%

Replays status + body

100%

res.json interception

100%

Missing key passthrough

100%

Header name

100%

Middleware applied to mutations

100%

30%

Concurrent Order Processing with Database Idempotency

Database-backed idempotency with concurrency

Criteria

Without context

With context

Table schema columns

50%

100%

expires_at index

100%

SHA-256 request hash

100%

Atomic INSERT ON CONFLICT

75%

100%

rowCount check

90%

100%

Completes with response

100%

Marks failed on error

62%

100%

Hash mismatch error

60%

100%

Processing state error

70%

100%

Returns cached on completed

100%

Failed state error

50%

100%

21%

Idempotency Key Table Maintenance

Idempotency key cleanup strategy

Criteria

Without context

With context

Batched DELETE with LIMIT

100%

Deletes by expires_at

100%

Hourly schedule

100%

Logs deleted row count

100%

Error handling in job

100%

Low-traffic timing guidance

100%

Table size alerting

100%

Cleanup job failure monitoring

100%

Partitioning consideration

100%

Repository: secondsky/claude-skills
Commit: 90d6bd7

Evaluated: 29 days ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

Payment API Idempotency Middleware Concurrent Order Processing with Database Idempotency Idempotency Key Table Maintenance

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.