Skill UI

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.

This skill performs a comprehensive security audit of Model Context Protocol (MCP) server configurations found in .mcp.json files. It is designed to identify critical vulnerabilities, including hardcoded secrets (API keys, tokens), dangerous shell injection patterns, unpinned dependencies, and compliance issues regarding approved server lists. Use this skill during security reviews, project onboarding, or pre-commit checks to ensure secure deployment.

A comprehensive guide and checklist for identifying potential risks when migrating database applications from Oracle to PostgreSQL. It systematically cross-references code and migration artifacts against known behavioral differences, covering issues such as empty string handling, refcursors, type coercion, sorting logic, and timestamp semantics. Use this tool during the planning phase to proactively mitigate risks, or during validation to ensure comprehensive integration test coverage for the new PostgreSQL environment.

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.

This specialist simulates the role of an App Store reviewer, auditing iOS source code and metadata against Apple's strict guidelines. It systematically identifies potential compliance risks, technical vulnerabilities, monetization gaps (IAP/Subscriptions), and critical UX shortcomings, delivering a prioritized risk register for fast 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.

This skill systematically reviews test code to identify and correct common anti-patterns. It detects issues such as flaky tests, overly mocked dependencies (over-mocking), brittle assertions, excessive test size (The Giant), and structural dependencies. It explains the flaw, provides best practices, and suggests refactored, reliable implementations, helping maintain high test quality and stability.