Skill UI

A comprehensive skill for designing, optimizing, and migrating complex database schemas. It provides expert-level analysis covering normalization (1NF to BCNF), advanced indexing strategies, and zero-downtime migration patterns. Use this skill to model data relationships, choose between SQL and NoSQL, or restructure existing databases for maximum performance and scalability.

Specializes in generating production-grade SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, and SQL Server. Provides comprehensive plans covering data integrity, detailed rollback procedures, performance optimization, and validation checks for critical schema changes.

A comprehensive guide detailing optimization techniques for Databricks environments. It covers optimal cluster sizing for various workloads (ETL, ML, Streaming), advanced Spark configurations (AQE, memory management), and deep data optimization strategies for Delta Lake, including Z-Ordering and Liquid Clustering. It also provides methods for query plan analysis and join optimization.

A comprehensive checklist and guide for deploying Deepgram integrations into a production environment. It covers critical areas including robust authentication practices, system resilience design (e.g., backoff strategies, circuit breakers), performance optimization (singleton clients, audio preprocessing), security measures (PII redaction), and mandatory monitoring setup (Prometheus metrics and alert rules). Essential for any go-live phase.

A comprehensive, step-by-step checklist for deploying Documenso integrations to a live production environment. This guide covers critical aspects of security, reliability, error handling, performance optimization, and compliance readiness, ensuring a smooth and stable go-live process.

An expert guide for designing, building, and optimizing high-performance, enterprise-grade backend systems using the .NET ecosystem. Covers advanced C# features, ASP.NET Core microservices, data access patterns (EF Core/Dapper), Clean Architecture, DDD, and crucial performance considerations like caching and optimization. Ideal for architects needing to ensure scalable, maintainable, and testable production-ready APIs.

This guide details how to configure and manage the Exa search API across development, staging, and production environments. It ensures API key isolation, implements environment-specific search limits, and provides strategies for cost control and performance optimization by utilizing caching layers like Redis. Essential for scalable, multi-stage deployments.

A comprehensive expert resource for building high-performance, async-first APIs using FastAPI, SQLAlchemy 2.0, and Pydantic V2. Covers advanced topics like microservices architecture, WebSockets, advanced security (OAuth2, RBAC), robust testing strategies (pytest), performance optimization, and modern DevOps practices (Docker, Kubernetes). Ideal for mastering scalable, production-ready Python web services.

This expert guides the development of high-performance, cross-platform mobile applications using Flutter 3+ and Dart. It covers best practices for state management (Riverpod, Bloc), UI widget creation, navigation (GoRouter), performance optimization, and thorough testing (unit/widget tests).

Guides React Server Components workflows, streaming SSR, code splitting, bundle/image/font optimizations, and Core Web Vitals monitoring to keep Next.js frontends fast and responsive.

This skill guides the full lifecycle of game development, from architecture design (ECS, component systems) to high-performance implementation. It covers integrating Unity/Unreal Engine features, implementing complex physics, multiplayer networking with lag compensation, and achieving consistent 60+ FPS performance. Key techniques include object pooling, state machines, and rigorous profiling to ensure production-ready, scalable game systems.

A comprehensive, multi-stage checklist designed to ensure that any third-party or internal integration is robust, secure, and fully functional before being deployed to a live production environment. It covers critical areas including API security, error handling, performance optimization, monitoring setup, and disaster recovery planning.