Skill UI

This skill provides a comprehensive guide for building scalable Retrieval-Augmented Generation (RAG) pipelines and persistent agent memory using Pinecone as the vector database. It covers index setup, embedding large corpuses, implementing dense and hybrid semantic search, and advanced metadata filtering for real-world production systems. Use this for building searchable knowledge bases and context-aware AI agents.

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.

A comprehensive guide detailing the selection criteria for core modern system components, including databases (SQL/NoSQL), caching, message queues, and API protocols. It helps architects choose the optimal technology for specific use cases, scalability needs, and architectural patterns.

This skill generates a comprehensive, safe, and zero-downtime database migration plan for schema changes. It utilizes the industry-standard expand/contract pattern to ensure backward compatibility, detailing multiple phased steps (Expand, Backfill, Contract), necessary SQL scripts, robust rollback procedures, and detailed deployment runbooks. Essential for maintaining application availability during large-scale database updates.

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.