Skill UI

A comprehensive guide to modern backend development patterns for scalable server-side applications using Node.js, Express, and Next.js. Covers API design (RESTful), data access patterns (Repository, Service Layer), database optimization (N+1 prevention, Transactions), and advanced caching strategies (Redis, Cache-Aside). Essential for building robust, high-performance APIs.

Documenting backend architecture patterns, API design, database optimization, caching, and error-handling best practices tailored for scalable Node.js, Express, and Next.js API routes.

This guide provides comprehensive patterns and best practices for working with ClickHouse, a high-performance OLAP database. It covers advanced topics such as MergeTree engine design, efficient query optimization (filtering, aggregations, window functions), bulk/streaming data ingestion, materialized view creation, and performance monitoring techniques, ensuring optimal performance for large-scale analytical workloads.

Guides ClickHouse database architects through schema designs, query optimization, ingestion strategies, and monitoring techniques tailored for high-performance analytical workloads.

This comprehensive workflow guides the entire database lifecycle, from initial architecture design (covering both SQL and NoSQL) to advanced implementation, optimization, and maintenance. It covers crucial stages like schema design, implementing migrations, optimizing query performance, developing robust data pipelines (using tools like Airflow and dbt), and managing data quality and operations. Ideal for engineers building complex, production-grade data systems.

Provides a practical checklist and principles for designing database schemas, indexing strategies, query optimization, and migration planning for both SQL and NoSQL systems, plus guidance on spotting and fixing N+1 issues and denormalization trade-offs.

This skill provides expert-level database design capabilities, including schema analysis, normalization, and index optimization. It assists architects and developers in creating scalable, performant, and maintainable database structures. Features include automated ERD generation, migration planning with zero-downtime strategies, and security best practices. Ideal for SQL and NoSQL environments.

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.

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 skill guides the development of production-grade APIs, MCP servers, and enterprise backends using modern C#/.NET best practices. It covers essential architectural components such as dependency injection (DI), advanced caching strategies (e.g., Redis), data access optimization with EF Core/Dapper, and implementing resilience patterns, ensuring robust and scalable software design.

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.