1. Software Development

Provides best practices for writing secure, efficient database queries in PostgreSQL and Firestore, preventing SQL injection and optimizing performance with ORMs and query builders.

Manages testing workflows for markdowntown, including unit, E2E, and visual tests using Playwright and test utilities.

Provides backend API route implementations, Prisma schema management, and server-side validation patterns for Next.js App Router applications.

Provides Lombok best practices for Java 21+ to reduce boilerplate, configure builders, and choose between Lombok and Records.

Automates code quality checks via Git hooks for pre-commit, pre-push, and commit message validation using tools like Husky and ESLint.

Generates structured context documentation for frontend projects by analyzing codebases, enabling AI agents to understand architecture and dependencies.

Strategically writes minimal tests for core user flows and critical paths during development, deferring edge cases until feature completion with behavior-focused testing.

Manages WebF controller lifecycle, reuse, pre-rendering, and multi-page integration safely for developers.

Enables integration with SePay and Polar payment gateways for processing transactions, subscriptions, and billing systems using supported SDKs and authentication methods.

Guides on implementing game architecture patterns, design patterns, and project structure in Unity.

Provides best practices for Unity game performance optimization, including memory management, garbage collection, and profiling techniques.

Framework-agnostic TypeScript solution for implementing authentication, authorization, session management, and secure access control in web applications.

Systematic debugging framework ensuring root cause analysis through four-phase process, call stack tracing, and validation to prevent superficial fixes.

Provides comprehensive frontend development guidelines for React/TypeScript applications, covering modern patterns, file organization, styling, routing, and performance optimization.

Guides writing meaningful code comments explaining rationale (WHY) over implementation (WHAT), emphasizing business logic, complex algorithms, and self-documenting code.

Debugs React Native apps via Metro bundler by reading logs and executing JavaScript for crash, state, and API issue diagnosis.

Detects and refactors ORM code smells in Quarkus Panache applications, addressing N+1 queries and data overfetching.

Defines database models and schemas for PostgreSQL (Supabase/Bun.sql) and Firestore (Firebase) with data types, relationships, and constraints ensuring data integrity and performance.

Guide for building MCP servers to enable LLMs to interact with external APIs/services using Python (FastMCP) or Node/TypeScript (MCP SDK).

Guides on Unity lifecycle methods, serialization, component references, and prefab workflows for efficient game development implementation.

Enforces project-wide conventions for structure, documentation, version control, and security to ensure consistent development practices.

Guides structuring React 19+ components with top-down organization, single responsibility, and modern patterns for improved readability and maintainability.

Enables development of robust backend systems using modern technologies, frameworks, and security practices for APIs, databases, and scalability.

Plans scalable, secure, and maintainable technical solutions for software development projects.