1. Software Development

Systematically reviews code against CodeSpirit standards, checking security, database usage, async patterns, and architectural components for quality assurance.

Guides database migration creation for MySQL and SQL Server using database-specific DbContext, handling schema differences and Snowflake ID configuration.

Performs pre-commit code validation including static analysis, runtime error checks, and functional tests to ensure code quality before integration.

Enforces Solana and Anchor framework best practices in TypeScript, ensuring clean code with proper naming, no magic numbers, and correct syntax.

Configures Sanity Visual Editing for front-end frameworks, enabling live preview and click-to-edit functionality.

Configures and troubleshoots Sanity TypeGen to generate accurate TypeScript types from Sanity schemas, resolving missing or incorrect type issues.

Installs Sanity editor rules into a local project, enabling immediate setup of a new Sanity editor environment for content management development.

Automates creation of Sanity CMS content types using best-practice templates, streamlining schema development for new content structures.

Manages Sanity schema lifecycle with scaffolding, safe field deprecation, and data migrations for schema modifications.

Coordinates essential application setup including logging, error handling, CORS, health checks, and API documentation.

Sets up linters, pre-commit hooks, and test infrastructure to maintain code quality in development workflows.

Checks code for adherence to DRY, KISS, YAGNI, and architectural guidelines in implementation tasks, reporting issues without altering task states.

Automates .NET NuGet package upgrades with intelligent handling of breaking changes to maintain project stability.

Automates configuration of ESLint, Prettier, Ruff, and .NET analyzers to enforce consistent code quality and style standards.

Performs architectural quality audits on codebases, checking DRY, KISS/YAGNI compliance, layer breaks, error handling, and DI patterns. Provides severity-ranked findings with recommendations.

Coordinates migration of project structure to Clean Architecture, ensuring separation of concerns and maintainable codebase.

Automates dependency upgrades for npm, yarn, and pnpm while handling breaking changes to maintain project stability.

Automates creation of .NET Clean Architecture backend structure from entity definitions, accelerating backend development workflows.

Audits test suites for isolation, determinism, and anti-patterns to improve test reliability and reduce flakiness.

Configures global middleware for consistent exception handling across application endpoints, ensuring standardized error responses.

Runs existing tests to detect regressions, auto-detects framework, and reports pass/fail without modifying project state.

Orchestrates end-to-end test planning pipeline from research to manual and automated testing phases, coordinating related test skills.

Audits tests to identify and flag framework/library validation (e.g., Prisma, Express) instead of business logic, recommending removal for improved test quality.

Generates and configures Swagger/OpenAPI documentation for RESTful APIs, ensuring standardized and developer-friendly API specifications.