Explore

Analyze and optimize a slow database query with EXPLAIN plan analysis.

Extract a reusable, well-typed component from existing code with proper interface design and documentation.

Break down a complex, hard-to-read function into smaller, well-named, testable functions with clear responsibilities.

Restructure code to be more testable by applying dependency injection, interface segregation, and separation of concerns.

Systematically debug a runtime error by analyzing the error message, stack trace, and surrounding code to find the root cause and fix.

Trace data through a system to find where it diverges from expected behavior, identifying the exact transformation or handoff that introduces the bug.

Find and fix memory leaks by analyzing code patterns, symptoms, and environment for common leak sources.

Review an authentication implementation for security vulnerabilities covering session management, token handling, password policies, and attack vectors.

Generate comprehensive API documentation including endpoint descriptions, request/response schemas, authentication, and examples.

Review API endpoint security covering authentication, authorization, input validation, rate limiting, and data exposure.

Review project dependencies for known vulnerabilities, outdated packages, and supply chain risks.

Review a system architecture for scalability, reliability, maintainability, and alignment with requirements.

Perform a thorough, multi-dimensional review of a pull request covering correctness, security, performance, naming, test coverage, and edge cases.

Draft a complete technical design document covering problem statement, proposed solution, alternatives, risks, and implementation plan.

Analyze and optimize slow database queries using EXPLAIN output, schema analysis, and query rewriting techniques.

Analyze and reduce JavaScript bundle size by identifying large dependencies, code splitting opportunities, and tree shaking improvements.

Write comprehensive unit tests covering happy paths, error cases, edge cases, and boundary conditions.

Write integration tests that verify the interaction between multiple components, services, or modules.

Write end-to-end test scenarios that simulate real user interactions through the full application stack.

Generate complete CRUD API endpoints for an entity with validation, error handling, pagination, and database integration.

Generate a complete React component with TypeScript types, accessibility, styling, tests, and Storybook stories.

Convert JavaScript code to TypeScript with proper type definitions, strict mode compliance, and incremental adoption strategy.