Skill UI

This comprehensive guide outlines the end-to-end process of building production-grade ETL data pipelines using Databricks and Delta Lake. It implements the robust Medallion Architecture (Bronze, Silver, Gold) for scalable data management. Techniques covered include Auto Loader for incremental streaming ingestion, MERGE INTO for upsert semantics, data cleansing, and advanced aggregation into analytics-ready layers. Ideal for establishing reliable data pipelines in a data lakehouse environment.

This skill provides a comprehensive guide on implementing robust data governance patterns within Delta Lake, leveraging Unity Catalog. It covers essential compliance topics such as data classification tagging, handling GDPR 'right-to-deletion' requests for PII, and establishing automated data retention policies. Use this when designing secure, compliant, and auditable data pipelines in a data lake environment.

This skill provides comprehensive principles for developing multiplayer games, covering essential topics from networking architecture (Dedicated, P2P, Host-based) to advanced synchronization techniques. It details how to handle latency via prediction, interpolation, and lag compensation, optimize bandwidth using delta compression, and implement robust security measures like server authority and anti-cheat systems. Ideal for developers building real-time online experiences.

A powerful skill for conducting structured, systematic code reviews for PRs and MRs. It goes beyond basic style checks, performing deep analysis such as blast radius tracing, comprehensive security scanning (SQLi, XSS, secrets), detecting breaking changes in APIs/DB schemas, and calculating test coverage delta. Ideal for reviewing large, complex, or security-sensitive code changes before merging.

Conducts STRIDE-A threat modeling on repositories or systems, running either a full single-pass analysis with architectures, DFDs, prioritized findings, and executive assessments, or an incremental update that compares a baseline report to the current code and highlights deltas.

This skill provides comprehensive strategies to optimize resource usage and mitigate rate limits when integrating with the OneNote Graph API. It focuses on reducing the operational 'cost' of making API calls by implementing metadata caching (TTL), utilizing JSON batch requests, and performing delta synchronization instead of full list fetches. Essential for high-volume, stable OneNote enterprise integrations.

This utility addresses the lack of webhooks for OneNote resources. It implements an efficient change detection mechanism by performing timestamp-based polling and delta query comparisons against the Microsoft Graph API. It is essential for building real-time synchronization, change monitoring, or event-driven integrations for OneNote, while carefully managing API rate limits.

This utility conducts a thorough audit of project documentation against the current codebase to ensure complete consistency. It supports 'delta' (detecting changes since merge-base) or 'full' auditing modes. By utilizing Impact Mapping and verifying cross-reference pairs, it identifies outdated specs, missing documentation, or inconsistent references across the entire project ecosystem.

A comprehensive guide to exploiting PHP's loose type checking (using '==') and type juggling mechanics. This skill is crucial for bypassing security controls like authentication checks, HMAC/signature validations, and token comparisons that fail to use strictly typed comparisons (===) or timing-safe functions (hash_equals). Includes techniques for magic hash collisions and PHP version delta analysis.

A comprehensive guide for integrating Microsoft Graph SDK into applications. It covers accessing Microsoft 365 data (users, mail, calendar, Teams, SharePoint) from various languages (.NET, Python, TypeScript). Key topics include robust authentication patterns (Managed Identity, OBO), advanced data retrieval techniques like pagination, delta queries, batch requests, and setting up change notifications via webhooks. Learn best practices for secure and efficient API interaction.

Code Health MCP provides structural maintainability feedback and design-level health scores, going beyond standard linting. It is crucial for AI-assisted coding workflows, allowing users to review code quality, verify score deltas after changes, and gate commits or pull requests to prevent codebase regression. Use it when refactoring, updating legacy modules, or ensuring the integrity of large diffs.

This tool detects cost regressions by comparing two cost-summary JSON snapshots (baseline vs. current). It is essential for PR-gate workflows, checking for unexpected spending increases using three orthogonal signals: total percentage change, absolute dollar increase, and disproportionate growth in specific token classes (e.g., cache writes).