1. Software Development

Provides SQLAlchemy ORM patterns for defining models, writing queries, and managing database sessions in Python applications.

Enables stub-driven Test-Driven Development (TDD) and layer boundary testing with pytest for robust component validation.

Provides TypeScript testing utilities with Vitest and MSW for unit tests, API mocking, typed dependency injection, and snapshot testing.

Provides guidance on modern Python 3.10+ features including type hints, pattern matching, and async/await for efficient code development.

Provides functional programming patterns for TypeScript to build reliable, type-safe domain models using state machines, discriminated unions, and Result/Option types.

Provides real-time messaging, collaborative editing, and Ably integration best practices for applications requiring instant data synchronization.

Provides type-safe database interactions for TypeScript applications using Drizzle ORM, supporting multiple SQL databases and migrations.

Comprehensive Jest testing patterns including test organization, factory patterns, mocking, and TDD for the ree-board project.

Enables building modern React applications using Next.js 16 App Router patterns, including server components, client components, and data fetching strategies.

Provides reactive state management with Preact Signals, covering signal usage, computed signals, batch updates, and domain-based state organization for frontend applications.

Provides Drizzle ORM best practices for schema design, migrations, type safety, and query optimization in backend development.

Dispatches significant application milestones (e.g., API calls, database operations) to a user-facing timeline for monitoring, using system-injected environment variables.

Guides developers through implementation, debugging, and verification phases to ensure high-quality code delivery within project workflows.

Provides type-safe TypeScript execution for orchestrating multi-tool workflows (ClickUp, Notion, etc.), reducing context and accelerating external tool integration.

Resolves Rust compiler errors related to ownership, borrowing, and lifetimes with expert solutions for common E0xxx errors.

Expert in Rust's zero-cost abstraction, generics, and trait systems, covering monomorphization and dispatch strategies for high-performance code.

Expert assistance with Rust programming challenges including ownership, lifetimes, concurrency, and performance optimization.

Expert in advanced Rust async patterns including Stream, backpressure, cancellation, and Future trait, with support for tokio and async-std runtimes.

Expert in Rust const generics and compile-time computation, enabling type-level calculations and efficient array handling with MaybeUninit.

Expert in Rust type-driven design patterns including newtypes, type states, and compile-time validation for safe, robust code.

Provides utilities for handling Pin, Unpin, self-referential types, and async/Generator features in Rust programming.

Expert in Rust concurrency and async programming, resolving deadlocks, race conditions, and managing threads, channels, and synchronization primitives.

Expert in Rust Foreign Function Interface (FFI) for seamless C/C++, Python (PyO3), and Java (JNI) interoperability, handling memory layout and data conversion.

Expert guidance for optimizing Rust applications through benchmarking, profiling, memory allocation, and SIMD techniques to maximize execution speed.