How does it handle stale data after a write operation?

It implements a 'sticky connection' pattern where, after a write operation occurs, all subsequent reads within the same request are routed to the primary database to avoid replica lag issues.

Is the generated code compatible with modern PHP standards?

Absolutely. The skill generates PHP 8.4 compliant code utilizing readonly classes, enums, and strict typing, adhering to PSR standards and Clean Architecture principles.

Does this skill support transaction safety?

Yes, the generated proxy ensures that all queries executed within a transaction are automatically routed to the primary database to maintain data integrity.

Can it manage multiple database replicas?

Yes, the ConnectionConfig supports multiple replica DSNs, and the generated health checker monitors their availability to route traffic away from unhealthy nodes.

PHP Database Read-Write Proxy Generator

Name: PHP Database Read-Write Proxy Generator
Author: dykyi-roman

bydykyi-roman

•

Database Management

Generates robust database connection proxies for PHP 8.4 to implement seamless read/write splitting and replica routing.

This skill automates the creation of high-performance database infrastructure components that optimize application scaling by distributing read loads across multiple replicas while maintaining write consistency. It generates a transaction-aware proxy that intelligently routes SQL queries based on operation type, incorporating enterprise-grade patterns such as sticky connections after writes to prevent stale data and automated health checks to ensure traffic only reaches healthy replicas. Designed for modern PHP 8.4 environments, it follows DDD and Clean Architecture principles to keep your database routing logic decoupled from business code.

Key Features

01Multi-replica support with automated health monitoring and failover

02Transaction-aware routing to ensure data consistency

0347 GitHub stars

04Automated SQL routing for primary/replica architectures

05PHP 8.4 type-safe implementation with unit test generation

06Sticky connection logic to prevent read-after-write stale data

Use Cases

01Reducing primary database load in CQRS or DDD-based architectures

02Scaling high-traffic PHP applications by offloading reads to database replicas

03Implementing resilient database infrastructure with automated health checks

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add dykyi-roman/awesome-claude-code create-read-write-proxy

For use in Claude.ai and ChatGPT

Download Skill