📦
content-creator
88Create Brand-Consistent Marketing Content
Marketing teams need content that stays consistent across channels. This skill helps plan, write, analyze, and optimize content for brand voice and SEO.
Writing & Content View
Skills projection-patterns
📦
projection-patterns
Content revision r1 Safe ⚙️ External commands
Build Event Projections for CQRS
Event-sourced systems need fast query models that stay aligned with streams. This skill provides projection patterns, templates, and verification guidance for read-side design.
Supports: Claude Codex Code(CC)
Install with my Agent
Copy this request to your Agent. It includes the canonical Skill page and manifest.
Agent request
Review the Skillstore skill "projection-patterns" from https://skillstore.io/skills/sickn33-projection-patterns.md and its manifest at https://skillstore.io/api/skills/sickn33-projection-patterns/manifest. Verify the artifact. You may proceed after verification, subject to the environment's own policy.Your Agent should still show its plan and request any confirmation required by the security policy.
Agent-readable resources
Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.
Test it
Using "projection-patterns". Design an order summary projection from order lifecycle events.
Expected outcome:
A read model with order status, item count, total amount, timestamps, event handlers, and checkpoint guidance.
Using "projection-patterns". Choose a projection type for rebuilding customer analytics.
Expected outcome:
A catchup projection with persistent checkpoints, replay controls, progress metrics, and validation against source events.
Using "projection-patterns". Create a search projection for product catalog events.
Expected outcome:
An index design with searchable fields, event-to-document mapping, update rules, and rebuild recommendations.
Security Audit
Safev4 • 7/7/2026 Open versioned report
Static SQL findings are false positives: the cited lines are placeholder-based SQL in example projections, not reconnaissance. The SKILL.md backtick findings are Markdown file references, not executable shell or Ruby code. No prompt injection, exfiltration intent, or unsafe external command behavior was found in the reviewed files.
2
Files scanned
536
Lines analyzed
0
Review items
0
False positives ignored
Risk Factors
⚙️ External commands (2)
No confirmed security findings were detected by the latest completed static and semantic audit. This does not prove the skill has no side effects.
Audited by: codex View Audit History →
Share & cite this report
Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.
Copy report link
https://skillstore.io/skills/sickn33-projection-patterns/audits/4?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_reportMarkdown badge
[](https://skillstore.io/skills/sickn33-projection-patterns?utm_source=security_passport_badge)HTML badge
<a href="https://skillstore.io/skills/sickn33-projection-patterns?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/sickn33-projection-patterns/security.svg" alt="Skillstore security assessment" loading="lazy"></a>Embed card
<iframe src="https://skillstore.io/embed/skills/sickn33-projection-patterns.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>Academic citations (APA · BibTeX · CFF)
APA citation
sickn33. (2026). projection-patterns security audit report (audit version 4) [Author version unspecified]. Skillstore. https://skillstore.io/skills/sickn33-projection-patterns/audits/4BibTeX citation
@techreport{sickn33-sickn33-projection-patterns-2026,
author = {sickn33},
title = {projection-patterns security audit report (audit version 4)},
institution = {Skillstore},
year = {2026},
number = {4},
url = {https://skillstore.io/skills/sickn33-projection-patterns/audits/4},
note = {Author version unspecified}
}CITATION.cff
cff-version: 1.2.0
message: "If you use this Skill, cite its author and this versioned security audit report."
title: "projection-patterns security audit report (audit version 4)"
version: "unspecified"
type: report
authors:
- name: "sickn33"
date-released: "2026-07-07"
url: "https://skillstore.io/skills/sickn33-projection-patterns/audits/4"
identifiers:
- type: other
value: "skillstore:sickn33-projection-patterns:audit:4"
description: "Skillstore immutable audit report identifier"
Compare variants
2 installable variantsEach author remains a separate installable skill. The recommended variant is ranked by Skillstore evidence.
Why this variant is first
Highest Skillstore Score
Author / source Skillstore Score Evidence Confidence Skillstore usage Updated
wshobson Recommended
wshobson-projection-patterns
Skillstore Score 78
Evidence Confidence High
Skillstore usage 12
Updated
2026-08-21
sickn33 Current
sickn33-projection-patterns
Skillstore Score 77
Evidence Confidence High
Skillstore usage 10
Updated
2026-08-21
Skillstore Score
Why this score Evidence Confidence: High 55
Architecture
85
Maintainability
85
Content
69
Community
83
Spec Compliance
What You Can Build
Design a CQRS read side
Plan tables, handlers, and checkpoints for an event-sourced service.
Rebuild materialized views
Choose catchup and persistent projection patterns for historical event replay.
Improve query performance
Model search indexes and summaries that avoid expensive stream scans.
Try These Prompts
Create a basic projection
Design a simple projection for these event types: [events]. Include the read model fields and update rules.
Plan checkpointing
Recommend a checkpoint strategy for a projection that processes [volume] events and must recover after failures.
Compare projection types
Compare live, catchup, persistent, and inline projections for this workflow: [workflow]. Recommend one option with tradeoffs.
Design multi-table projections
Design a multi-table projection for [domain]. Include event handlers, consistency concerns, rebuild steps, and monitoring signals.
Best Practices
- Define idempotent handlers so replayed events do not corrupt read models.
- Track checkpoints and lag metrics for every persistent projection.
- Plan rebuild procedures before changing projection schemas.
Avoid
- Do not query event streams directly for high-traffic read paths.
- Do not mix write-side validation rules into projection handlers.
- Do not deploy projections without replay and recovery checks.
Frequently Asked Questions
What is this skill for?
It helps design read models and projections for CQRS and event-sourced systems.
Does it generate production code?
It provides implementation templates and guidance, but users must adapt code to their stack.
Can it help with Elasticsearch projections?
Yes. The playbook includes a search projection template for indexing event-derived documents.
Does it support projection rebuilds?
Yes. It explains catchup projections, persistent checkpoints, and rebuild-focused practices.
Which AI tools can use it?
The report lists Claude, Codex, and Claude Code as supported tools.
Does it require network access?
No. The skill is documentation-based and references only a local playbook file.
Developer Details
Author
sickn33License
MIT
Skillstore revision
r1
Version notice
The author did not declare a version.
Repository
https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/projection-patternsRef
9f814fc6a43fd99946f2da5e0df231c65a38bc76
Maintenance freshness
7/18/2026
Usage
6 downloads · 123 views
File structure
More from sickn33
View all📦
prompt-engineering-patterns
85Improve LLM Prompts With Proven Patterns
Inconsistent prompts waste time and make AI outputs hard to trust. This skill guides prompt design with reusable patterns, examples, evaluation steps, and optimization workflows.
Productivity View
📦
senior-fullstack
82Build Fullstack Apps with Senior Patterns
Teams need consistent setup, architecture, and review guidance for modern web applications. This skill provides scaffolders, workflow references, and quality prompts for React, Next.js, Node.js, GraphQL, and PostgreSQL projects.
Coding & Development View
📦
senior-architect
81Design Scalable Software Architectures
Architecture decisions are hard to compare across web, mobile, backend, and cloud systems. This skill provides structured guides and local scaffold scripts for reports, dependency review, and trade-off documentation.
Coding & Development View
📦
prompt-engineer
81Optimize AI Prompts With Prompt Engineer
Writing clear prompts is hard when goals are vague or complex. This skill turns rough requests into structured prompts using proven prompt frameworks.
Productivity View
📦
product-manager-toolkit
80Prioritize Product Work With Research Insights
Product teams need faster ways to rank features, synthesize interviews, and document decisions. This skill provides RICE scoring, interview analysis, and PRD templates for structured planning.
Productivity View
Related Skills
View all📦
cqrs-implementation
78Implement CQRS Architecture
by wshobson
Complex applications often strain when reads and writes share one model. This skill provides CQRS templates for commands, queries, projections, and consistency handling.
Coding & Development View
📦
event-store-design
78Design Event Stores for Event-Sourced Systems
by wshobson
Event-sourced systems need durable ordering, concurrency checks, subscriptions, and clear storage choices. This skill guides schema design, implementation patterns, and technology selection for event stores.
Coding & Development View
📦
cqs-patterns
77Apply CQS and CQRS Patterns in .NET
by DoubleslashSE
Teams often mix state changes and data reads, which makes code harder to test and reason about. This skill guides clear CQS and CQRS designs for .NET methods, handlers, and controllers.
Coding & Development View
📦
event-driven-architecture
68Design Event-Driven Microservices
by Azeem-2
Event-driven systems are hard to design consistently across brokers and runtimes. This skill provides reusable patterns for schemas, brokers, sagas, CQRS, Dapr, and deployment.
Coding & Development View
📦
analyzing-test-quality
87Analyze Test Suite Quality
by C0ntr0lledCha0s
Coverage percentages alone cannot show whether tests are reliable, focused, or effective. This skill assesses quality dimensions and produces prioritized, evidence-based improvements.
Coding & Development View
📦
git-advanced
86Master Advanced Git Workflows
by AutumnsGrove
Complex Git maintenance can make history changes and conflict resolution difficult. This skill provides structured guidance, recovery steps, and an optional local helper for common advanced workflows.
Coding & Development View