Skill UI

A comprehensive guide to PostgreSQL best practices, covering advanced indexing (GIN, BRIN, Partial), schema design, performance tuning, and security implementation (RLS). It details optimizing common SQL patterns like cursor pagination and UPSERT, essential for building high-performance, reliable database systems.

This skill transforms you into an expert design system guideline author, specializing in creating structured, implementation-ready documentation for the Power brand. It provides a comprehensive workflow covering style foundations (color, typography, spacing), component anatomy, accessibility standards (keyboard-first, high contrast), and quality gates. Use it to ensure all digital products maintain superior aesthetic consistency, usability, and accessibility.

A comprehensive guide covering advanced patterns, common pitfalls, and optimization techniques for using Prisma ORM in TypeScript backend applications. Learn best practices for schema design, handling transactions, optimizing queries (include vs select), and managing connection pools in production environments.

A comprehensive template providing full-stack development guidelines and best practices. This guide details the architecture (Next.js, FastAPI), file structure, common coding patterns (API response handling, state management hooks), and structured methods for integrating AI models (e.g., Claude). Use this template when starting a complex, multi-service application project.

This guide provides a comprehensive workflow for searching and retrieving biomedical literature from PubMed and NCBI. It covers advanced query construction using MeSH terms and specific field tags, advanced filtering (date, publication type), and a repeatable programmatic workflow using NCBI E-utilities (esearch, efetch). Essential for researchers conducting systematic reviews and literature monitoring.

A comprehensive guide to writing robust, efficient, and maintainable Python applications. Covers core principles like readability, explicit coding, and EAFP (Easier to Ask Forgiveness than Permission), advanced features like modern type hinting, context managers, and sophisticated exception handling techniques.

Master professional Python testing practices using the pytest framework. This guide covers Test-Driven Development (TDD) methodology, advanced features like fixtures (with different scopes), parametrization, assertion techniques, and achieving high code coverage, ensuring robust and maintainable software.

This skill provides guidance on implementing common architectural patterns and best practices within the PyTorch framework. It is designed for developers building sophisticated deep learning models, helping to improve structure, efficiency, and code maintainability when working with neural networks.

A comprehensive guide to architectural patterns for building cloud-native, event-driven microservices using Quarkus 3.x. Covers RESTful API design with JAX-RS, implementing event messaging with Apache Camel and RabbitMQ, structured data access using Hibernate Panache, managing transactions, and advanced logging context handling (MDC). Ideal for developers building robust, scalable, and maintainable enterprise systems.

This comprehensive guide covers security best practices for building robust Quarkus applications. It details how to implement secure authentication (JWT, OIDC), role-based authorization (RBAC), robust input validation (Bean Validation), and advanced protection against vulnerabilities like SQL injection and CSRF. Essential for securing resource access and managing application secrets.

A comprehensive guide to Test-Driven Development (TDD) for Quarkus 3.x LTS, focusing on event-oriented architectures. This framework utilizes JUnit 5, Mockito, REST Assured, Apache Camel, and JaCoCo to ensure high code coverage (80%+). Use it when developing new features, fixing bugs, or refactoring event-driven services and API endpoints.

This comprehensive guide outlines a multi-stage verification pipeline for Quarkus applications. It covers build artifacts, static analysis (Checkstyle, SonarQube, PMD), comprehensive testing (Unit, Integration, API), security scanning (OWASP, dependency checks), native compilation, and performance testing (K6). Use this before PRs or deployments to ensure code quality and stability.