1. Software Development

Manages optimistic UI updates with time-window deduplication in React using only local state, avoiding external storage.

Manages normalized schema cascade delete patterns, including junction tables and nullify vs delete strategies for database relationships.

Provides structured JSON logging for Convex backend with configurable levels, context objects, and tag conventions.

Resolves TypeScript 'type instantiation excessively deep' errors in Convex backend queries through helper patterns for safe recursion in large codebases.

Provides a 3-tier API architecture for cross-platform data fetching using REST, SSE, and Convex WebSocket with platform detection and DAL layer patterns.

Creates AI SDK v5 tools using factory patterns, Zod schemas, and features like rate limiting and caching for efficient development.

Provides a resumable zero-downtime migration pattern for Convex database schema changes using 6-phase workflows with checkpoint tracking and dual-write transitions.

Provides a Dexie-based IndexedDB caching layer with Convex sync for local-first applications, featuring optimistic updates and SSR safety.

Configures Vercel AI Gateway for provider fallback and host order, enabling multi-host model routing and seamless integration with AI services.

Provides Server-Sent Events (SSE) streaming patterns with TransformStream (mobile API) and ReadableStream (legacy) implementations, heartbeat, and cleanup.

Provides a database-backed model repository pattern with React hooks for reactive queries and TypeScript type handling, including static fallbacks.

Provides BEM naming conventions, SCSS structure, theming, and responsive design patterns for frontend styling in EasyPlatform.

Provides Angular 19 frontend development patterns for component hierarchy, state management, and reactive forms in EasyPlatform.

Guides setup, configuration, and troubleshooting of the Claude Code CLI, addressing common issues and feature usage.

Provides C# backend pattern implementations for .NET 9 (EasyPlatform), including CQRS, repository, and validation patterns.

Provides initial triage for user-reported bugs and error diagnosis through systematic assessment protocols.

Quickly locates relevant files in a large codebase to streamline feature development and code changes across multiple directories.

Enforces test-driven development practices with 80%+ test coverage for new features, bug fixes, and code refactoring.

Automates iterative code review cycles using Codex CLI, ensuring code quality before commits, PRs, and releases by fixing and re-reviewing until approval.

Generates standardized barrel files and export patterns for TypeScript index.ts files to streamline module organization.

Provides automated code quality checks and anti-pattern detection for TypeScript, React, and Next.js portal applications to ensure maintainable and efficient development.

A tool to find and use Park UI components in portal development, ensuring the right component is chosen before implementation.

Adds new World of Warcraft content (classes, spells, talents) to the Rust simulation engine for game mechanics implementation.

Provides project-wide code quality reviews, audits, and pre-release checks to ensure robust, maintainable codebases.