cqrs-implementation
Implement Command Query Responsibility Segregation for scalable architectures. Use when separating read and write models, optimizing query performance, or building event-sourced systems.
Data access patterns, Scaling, Migrations, and ORM selection.
Full skill instructions
| Feature Needed | Primary Choice | Alternative |
|---|---|---|
| General Purpose App | PostgreSQL | MySQL |
| Flexible JSON Docs | MongoDB | PostgreSQL (JSONB) |
| Search Engine | ElasticSearch | PostgreSQL (Full Text) |
| Financial Transactions | PostgreSQL | (None) |
@InjectRepository(Entity).PrismaService.TypeOrmModule.forRootAsync to load secrets from ConfigService.synchronize: false in production; use migrations instead.replication connections (Master for Write, Slaves for Read) in TypeORM/Prisma to distribute load.synchronize: true in production.@DeleteDateColumn (TypeORM) or middleware (Prisma) to preserve data integrity.tenant_id column.
Where scopes.user_id) across physical nodes to exceed single-node write limits.created_at) are included in WHERE clauses to enable "Partition Pruning".CREATE TABLE, ADD COLUMN). Fast. Run before app deploy.UPDATE users SET name = ...). Slow. Run as background jobs or separate scripts purely to avoid locking tables for too long.new_field (nullable). Deploy App v1 (Writes to both old and new).old to new in batches (background script).new). Drop old_field in next schema migration.@faker-js/faker) to generate mock data.where, order by).QueryRunner (TypeORM) or $transaction (Prisma) for all multi-step mutations to ensure atomicity.Implement Command Query Responsibility Segregation for scalable architectures. Use when separating read and write models, optimizing query performance, or building event-sourced systems.
Native image compilation, reflection configuration, and build optimization.
Expert patterns for Algolia search implementation, indexing strategies, React InstantSearch, and relevance tuning Use when: adding search to, algolia, instantsearch, search api, search functionality.
|
Build automated billing systems for recurring payments, invoicing, subscription lifecycle, and dunning management. Use when implementing subscription billing, automating invoicing, or managing recu...
Optimize Bazel builds for large-scale monorepos. Use when configuring Bazel, implementing remote execution, or optimizing build performance for enterprise codebases.
Automate Basecamp project management, to-dos, messages, people, and to-do list organization via Rube MCP (Composio). Always search tools first for current schemas.
Expert guide for Unreal Engine 5.x C++ development, covering UObject hygiene, performance patterns, and best practices.
Automate Outlook Calendar tasks via Rube MCP (Composio): create events, manage attendees, find meeting times, and handle invitations. Always search tools first for current schemas.
Migrate from AngularJS to Angular using hybrid mode, incremental component rewriting, and dependency injection updates. Use when upgrading AngularJS applications, planning framework migrations, or ...
|
Every product will be AI-powered. The question is whether you'll build it right or ship a demo that falls apart in production. This skill covers LLM integration patterns, RAG architecture, prompt ...
Generate, edit, and beat-sync AI video with leading models in one workspace.
The world's fastest calendar for remote work
Transform Your Design with AI Designer by ImgCreator.ai
Revolutionizing Video Production with AI-Powered Creativity
Extend an image past the frame and let AI fill the new aspect ratio.
Discover your celebrity doppelgänger with StarByFace!
ChainClarity explains 700+ crypto whitepapers in plain English, with layered summaries, comparisons, research tools, alerts, and a $4.99 Pro plan.
Opus.ai: Revolutionize Your Web Experience