patterns▌

PostgreSQL best practices for indexing, schema design, query optimization, and security. \n \n Covers six index types with specific use cases: B-tree for equality/range queries, composite for multi-column filters, GIN for JSONB and full-text search, and BRIN for time-series data \n Includes data type guidance (bigint for IDs, text over varchar, timestamptz for timestamps, numeric for money) and anti-pattern detection queries for unindexed foreign keys and slow queries \n Provides ready-to-use SQ

Structured patterns and templates for seamless on-call shift handoffs with full context transfer. \n \n Provides shift handoff document template covering active incidents, ongoing investigations, recent changes, known issues, and upcoming events \n Includes recommended 30-minute overlap timing with split responsibilities for outgoing and incoming engineers \n Offers quick async handoff template for rapid transitions and mid-incident handoff template for continuity during active incidents \n Feat

React and Next.js patterns for component composition, state management, performance optimization, and accessible UI. \n \n Covers component patterns including composition, compound components, and render props for flexible, reusable UI architecture \n Provides custom hooks for state management, async data fetching, debouncing, and form handling with validation \n Includes performance techniques: memoization, code splitting with lazy loading, and virtualization for large lists \n Demonstrates err

Test-Driven Development (TDD):

Production-ready Node.js backend patterns with Express/Fastify, middleware, authentication, and database integration. \n \n Covers layered architecture (controllers, services, repositories), dependency injection, and microservices design with TypeScript \n Includes middleware patterns for authentication, validation, rate limiting, and request logging with practical examples \n Provides custom error handling, global error handlers, and async error wrappers for robust error management \n Supports

Nx monorepo configuration patterns for workspace setup, project boundaries, and build optimization. \n \n Provides architectural templates for organizing apps, libraries, and tools with five library types (feature, ui, data-access, util, shell) and scope-based dependency rules \n Includes ready-to-use configurations for nx.json, project.json, module boundary enforcement via ESLint, and custom generators to maintain consistency \n Covers build caching setup with cacheable operations, named inputs

Build read models and materialized views from event streams using projection patterns. \n \n Covers four projection types: live (real-time subscriptions), catchup (historical processing), persistent (with checkpointing), and inline (strong consistency) \n Includes five ready-to-use templates: basic projector framework, order summary projection, Elasticsearch search indexing, daily sales aggregation, and multi-table customer activity tracking \n Emphasizes idempotency, transactional consistency,

Assembly instruction patterns, control flow analysis, and decompilation techniques for understanding compiled binaries. \n \n Covers x86-64, ARM64, and ARM32 calling conventions with detailed instruction patterns for function prologues, epilogues, and parameter passing across System V and Microsoft x64 ABIs \n Includes control flow patterns for conditionals, loops, and switch statements, plus data structure recognition for arrays, structs, and linked lists \n Provides common code patterns for st

CI/CD pipelines, Docker containerization, deployment strategies, health checks, and production readiness for web applications. \n \n Covers three deployment patterns: rolling (zero-downtime gradual updates), blue-green (atomic traffic switching), and canary (percentage-based rollout with monitoring) \n Includes multi-stage Dockerfile examples for Node.js, Go, and Python with best practices for image size, non-root users, and health checks \n Provides GitHub Actions pipeline templates, environmen

Proven architectural patterns for building n8n workflows across five core use cases. \n \n Covers five foundational patterns: webhook processing, HTTP API integration, database operations, AI agent workflows, and scheduled tasks, each with specific triggers, transformations, and outputs \n Includes a pattern selection guide with real-world examples, helping developers choose the right architecture for their use case \n Provides a workflow creation checklist spanning planning, implementation, val