This is a solid foundation for building event stores in event-sourced systems. It walks you through the core architecture decisions, compares technologies like EventStoreDB, PostgreSQL, and Kafka with honest tradeoffs, and provides working templates for a Postgres-backed implementation with proper schemas and Python code. The implementation covers the essentials: append-only writes, optimistic concurrency control, stream versioning, and global positioning. Use this when you're setting up event sourcing infrastructure from scratch or evaluating whether to use a dedicated event store versus rolling your own on top of Postgres. The templates are production-aware with proper indexing and snapshot support, though you'll need to implement the subscription and projection logic yourself.
npx skills add https://github.com/sickn33/antigravity-awesome-skills --skill event-store-design