1. Software Development

Provides React component design patterns for Next.js 15, aiding in creation and modification of components.

Automates pull request creation using a predefined template to standardize contribution processes and improve code review efficiency.

Enables parallel code review of Git changes and tasks across multiple team members or agents.

Runs temporary Bun scripts for immediate code validation without permanent artifacts, enabling quick assumption testing and remote state inspection.

Enforces consistent coding standards for TypeScript, Vue components, and Playwright tests in the viya-app repository during code reviews and refactoring.

Guides systematic debugging of software issues, including bugs and test failures, to identify root causes before implementing solutions.

Generates type-safe React Query hooks and Prisma-like ORM clients from PostGraphile GraphQL endpoints for efficient data fetching in React applications.

Automates pull request reviews with checklist verification and release note generation to ensure code quality before merging.

Provides type-safe database schema design and query patterns for PostgreSQL using Drizzle ORM in TypeScript applications.

Automates initial development task setup by creating feature branches and generating work plans for software issues.

Facilitates API integration in viya-app with type-safe services and responses using generated API types.

Tests SQL parsing and deparse functionality in the pgsql-parser repository, validating round-trip conversions for PostgreSQL SQL.

Simplifies PostgreSQL integration testing with isolated database environments using pgsql-test for test setup and execution of database modules.

Provides expert frontend code reviews for Vue and TypeScript, ensuring quality, adherence to conventions, and best practices in pull requests.

Enables semantic code navigation including go to definition, find references, and hover for improved code comprehension and development efficiency.

Generates unit tests for Vue.js components, composables, utilities, and stores using vitest and vue-test-utils following project patterns.

Provides best practices for managing large PNPM monorepos, including package organization and workspace dependency configuration.

Blocks anti-patterns in CLI development by discouraging commander, inquirer.js, and yargs, promoting inquirerer.

AI-powered code review tool for uncommitted changes, PRs, and security scans via CLI, enhancing code quality.

Automates standardization of Git commit messages to comply with Conventional Commits specification for consistent versioning and changelog generation.

Applies clean code principles including syntax and naming conventions to ensure maintainable code across all development tasks.

Manages directory structures for CLI applications, offering config storage, caching, logging, and update checking capabilities for developers.

Publishes PostgreSQL module packages (pgpm) to npm following Constructive standards, enabling distribution of SQL modules as reusable npm packages.

Automates Git commits after CodeRabbit code review, only proceeding if review passes.