jeffallan/claude-skills▌

Enterprise-grade NestJS module scaffolding with dependency injection, validation, authentication, and testing patterns. \n \n Generates complete module architecture including controllers, services, DTOs, guards, and interceptors with proper TypeScript typing and dependency injection wiring \n Includes class-validator decorators for input validation, Swagger/OpenAPI documentation, and typed HTTP exception handling across all layers \n Covers authentication patterns (JWT, Passport), TypeORM/Prisma

Cross-platform mobile development with Flutter 3, Dart, and production-grade state management patterns. \n \n Covers widget development, Riverpod and Bloc state management, GoRouter navigation, and platform-specific implementations with detailed reference guides for each \n Enforces const optimization, proper key usage, and scoped state patterns to prevent unnecessary rebuilds and full-subtree re-renders \n Includes profiling workflows with Flutter DevTools, jank diagnosis, and performance optim

Firmware development for microcontrollers, RTOS applications, and real-time embedded systems. \n \n Covers STM32, ESP32, FreeRTOS, bare-metal programming, interrupt handlers, DMA transfers, and power optimization \n Provides reference guides for RTOS patterns, peripheral configuration, communication protocols, and memory optimization \n Includes code templates for ISR implementation, FreeRTOS task creation, and GPIO/timer setup with register-level details \n Enforces best practices: volatile dec

Modern PHP development with strict typing, enterprise patterns, and framework expertise across Laravel and Symfony. \n \n Enforces PHP 8.3+ strict types, PSR-12 standards, and PHPStan level 9 static analysis on all code before delivery \n Scaffolds typed domain models, DTOs, value objects, services, repositories, and controllers with full dependency injection \n Generates PHPUnit and Pest tests with 80%+ coverage requirements; runs both test suites and static analysis as mandatory verification g

Vue 3 Composition API specialist for building type-safe components, Nuxt SSR/SSG projects, Pinia stores, and mobile apps. \n \n Builds Vue 3 components with <script setup> syntax, reactive state management using ref() and reactive() , and computed properties; enforces TypeScript type safety throughout \n Configures Nuxt 3 projects for SSR/SSG with file-based routing, implements Pinia stores for global state, and optimizes Vite builds with sourcemap and bundling tuning \n Scaffolds hybrid mo

Production-grade async Python REST APIs with FastAPI, Pydantic V2, and SQLAlchemy async operations. \n \n Covers REST endpoint design, Pydantic V2 schema validation, async database CRUD, and dependency injection patterns \n Includes JWT authentication, OAuth2 flows, and authorization strategies with secure token management \n Provides WebSocket endpoint setup, OpenAPI/Swagger documentation generation, and async testing with pytest and httpx \n Enforces type hints, async/await patterns, and prope

