How does this help with message delivery guarantees?

The skill provides patterns for 'at-least-once' delivery, including retry logic, dead-letter handling, and consumer-side idempotency checks to ensure no data is lost.

What is the Transactional Outbox pattern?

It's a design pattern that ensures a message is sent to a broker (like RabbitMQ or Kafka) if and only if the local database transaction is successful, solving the 'dual-write' problem.

Is there a recommended database schema?

The skill includes a production-ready SQL schema for an outbox table, featuring UUIDs, JSONB payloads, and optimized indexes for polling unprocessed messages.

Can it identify bugs in my current messaging logic?

Yes, it provides specific grep and glob detection patterns to find critical violations, such as publishing an event inside a database transaction before it has committed.

Does this skill support PHP 8.4 features?

Yes, it includes specific code patterns utilizing modern PHP 8.4 features such as readonly classes, constructor property promotion, and strict typing.

Transactional Outbox Pattern Knowledge

Name: Transactional Outbox Pattern Knowledge
Author: dykyi-roman

bydykyi-roman

•

Database Management

Implements and audits the Transactional Outbox pattern in PHP applications to ensure reliable event delivery and data consistency.

This skill provides a comprehensive knowledge base for implementing the Transactional Outbox pattern within PHP 8.4 environments. It equips developers with standardized entity structures, repository interfaces, and publishing services to solve the 'dual write' problem. By offering automated detection patterns and checklists, the skill helps identify architectural violations like publishing before commits or missing idempotency keys, ensuring high-reliability messaging in distributed systems and microservices.

Key Features

01PHP 8.4 boilerplate for OutboxMessage entities and repository interfaces

02Automated detection patterns to find architectural violations and anti-patterns

0345 GitHub stars

04Standardized audit report templates for evaluating existing implementations

05Reference schemas for SQL-based outbox message storage with indexing

06Comprehensive checklists for Outbox tables, message relays, and consumers

Use Cases

01Designing idempotent message consumers to prevent duplicate processing

02Auditing existing codebases for dual-write anti-patterns and transaction leaks

03Implementing reliable event-driven communication between PHP microservices

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add dykyi-roman/awesome-claude-code outbox-pattern-knowledge

For use in Claude.ai and ChatGPT

Download Skill