Database

Adversarial implementation review methodology that validates code completeness against requirements with fresh objectivity. Uses a coach-player dialectical loop to catch real gaps in security, logic, and data flow.

Design, document, and test APIs following RESTful principles, consistent

Design software systems with sound architecture — choosing patterns, defining boundaries,

Perform deep, actionable code reviews covering bugs, security vulnerabilities,

Optimize database performance through indexing strategies, query optimization,

Design database schemas, optimize queries, plan migrations, and develop indexing

Methodical debugging — reproduce, isolate, root-cause, and fix bugs using systematic

Design and implement CI/CD pipelines, Docker configurations, infrastructure-as-code,

Write clear, comprehensive technical documentation — API references, READMEs, architecture

Convert mistakes into executable rules using a structured error-to-rule system.

Comprehensive NestJS best practices covering architecture, dependency injection,

Profile, identify bottlenecks, and optimize application performance across the full

Systematically refactor code using safe transformation patterns — improving structure,

Perform comprehensive security audits covering OWASP top 10 vulnerabilities, dependency

Generate secure, optimized SQL queries with proper parameterization, input

Auto-generate comprehensive test suites — unit tests, integration tests, and end-to-end

Apply version control best practices for branching strategies, commit hygiene,