Skill UI

A comprehensive code review tool designed for C#/.NET projects. It evaluates the implementation of key design patterns (Command, Factory, Repository) and adherence to SOLID principles. The review covers architecture, best practices (async/await, logging), security, testability, and clean code principles, providing actionable recommendations for improvement.

This comprehensive guide provides a structured set of prompts to manage the entire lifecycle of upgrading a legacy .NET solution. It covers everything from initial project classification and dependency compatibility review to code modernization (e.g., async conversion), updating CI/CD pipelines, and defining robust testing and deployment strategies. Ideal for large-scale migration of older .NET applications to modern frameworks like .NET 8.

The comprehensive command-line interface (CLI) for interacting with all major features of GitHub. This tool allows developers to manage repositories, create and review pull requests, track issues, utilize Codespaces, and perform advanced organizational tasks—all directly from the terminal. It is essential for streamlining DevOps workflows and automating GitHub operations.

Audit MCP server configurations for security issues including hardcoded secrets, shell injection patterns, mutable package references, and unapproved servers. Use this skill when reviewing .mcp.json files, onboarding new MCP servers, or conducting security reviews of agent tool configurations.

A comprehensive guide and workflow for identifying behavioral risks when migrating applications from Oracle to PostgreSQL. It cross-references code against known differences in complex areas such as empty strings, refcursors, type coercion, sorting, and concurrent transaction handling. Essential for both pre-migration architectural planning and post-migration validation testing.

This advanced skill automates the enforcement of Python code quality using Ruff. It implements a controlled, iterative workflow that supports safe and unsafe automatic autofixes, formats the code, and reviews diffs after each pass. The process recursively repeats until all findings are resolved or require explicit user decision, ensuring high code consistency and quality gates.

Audits iOS app source code and metadata from an App Store reviewer perspective, identifying rejection risks, compliance issues, and optimization opportunities for faster approval.

Analyzes PostgreSQL snippets or entire projects to flag anti-patterns, enforce best practices, optimize JSONB/array usage, schema design, custom types, triggers, extensions, and security policies like RLS.

A comprehensive, multi-phase quality engineering audit tool designed to test codebases beyond standard unit tests. It first explores the codebase's domain and architecture to derive behavioral requirements, then executes a rigorous sequence including spec-traced functional tests, three-pass code reviews, and a multi-model specification audit (Council of Three). It is specifically engineered to find the critical 35% of real-world defects that structural code review alone might miss. Works with any programming language.

Acts as a senior software engineer to meticulously review and refactor entire codebases. This skill ensures that the code is clean, highly maintainable, and strictly adheres to defined coding standards and best practices specified across multiple project instruction files. It guarantees the integrity of the existing file structure and ensures all unit tests remain passing after modifications.

A universal assistant for conducting deep code reviews across major SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). It rigorously analyzes SQL code for critical vulnerabilities (like SQL injection), performance bottlenecks, maintainability issues, and adherence to industry best practices. Features include security audits, index optimization recommendations, query structure analysis, and schema design validation, ensuring robust and secure database development.

A comprehensive, five-stage methodology for reviewing code quality. This process systematically checks for requirements compliance, logical correctness, code maintainability, test coverage, and critical security/performance vulnerabilities. It provides actionable feedback categorized by severity (Blocker, Major, Minor, Nit), ensuring high standards for all merged code.