How does it handle write conflicts in event streams?

The skill implements optimistic concurrency control using versioning and 'expected version' checks to ensure data integrity during concurrent writes.

What database technologies does this skill support?

It provides implementation patterns and schemas for PostgreSQL, EventStoreDB, Kafka, DynamoDB, and Marten.

Can this skill help with real-time data processing?

Yes, it includes logic for event subscriptions and global position tracking to facilitate real-time notifications and downstream projections.

Does it include code for reading and writing events?

Yes, it provides production-ready templates in Python and SQL for appending events, reading streams, and managing subscription checkpoints.

Event Store Design & Implementation

Name: Event Store Design & Implementation
Author: sla-te

bysla-te

0•

データベース管理

Designs and implements robust event stores for event-sourced systems using industry-standard persistence patterns.

The Event Store Design skill provides comprehensive architectural guidance and implementation templates for building event-sourced infrastructure. It helps developers choose the right technology stack—ranging from PostgreSQL and EventStoreDB to DynamoDB—while ensuring critical requirements like append-only immutability, global ordering, and optimistic concurrency control are met. By leveraging this skill, teams can implement scalable event streams, manage real-time subscriptions with checkpointing, and optimize performance through snapshotting patterns, making it an essential resource for modern backend services and microservices architecture.

主な機能

01Global and per-stream ordering strategies

02Optimistic concurrency control and stream versioning patterns

03Multi-database implementation templates for PostgreSQL, DynamoDB, and EventStoreDB

04Snapshotting patterns to optimize aggregate state recovery

05Real-time event subscription and checkpointing logic

060 GitHub stars

ユースケース

01Building a custom event store on top of an existing relational database stack

02Architecting high-throughput event streaming systems with global position tracking

03Implementing reliable audit logs and historical state tracking for complex domains

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add sla-te/copilot-converter event-store-design

For use in Claude.ai and ChatGPT

Download Skill