caobingsheng/projection-patterns
project/projection-patterns/SKILL.md
Build read models and projections from event streams. Use when implementing CQRS read sides, building materialized views, or optimizing query performance in event-sourced systems.
development
Updated Apr 20, 2026
$ install --global
skillsauthnpx skillsauth add caobingsheng/skills projection-patternsInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 18, 2026, 3:49 AM49.5s2 files scanned
SKILL.md
- name:
- projection-patterns
- description:
- Build read models and projections from event streams. Use when implementing CQRS read sides, building materialized views, or optimizing query performance in event-sourced systems.
- risk:
- safe
- source:
- community
- date_added:
- 2026-02-27
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.mdfor detailed patterns and examples.
Related Skills
caobingsheng/tdd-workflows-tdd-refactor
development
VerifiedTrustedCommunity
Use when working with tdd workflows tdd refactor
SKILL.mdUpdated Apr 21, 2026
caobingsheng/tdd-workflows-tdd-red
testing
VerifiedTrustedCommunity
Generate failing tests for the TDD red phase to define expected behavior and edge cases.
SKILL.mdUpdated Apr 21, 2026
caobingsheng/tdd-workflows-tdd-green
development
VerifiedTrustedCommunity
Implement the minimal code needed to make failing tests pass in the TDD green phase.
SKILL.mdUpdated Apr 21, 2026
caobingsheng/tdd-workflows-tdd-cycle
tools
VerifiedTrustedCommunity
Use when working with tdd workflows tdd cycle
SKILL.mdUpdated Apr 21, 2026