Skill UI

A structured playbook for improving the time and space complexity (Big-O) of existing, slow code. This skill guides developers through systematic refactoring, focusing on identifying bottlenecks like nested loops or N+1 queries. It emphasizes applying transformations one at a time, maintaining test coverage, and measuring performance gains to ensure correct and efficient code.

This skill enforces an algorithm-first discipline, requiring the user to state the time and space complexity (Big-O), the intended data structure, and the core algorithm family before writing any complex code (loops, queries, recursion). It serves as a critical gatekeeper to prevent common performance pitfalls like O(n²) complexity, N+1 database queries, and brute-force implementation errors, significantly improving code robustness and efficiency.

This skill is a comprehensive tool for managing and understanding SQL queries. It can explain complex SQL in plain English for non-technical stakeholders, optimize slow queries by identifying performance bottlenecks, generate functional SQL code from natural language prompts, and produce detailed query documentation and data dictionaries. Supports major dialects including PostgreSQL, MySQL, and BigQuery.

This skill provides advanced threat hunting queries for Microsoft Sentinel/Log Analytics. It detects the behavioral and string fingerprints left by popular offensive Entra ID enumeration tools (like ROADtools, AADInternals, and AzureHound) within both MicrosoftGraphActivityLogs and AADGraphActivityLogs. Use this when investigating suspicious Graph API activity, identifying internal reconnaissance, or building detection rules to surface active intrusions.

A comprehensive tool for authorized red-team engagements, designed to map complex on-prem Active Directory and cloud Entra ID attack paths. It uses SharpHound and AzureHound to collect rich data, ingesting it into BloodHound CE for analysis using built-in queries and custom Cypher. Effectively identifies privilege escalation chains leading to domain or tenant compromise, especially in hybrid identity environments.

This guide details best practices for implementing robust, type-safe GraphQL queries and mutations. It covers using separate .gql files, running code generation tools, and implementing mandatory error handling (onError) and loading states. Use this when building complex, reliable data fetching layers with Apollo Client.

A comprehensive skill to diagnose and fix excessive Postgres egress (network data transfer) that leads to high cloud database bills. It guides the user through using `pg_stat_statements` to identify the most data-intensive queries. Key fixes include limiting selected columns (avoiding SELECT *), implementing pagination (LIMIT/OFFSET), and identifying high-frequency data sources for caching.

This comprehensive guide serves as a detailed reference for psql, the feature-rich interactive terminal for PostgreSQL. It covers connection methods (CLI flags, environment variables, ~/.pgpass), executing SQL queries, inspecting database objects using commands like \d, and managing data operations such as importing and exporting.

Pi-hole is a powerful, network-wide DNS ad blocker that runs on Linux hosts (like Raspberry Pi). It intercepts all DNS queries on your local network, blocking advertisements, trackers, and known malware domains before they reach your devices. This guide covers setup via Docker or bare metal, configuring network DNS, managing blocklists, and enabling secure DNS-over-HTTPS (DoH) for enhanced privacy.

A comprehensive guide to building robust database layers in Kotlin using the Exposed ORM framework. It covers advanced patterns including DSL queries, DAO entity management, transaction handling, connection pooling with HikariCP, schema migration via Flyway, and implementing the Repository pattern for clean, production-grade data access.

A comprehensive guide covering production-level patterns and common pitfalls for using Prisma ORM in TypeScript backends. Learn best practices for schema design, optimizing queries using select/include, managing complex transactions, implementing singleton patterns, and mitigating issues in serverless environments and bulk operations.

This skill maps clinical concept spans (disorders, anatomy, procedures, etc.) extracted by OpenMed to SNOMED CT concept IDs (SCTID). It performs complex, out-of-process terminology resolution using standard FHIR R4 endpoints ($lookup, $translate, ValueSet/$expand) against a user-supplied, licensed terminology server (e.g., Ontoserver, UTS). Ideal for generating rich, hierarchy-aware clinical codes, performing subsumption queries (ECL), or translating codes between clinical standards (like ICD-10 to SNOMED CT).