mcpField
P
projection-patterns

projection-patterns

github.com/sickn33Development48.9k83 installsUpdated today
Repository

About projection-patterns

projection-patterns is a skill for designing projections and read models in event-sourced systems. It guides practitioners through applying patterns, checking results, and finding detailed examples in its implementation playbook.

Key features

  1. 01CQRS read model guidance
  2. 02Event-based materialized views
  3. 03Query performance optimization
  4. 04Real-time dashboard patterns
  5. 05Search index construction
  6. 06Cross-stream data aggregation

Use cases

  1. 01Building a CQRS read model
  2. 02Creating views from event streams
  3. 03Improving query performance
  4. 04Aggregating data across streams

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/sickn33/agentic-awesome-skills --skill projection-patterns

After installing, type/projection-patternsin Claude Code to confirm it loaded.

Bundled filesresources/implementation-playbook.md

Details

From the project README

Projection Patterns

Comprehensive guide to building projections and read models for event-sourced systems.

Use this skill when

  • Building CQRS read models
  • Creating materialized views from events
  • Optimizing query performance
  • Implementing real-time dashboards
  • Building search indexes from events
  • Aggregating data across streams

Do not use this skill when

  • The task is unrelated to projection patterns
  • You need a different domain or tool outside this scope

Instructions

  • Clarify goals, constraints, and required inputs.
  • Apply relevant best practices and validate outcomes.
  • Provide actionable steps and verification.
  • If detailed examples are required, open resources/implementation-playbook.md.

Resources

  • resources/implementation-playbook.md for detailed patterns and examples.

Limitations

  • Use this skill only when the task clearly matches the scope described above.
  • Do not treat the output as a substitute for environment-specific validation, testing, or expert review.
  • Stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.

Example

For OrderItemAdded at position 42, apply the increment and persist checkpoint 42 in one transaction. Replay position 42 and verify no second increment; crash before commit and verify both the row update and checkpoint roll back together.

Comments

Markdown supported