Skill UI

This skill simulates a world-class Senior System Design Engineer with 20+ years of experience at top tech companies. It helps users design, review, and scale complex, highly available, and resilient distributed systems. It covers every aspect from database sharding and microservices decomposition to caching strategies, observability stacks, and CI/CD pipelines, providing detailed blueprints and mathematical scaling estimates.

A comprehensive reference guide providing quantitative benchmarks and formulas for system architects. It covers user-to-RPS conversion, storage estimation, bandwidth calculation, known scale limits of major technologies (databases, queues, caches), and capacity planning for various user loads (1K DAU to 10M DAU). Essential for designing scalable, high-availability applications.

This skill generates comprehensive, production-ready database schema documents. It covers Entity-Relationship (ER) diagrams, detailed SQL DDL definitions, constraint analysis, index strategies, and access pattern optimization. Use it when designing a new database, documenting an existing one, or modeling complex data relationships for engineering review.

A comprehensive Notion dashboard designed for real-time team operations and performance tracking. It provides a centralized overview by aggregating Key Performance Indicators (KPIs) in a grid format, displaying 7-day trend sparklines, showing live activity feeds, and summarizing tasks in a structured database table. Ideal for project managers and team leads who need a single source of truth for project status and team coordination.

A comprehensive guide covering scalable backend architecture patterns, including Repository, Service, and Middleware design. It details best practices for building robust APIs using Node.js, Express, and Next.js. Topics covered include RESTful API structuring, database query optimization (preventing N+1 issues), implementing database transactions, and integrating caching strategies like Redis. This guide is essential for developing high-performance, maintainable server-side applications.

Flox is a declarative, Nix-based environment manager designed to create perfectly reproducible development environments. It handles system-level dependencies (like compilers, databases, and native libraries) and ensures that complex toolchains across multiple languages (Python, Node.js, Go, etc.) function identically across macOS and Linux. Ideal for solving 'works on my machine' issues and onboarding new team members instantly.

A comprehensive guide to PostgreSQL best practices, covering advanced indexing (GIN, BRIN, Partial), schema design, performance tuning, and security implementation (RLS). It details optimizing common SQL patterns like cursor pagination and UPSERT, essential for building high-performance, reliable database systems.

Provides a structured workflow for systematically accessing and analyzing official intellectual property data from the USPTO. This skill covers patent search (PatentSearch API), trademark status checks (TSDR), ownership transfer tracking, and building reproducible IP landscape logs. It is designed for data collection and record verification, emphasizing the use of official APIs and rigorous logging practices. (Warning: Not for legal advice.)