Skill UI

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 tool that analyzes complex codebases to generate detailed, structured architectural blueprints. It automatically detects and documents the entire technology stack, including primary languages (.NET, Java, Python, etc.), dependencies, versions, licensing, and implementation patterns. The output provides actionable documentation covering coding conventions, usage examples (API, data access), and visual architecture maps, ensuring consistency across guided software development projects.

A comprehensive methodology for pinpointing the root cause of complex bugs, regressions, or unexpected behavior in large codebases. Techniques include binary search debugging, Git bisect for tracking regressions across commits, strategic data/control flow logging, component isolation, and advanced breakpoint strategies (conditional breakpoints, watch expressions). Ideal for scenarios where the bug source is unclear or difficult to reproduce.

This comprehensive guide serves as a technical reference for migrating applications from the Universal Windows Platform (UWP) framework to the modern WinUI 3 / Windows App SDK. It details crucial API changes, including namespace updates, window management (CoreWindow to AppWindow), threading models (CoreDispatcher to DispatcherQueue), and best practices for dialogs and background tasks. Essential for developers updating legacy UWP codebases.

Pymatgen is a comprehensive Python toolkit designed for computational materials science. It enables users to create, analyze, and manipulate complex crystal structures, calculate electronic properties (DOS, band structures), simulate phase transitions, and interact with large material databases like the Materials Project. Ideal for solid-state physics, chemistry, and advanced materials research.

This skill provides a comprehensive workflow for integrating external data sources into the Glean enterprise search platform. It covers setting up custom datasources, performing high-volume bulk document indexing using the Indexing API, and granularly managing document permissions (read/write access) to ensure accurate and secure search results for large organizations. Ideal for data engineers and developers building internal knowledge bases.

This professional guide provides a comprehensive, production-ready, layered architecture blueprint for building complex HubSpot CRM integrations. It details the project structure, service abstraction, error handling, and webhook processing patterns. Use this when designing new HubSpot integrations, reviewing existing codebases, or establishing robust architectural standards for enterprise applications.

This comprehensive guide provides a production-ready reference architecture for implementing scalable search using Algolia. It details best practices for index design (including multi-index strategies), establishing robust data pipelines from source databases, structuring the service layer (search, indexing, settings), and integrating the frontend for optimal performance.

This guide details how to use sophisticated coding agents (such as Codex, Claude Code, or Pi) through a structured bash workflow. It provides methods for complex development tasks, including building new features, refactoring large codebases, and reviewing pull requests (PRs). Key best practices covered include managing pseudo-terminals (PTY), defining focused working directories (`workdir`), and executing tasks in the background for robust, multi-step automation.

This skill guides users through setting up robust, production-grade infrastructure on Fly.io. It covers creating and connecting to Fly Postgres clusters for reliable data storage, provisioning persistent NVMe Volumes for durable file storage, and configuring private internal networking (6PN) for secure service-to-service communication. It is essential for modern microservices requiring stable databases and persistent state.

This guide provides comprehensive strategies to significantly boost the performance and reliability of applications deployed on Fly.io. Techniques covered include eliminating cold starts (auto-stop/start), right-sizing Virtual Machines based on workload demands, implementing multi-region deployment for low latency, and optimizing connection pooling for databases. Essential for scaling modern SaaS applications.

This plugin allows developers to build Framer components by syncing data from external data sources (such as APIs or databases) into Framer's Managed Collections. It serves as the primary integration pattern, handling both schema creation and item population. Use this when your design requires displaying dynamic content driven by external systems.