Reverse-engineer undocumented codebases to extract specifications, architecture, and observable behavior patterns. \n \n Uses two analytical perspectives: Arch Hat for system architecture and data flows, QA Hat for observable behaviors and edge cases \n Employs systematic exploration with Glob, Grep, and Read tools to map code structure, entry points, configuration, and API routes before documentation \n Documents extracted requirements in EARS format (Ubiquitous, Event-driven, State-driven, Opt

Expert Apache Spark engineer for distributed data processing, ETL pipeline optimization, and production-grade big data applications. \n \n Covers DataFrame API, Spark SQL, RDD operations, and structured streaming with explicit schema definitions and lazy evaluation patterns \n Provides partitioning strategies, broadcast join optimization, data skew handling via salting, and caching best practices for large-scale workloads \n Includes performance tuning guidance: shuffle partition configuration,

Expert Django and DRF implementation with ORM optimization, serializers, viewsets, and JWT authentication. \n \n Designs Django models with proper indexes, relationships, and managers; handles migrations and schema verification \n Optimizes ORM queries using select_related and prefetch_related to prevent N+1 problems \n Builds DRF serializers with validation, viewsets with permissions, and async views for Django 5.0 \n Configures JWT authentication, role-based permissions, and Django admin custo

Real-time bidirectional messaging with Socket.IO, Redis scaling, and presence tracking. \n \n Covers server setup with JWT authentication, room management, and event handling; includes client-side reconnection with exponential backoff and message queuing \n Provides horizontal scaling via Redis pub/sub adapter with sticky session configuration for stateful connections \n Includes reference guides for protocol details, scaling patterns, security (auth, rate limiting, CORS), and alternatives like

Expert pandas data manipulation with vectorized operations, memory optimization, and production-grade validation patterns. \n \n Covers core workflows: data assessment, transformation design, efficient implementation, result validation, and memory profiling \n Includes reference guides and code patterns for DataFrame operations, data cleaning, aggregation, merging, and time series resampling \n Enforces vectorized operations over iteration, proper indexing with .loc[] / .iloc[] , and explicit mi

Expert React 18+ and React 19 component development with Server Components, hooks, and state management. \n \n Covers React 19 features including use() hook, useActionState forms, and Server Components in Next.js App Router \n Implements custom hooks, state management patterns (Context, Zustand, Redux), and data fetching with TanStack Query \n Enforces TypeScript strict mode, error boundaries, proper cleanup, and accessibility standards throughout \n Includes performance optimization via memoiza

Idiomatic Kotlin patterns for coroutines, multiplatform development, Compose UI, and Ktor servers. \n \n Covers structured concurrency with coroutines and Flow streams, sealed classes for type-safe state modeling, and null safety enforcement \n Supports Kotlin Multiplatform (KMP) architecture with expect/actual patterns and shared code strategies \n Includes Android Jetpack Compose, ViewModel integration, and Material3 design patterns \n Provides Ktor server setup with routing, plugins, authenti

CI/CD pipelines, containerization, Kubernetes deployments, and infrastructure as code automation. \n \n Covers GitHub Actions, GitLab CI, and Jenkins pipeline setup with build, test, and artifact management workflows \n Generates Dockerfiles, Kubernetes manifests, Terraform/Pulumi templates, and deployment strategies (blue-green, canary, rolling) \n Includes incident response runbooks, on-call procedures, and production troubleshooting guidance \n Enforces infrastructure-as-code practices, secre

Custom WordPress themes, plugins, Gutenberg blocks, WooCommerce stores, and REST API endpoints with security hardening and performance optimization. \n \n Covers theme development, plugin architecture, block creation, hooks/filters, and WooCommerce customization with WordPress coding standards validation \n Enforces security across nonce verification, input sanitization, output escaping, capability checks, and prepared database queries \n Includes performance patterns for transient/object cachin

Structured critical reasoning to stress-test ideas, plans, and decisions through five distinct challenge modes. \n \n Five reasoning modes: expose assumptions (Socratic), argue the other side (dialectic), find failure modes (pre-mortem), attack this (red team), and test evidence (falsification) \n Two-step mode selection guides users to the right challenge approach based on their goal \n Steelmans positions before challenging them, grounds objections in concrete reasoning, and synthesizes insigh

Apex code, Lightning Web Components, SOQL optimization, and Salesforce platform development with governor limit enforcement. \n \n Covers Apex classes, triggers, batch jobs, async processing, and platform events with bulkification patterns and test class templates \n Includes Lightning Web Component design, wire service integration, and component lifecycle best practices \n Provides SOQL/SOSL optimization guidance, relationship queries, and indexed field selection to stay within governor limits

Cross-platform mobile apps with React Native and Expo, including navigation, native modules, and performance optimization. \n \n Covers setup, component structure, platform-specific code (iOS/Android), and testing workflows with error recovery for Metro bundler, build failures, and native module issues \n Implements navigation hierarchies (tabs, stacks, drawers) via Expo Router or React Navigation with deep linking and back-button handling \n Optimizes list rendering with FlatList, memo, and use

High-level system architecture design, decision documentation, and technology trade-off evaluation for distributed systems. \n \n Guides full architecture workflows from requirements gathering through stakeholder review, with explicit trade-off analysis and failure mode planning \n Produces architecture diagrams (Mermaid format), Architecture Decision Records (ADRs), and technology recommendations with documented rationale \n Covers architectural patterns, microservices structuring, scalability

Build and configure Laravel 10+ applications with Eloquent models, Sanctum auth, queues, and Livewire components. \n \n Covers Eloquent ORM with relationships, scopes, and query optimization; API resource design; and RESTful controller patterns \n Implements queue jobs with Horizon, Sanctum authentication flows, and reactive Livewire interfaces \n Enforces PHP 8.2+ typing, eager loading to prevent N+1 queries, comprehensive testing (>85% coverage), and PSR-12 standards \n Includes code templates

Enterprise Java specialist for Spring Boot 3.x, microservices, and cloud-native development. \n \n Covers Spring Boot 3.x architecture, WebFlux reactive endpoints, Spring Data JPA optimization, and Spring Security with OAuth2/JWT configuration \n Enforces Java 21 LTS features, DDD/Clean Architecture principles, and comprehensive test coverage (85%+ target) with Maven/Gradle verification workflows \n Includes domain modeling, service layer design, repository patterns, and REST endpoint implementa

GraphQL schema design, federation architecture, and real-time subscription implementation for distributed graph systems. \n \n Covers schema-first design with Apollo Federation 2.5+, including entity resolution, subgraph composition, and federation directives \n Provides resolver patterns with DataLoader for N+1 prevention, batching, and caching across distributed architectures \n Includes query complexity analysis, depth limiting, and field-level security to prevent abuse before deployment \n S

Production-grade ML pipeline infrastructure with experiment tracking, orchestration, feature stores, and automated model lifecycle management. \n \n Covers end-to-end pipeline design: data validation, feature engineering, distributed training orchestration, experiment tracking, and model evaluation gates \n Supports multiple orchestration frameworks (Kubeflow, Airflow, Prefect) and experiment tracking systems (MLflow, Weights & Biases) with code templates and reference guides \n Enforces re

Design, optimize, and evaluate LLM prompts for maximum accuracy and efficiency. \n \n Covers prompt patterns including zero-shot, few-shot, chain-of-thought, and ReAct, with before/after optimization examples \n Provides structured workflow from requirements definition through testing, iteration, and production deployment with validation checkpoints \n Includes evaluation frameworks, metrics, and test suite generation to measure and improve model performance \n Supports structured output design

Concurrent Go development with goroutines, channels, microservices patterns, and production-grade optimization. \n \n Implements idiomatic Go 1.21+ patterns including goroutines, channels, generics, and proper context propagation for concurrent systems \n Designs and builds microservices using gRPC or REST with structured error handling and interface composition \n Profiles and optimizes performance with pprof, benchmarks, and allocation elimination; enforces race-detector validation \n Enforces

Kubernetes workload deployment, configuration, security, and troubleshooting across single and multi-cluster environments. \n \n Covers Deployments, StatefulSets, DaemonSets, Jobs, Helm charts, RBAC policies, NetworkPolicies, and storage configuration with declarative YAML manifests \n Includes troubleshooting workflows for pod crashes, resource analysis, log inspection, and rollback procedures using kubectl commands \n Enforces security best practices: resource limits, health probes, least-priv

SRE practices for defining SLOs, managing error budgets, automating toil, and building resilient production systems. \n \n Defines quantitative SLOs with SLI measurements, calculates error budgets, and enforces burn-rate policies to balance reliability with feature velocity \n Provides golden signal monitoring (latency, traffic, errors, saturation) with multiwindow burn-rate alerting rules and PromQL query templates \n Includes automation patterns for toil reduction, chaos engineering test desig

Comprehensive testing specialist for functional, performance, and security test design and execution. \n \n Covers unit, integration, E2E, performance (k6, Artillery), and security testing (OWASP) with structured workflows from scope definition through reporting \n Enforces test quality standards: meaningful assertions, isolated dependencies, edge-case coverage, and flaky-test remediation \n Provides reference guides for TDD methodology, testing anti-patterns, automation frameworks, and QA pract

Spring Boot 3.x code generation for REST APIs, microservices, and reactive applications with built-in security and data access patterns. \n \n Generates layered Spring Boot 3.x applications with constructor injection, Spring Data JPA repositories, REST controllers, and global exception handling \n Implements Spring Security 6 authentication flows, OAuth2, JWT, and method-level security with CORS configuration \n Supports reactive WebFlux endpoints alongside traditional blocking REST APIs and Spr

SQL query optimization, schema design, and performance troubleshooting across PostgreSQL, MySQL, SQL Server, and Oracle. \n \n Covers query patterns including CTEs, window functions, recursive queries, and complex joins with execution plan analysis and optimization strategies \n Provides EXPLAIN/ANALYZE interpretation, covering index design, statistics tuning, and before/after benchmarking to meet sub-100ms performance targets \n Includes schema design guidance on normalization, keys, constraint

Jira and Confluence automation via MCP protocol with JQL/CQL queries, ticket management, and sprint workflows. \n \n Supports querying Jira issues with JQL filters, creating and updating tickets with custom fields, and managing sprints and backlogs \n Enables searching, creating, and editing Confluence pages using CQL syntax with space and content management \n Includes authentication patterns for OAuth 2.0, API tokens, and PAT credentials with permission scope validation \n Provides reference g

Writes, reviews, and debugs idiomatic Rust code with memory safety and zero-cost abstractions. \n \n Handles ownership patterns, lifetime annotation, borrowing design, and trait hierarchies with generics and associated types \n Implements async/await applications with tokio, concurrent task spawning, and proper error propagation via Result/Option \n Enforces validation through cargo clippy, rustfmt, and comprehensive testing (unit, integration, doctests) \n Minimizes unsafe code with documented

REST and GraphQL API design with comprehensive OpenAPI 3.1 specifications and architectural guidance. \n \n Covers resource modeling, endpoint design, HTTP method semantics, and URI patterns with strict REST principles \n Includes OpenAPI 3.1 templates, RFC 7807 error response standards, and validation workflows using Redocly and Prism mock servers \n Provides reference guides for versioning strategies, pagination patterns (cursor, offset, keyset), and backward-compatibility planning \n Enforces

Angular 17+ standalone components, signals, NgRx state management, and enterprise application architecture. \n \n Generates standalone components with OnPush change detection, signals for reactive state, and computed properties; includes RxJS subscription management with takeUntilDestroyed \n Configures NgRx store with actions, reducers, selectors, and effects; verifies store hydration and action flow via Redux DevTools \n Implements advanced routing with lazy loading, guards, and resolvers for

Custom security implementations for authentication, authorization, input validation, and OWASP Top 10 vulnerability prevention. \n \n Covers password hashing (bcrypt/argon2), parameterized SQL queries, JWT validation, and rate limiting with explicit code examples \n Includes validation checkpoints for authentication (brute-force, session fixation, token expiration), authorization (privilege escalation), input handling (SQL injection, XSS), and security headers \n Enforces must-do constraints: ha

Modern C++20/23 specialist for writing, optimizing, and debugging high-performance systems code. \n \n Covers C++20 concepts, ranges, coroutines, template metaprogramming, and SIMD optimization with zero-overhead abstractions \n Enforces RAII, const-correctness, smart pointers, and comprehensive sanitizer/static analysis checks before delivery \n Includes reference guides for modern features, templates, memory management, concurrency patterns, and CMake build configuration \n Delivers header fil

Generates and validates technical documentation across docstrings, API specs, and developer guides. \n \n Supports multiple docstring formats (Google, NumPy, Sphinx for Python; JSDoc for TypeScript) and API specification standards (OpenAPI, AsyncAPI, gRPC) \n Includes validation workflows for each format: doctest/pytest for Python, TypeScript compilation checks, and Redocly linting for OpenAPI specs \n Covers inline code documentation, interactive API portals, documentation site generation, and

Full-stack web application development with integrated security controls across frontend, backend, and database layers. \n \n Enforces authentication, authorization, input validation, output encoding, and parameterized queries at every layer; includes security checklist and design templates for every feature \n Covers complete workflows from database to UI: REST APIs with corresponding components, CRUD operations with forms, real-time features, and end-to-end data flows \n Provides reference gui

Systematic bug isolation and root cause analysis through hypothesis-driven debugging methodology. \n \n Applies five-step workflow: reproduce, isolate, hypothesize and test, fix, and prevent through regression tests \n Includes language-specific debugger guidance (Python pdb, Node.js Inspector, Go delve) and advanced strategies like git bisect for regression hunting \n Enforces strict constraints: reproduce first, test one hypothesis at a time, document findings, and remove debug code before com

Complete iOS/macOS/watchOS/tvOS development with SwiftUI, async/await, protocol-oriented design, and actor-based concurrency. \n \n Covers SwiftUI state management with @Observable, async/await patterns, protocol-oriented architecture with associated types, and actor isolation for thread safety \n Includes validation checkpoints at each workflow stage: compilation verification, strict warning checks for actor isolation, and async test confirmation \n Provides reference guides for SwiftUI pattern

Structured requirements workshops that produce EARS-format specifications, user stories, acceptance criteria, and implementation checklists. \n \n Conducts systematic discovery interviews from both product and engineering perspectives, using structured questioning to elicit requirements before writing specifications \n Outputs comprehensive specifications including functional requirements in EARS format, non-functional requirements, Given/When/Then acceptance criteria, error handling tables, and

Playwright E2E testing specialist for writing maintainable browser tests, debugging flaky tests, and CI/CD integration. \n \n Emphasizes role-based selectors and auto-waiting to avoid brittle tests and arbitrary timeouts \n Provides Page Object Model patterns for test organization, fixture setup, and configuration guidance \n Includes debugging workflow using trace viewer, screenshots, and retry strategies to identify and fix flaky tests \n Covers API mocking, visual regression testing, and para

Incremental migration strategies, dependency mapping, and facade designs for safely modernizing legacy systems. \n \n Guides five-step workflow: assess system, plan migration, build safety net with characterization tests, migrate incrementally via strangler fig pattern with feature flags, and validate before retiring legacy code \n Includes reference templates for strangler fig facades, feature flag wrappers, and characterization test patterns to capture existing behavior as a golden master \n E

Production-grade RAG system design covering chunking, embeddings, vector stores, hybrid search, reranking, and retrieval evaluation. \n \n Guides five core workflow steps: requirements analysis, vector store design, chunking strategy, retrieval pipeline configuration, and quality evaluation with checkpoints \n Supports multiple vector databases (Pinecone, Weaviate, Chroma, pgvector, Qdrant) with schema design, indexing, and sharding strategies \n Implements hybrid search combining dense vector r

Infrastructure as code implementation across AWS, Azure, and GCP with modular design and state management. \n \n Covers module development, state backend configuration with locking and encryption, provider setup, and multi-environment workflows \n Enforces validation, semantic versioning, and security constraints; includes error recovery patterns for state drift, auth failures, and dependency issues \n Provides structured workflows: analyze requirements, design composable modules, configure remo

Expert guidance for fine-tuning LLMs with parameter-efficient methods and production optimization. \n \n Covers LoRA, QLoRA, and full fine-tuning workflows with Hugging Face PEFT, including dataset validation, hyperparameter configuration, and adapter merging for deployment \n Provides a complete minimal working example with LoRA setup, training loop, and quantization variants for memory-constrained environments \n Includes five-stage workflow: dataset preparation, method selection, training wit

Designs and executes chaos experiments with safety controls, runbooks, and resilience testing frameworks. \n \n Covers full chaos workflow: system analysis, hypothesis-driven experiment design, controlled failure injection, and learning loops with documented improvements \n Provides templates and reference guides for infrastructure chaos (servers, networks, zones), Kubernetes-native experiments (Litmus, Chaos Mesh), and game day exercises \n Includes concrete examples using Litmus ChaosEngine, t

Build and debug MCP servers and clients connecting AI systems with external tools and data sources. \n \n Supports TypeScript (Node.js SDK) and Python (FastMCP) for implementing tool handlers, resource providers, and prompt templates with Zod or Pydantic schema validation \n Covers three transport layers: stdio (local), HTTP, and SSE (streaming), with JSON-RPC 2.0 protocol compliance and interactive debugging via the MCP inspector \n Includes scaffolding workflows, schema design patterns, and er

Vue 3 components and composables in JavaScript with comprehensive JSDoc type coverage, no TypeScript required. \n \n Builds with <script setup> and .mjs modules using @typedef , @param , and @returns JSDoc annotations for full type safety without a TypeScript compiler \n Covers component architecture (props, emits, slots), custom composables, Pinia state management, and Vue Router configuration entirely in vanilla JavaScript \n Includes ESLint JSDoc plugin verification to ensure all public

Multi-cloud architecture design, migration planning, cost optimization, and disaster recovery across AWS, Azure, and GCP. \n \n Covers six core workflow stages: discovery, design, security, cost modeling, migration, and operations with validation checkpoints at each phase \n Implements zero-trust security, least-privilege IAM, encryption at rest and in transit, and multi-region redundancy for critical workloads \n Applies the 6Rs migration framework, Well-Architected principles, and FinOps pract

Build cross-platform CLI tools with argument parsing, interactive prompts, and shell completions. \n \n Covers Node.js (commander, yargs), Python (click, typer), and Go (cobra, viper) frameworks with design patterns for subcommands, flags, and configuration \n Includes UX patterns for progress bars, spinners, color output with TTY detection, and graceful signal handling \n Requires startup time under 50ms, consistent flag naming, non-interactive fallbacks for CI/CD, and shell completion generati

Designs distributed system architectures, decomposes monoliths into microservices, and documents resilience patterns. \n \n Applies domain-driven design to identify bounded contexts and service boundaries; validates that each service owns its data exclusively and deploys independently \n Covers communication design (REST, gRPC, async messaging), data strategies (database per service, event sourcing, CQRS), and resilience patterns (circuit breakers, sagas, bulkheads, timeouts) \n Provides referen

Game systems implementation for Unity and Unreal with ECS architecture, physics, networking, and performance optimization. \n \n Covers core game development workflows: architecture design, ECS/component systems, physics configuration, multiplayer networking with lag compensation, and shader programming \n Enforces 60+ FPS performance targets with profiling checkpoints; includes object pooling, LOD systems, async loading, and component caching patterns to eliminate frame-time bottlenecks \n Prov

Rails 7+ specialist optimizing queries, implementing Hotwire real-time features, and background job processing. \n \n Covers Active Record query optimization with includes / eager_load to prevent N+1 queries, plus database indexing strategies \n Implements Turbo Frames and Turbo Streams for partial page updates, and Action Cable configuration for WebSocket-based real-time features \n Provides Sidekiq worker templates for background job processing with retry logic and error handling \n Includes R

Expert guidance for building .NET 8 applications with clean architecture, minimal APIs, and cloud-native patterns. \n \n Covers minimal APIs, Entity Framework Core, CQRS with MediatR, JWT authentication, and AOT compilation for .NET 8 \n Enforces async/await patterns, nullable reference types, record DTOs, and clean architecture layer separation \n Includes reference guides for minimal APIs, clean architecture, Entity Framework, authentication, and cloud-native deployment \n Provides code exampl

Comprehensive monitoring, logging, metrics, tracing, and performance testing implementation for production systems. \n \n Covers structured logging (Pino/JSON), Prometheus metrics (counters, histograms, gauges), and OpenTelemetry distributed tracing with span instrumentation \n Includes Prometheus alerting rule configuration, RED/USE dashboard design patterns, and health check endpoint setup \n Provides load testing with k6 and Artillery, application profiling for CPU/memory bottlenecks, and cap

Diagnose and resolve database performance issues across PostgreSQL and MySQL with query analysis and optimization strategies. \n \n Analyzes slow queries using EXPLAIN ANALYZE , identifies missing indexes, and designs covering index strategies \n Provides database-specific tuning guidance for PostgreSQL and MySQL configuration, schema design, and partitioning \n Includes reference materials for query optimization, index strategies, monitoring, and lock contention resolution \n Delivers before/af

Advanced TypeScript type systems, generics, branded types, and end-to-end type safety with tRPC integration. \n \n Covers branded types, discriminated unions, conditional types, mapped types, and custom utility types for domain-driven type modeling \n Includes type guards, assertion functions, and exhaustive pattern matching to enforce compile-time safety across state machines and APIs \n Provides tsconfig best practices with strict mode, incremental compilation, project references, and declarat

Next.js 14+ App Router specialist for server components, server actions, and full-stack deployment. \n \n Covers App Router architecture, layouts, route groups, loading/error boundaries, and streaming SSR with Suspense \n Implements server components by default with 'use client' only at leaf boundaries; handles data fetching with explicit cache and revalidation strategies \n Provides server actions for form handling, mutations, and on-demand cache revalidation via revalidatePath \n Includes gene

Identifies security vulnerabilities, generates structured audit reports with severity ratings, and provides actionable remediation guidance. \n \n Conducts SAST scans, dependency audits, secrets scanning, and manual code review across authentication, input handling, and cryptography \n Supports penetration testing, infrastructure security audits, and cloud security reviews with scope verification and rules of engagement enforcement \n Produces severity-rated findings (Critical/High/Medium/Low/In

Analyzes code diffs and files to identify bugs, security vulnerabilities, performance issues, and architectural concerns with prioritized feedback. \n \n Detects common issues including SQL injection, XSS, N+1 queries, magic numbers, hardcoded secrets, and design pattern violations \n Follows a structured five-step workflow: context understanding, architecture review, code quality checks, test validation, and categorized reporting \n Produces prioritized reports organized by severity (critical,

Expert PostgreSQL optimization, replication setup, and advanced feature implementation. \n \n Covers query analysis with EXPLAIN, index design across B-tree/GIN/GiST/BRIN types, and JSONB storage strategies with containment queries \n Includes streaming and logical replication setup with lag monitoring via pg_stat_replication \n Provides VACUUM tuning, autovacuum configuration, bloat detection, and statistics refresh workflows \n Supports PostgreSQL extensions including PostGIS, pgvector, pg_trg

Complete Shopify development expertise for themes, apps, headless storefronts, and checkout customization. \n \n Covers theme development with Liquid templating, Storefront API integration, and Online Store 2.0 architecture; includes linting and deployment via Shopify CLI \n Supports full-stack app development with OAuth, webhooks, Admin API authentication, and checkout UI extensions using TypeScript and Remix \n Provides GraphQL query patterns, metafield handling, image optimization, and perfor

Type-safe, async-first Python 3.11+ code generation with strict validation and comprehensive testing. \n \n Generates fully type-annotated code with mypy strict mode validation, dataclasses, and modern Python patterns (3.10+ union syntax, async/await) \n Includes pytest test suite generation with fixtures, parametrization, and mocking; enforces >90% code coverage \n Validates output with black formatting and ruff linting; provides structured error handling and logging configuration \n Covers asy

Modern ES2023+ JavaScript implementation with async/await, ESM modules, and Node.js best practices. \n \n Covers vanilla JavaScript, Promise-based async flows, Web Workers, Fetch API, and browser performance optimization \n Enforces ES2023+ syntax, optional chaining, nullish coalescing, and functional programming patterns \n Includes comprehensive error handling, memory leak detection, and Jest test coverage validation (85%+ target) \n Provides reference guides for async patterns, module systems

Build REST APIs, Blazor apps, and cloud-native solutions with .NET 8+ and modern C# patterns. \n \n Implements ASP.NET Core APIs using Minimal or Controller-based routing, with Entity Framework Core for data access and async/await throughout \n Structures applications with CQRS via MediatR, dependency injection, and strongly-typed configuration \n Enforces nullable reference types, cancellation tokens, Result pattern error handling, and DTO mapping to prevent EF entity leakage \n Scaffolds Blazo