1. Software Development

Enforces root cause analysis before implementing fixes, preventing recurring issues through systematic debugging discipline.

Reviews and enforces PostgreSQL schema design conventions in technical documentation, ensuring adherence to specified patterns for tables, constraints, and comments.

Manages end-to-end quality assurance workflows including test planning, execution, and automation strategy for software projects.

Provides Supabase backend patterns for CRM implementation including RLS policies, Edge Functions, and multi-tenant architecture with PostgreSQL.

Provides architecture rules for data providers in Crispy CRM, enforcing Strangler Fig migration, View/Table duality, and service layer encapsulation for CRUD operations with React Admin and Supabase.

Traces call chains backward to identify root causes of bugs, integrating with debugging tools for hypothesis-driven investigation.

Enforces software development best practices including fail-fast patterns, Zod validation, TypeScript interfaces, and React Admin patterns to block anti-patterns and promote robust code.

Provides tools for receiving and giving code review feedback, addressing PR comments, and implementing suggestions while adhering to project principles.

Diagnoses and resolves build failures, performance bottlenecks, and deployment issues using the RAPID framework with TypeScript, Edge Functions, and environment configurations.

Conducts full-stack codebase audits for Crispy CRM using a phased quality approach, generating markdown reports and actionable todos.

Provides reusable patterns for Next.js middleware to manage protected routes, authentication redirects, and URL handling.

Provides quick codebase inventory answers using pre-computed discovery files, triggered by keywords like component, hook, and schema, reducing token usage by 90%+.

Executes Jest tests for Guidr React Native, providing coverage reports, watch mode, and test structure overview across application components.

Enforces data integrity across API, form, and database layers using Zod, RLS, and strict validation to prevent security issues and data corruption.

Provides reusable, accessible form components including inputs, selects, checkboxes, and file uploads for seamless integration in applications.

Standardizes StepLeague API route creation with withApiHandler, supporting HTTP methods and authentication.

Debugs TypeScript build errors in Next.js and Supabase, resolving type mismatches, 'never' types, and generic issues.

Enables comprehensive code analysis by tracing all entry points, data flows, and architectural decisions for thorough system understanding.

Creates isolated Git worktrees for feature development with workspace separation, smart directory selection, and safety verification.

Expert guidance for building modern frontend applications with React 18+, Next.js 15, TypeScript, and best practices including a11y and i18n.

Dispatches independent tasks to parallel agents for concurrent execution without shared state dependencies.

Provides reusable patterns for Supabase client implementation, covering authentication, session handling, deadlock prevention, and admin client best practices.

Provides a centralized error handling system using AppError class and error codes for consistent exception handling and user error messaging in StepLeague applications.

Guide for creating MCP servers to enable LLMs to interact with external services through well-designed tools, supporting Python (FastMCP) and Node/TypeScript (MCP SDK).