Skill UI

This guide outlines architectural patterns and best practices for building scalable, production-ready APIs with FastAPI. It covers proper project structure, separating concerns using routers, services, and CRUD layers, implementing dependency injection for database sessions and authentication, defining Pydantic schemas for request/response, handling asynchronous operations, and managing custom error responses.

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.

This tool outlines the complete end-to-end migration process from an Oracle database environment to SQL Server. It automates schema conversion, data migration, and generates necessary assessment reports by simulating SSMA console operations. Ideal for database architects and developers planning heterogeneous database migrations.

This skill generates comprehensive Entity Relationship Diagrams (ERDs) and database schemas as D2 source code from an existing Entity Framework Core codebase. It analyzes DbContexts, DbSet declarations, Fluent API mappings, and migrations to accurately visualize tables, columns, primary/foreign keys, relationships (including many-to-many joins), owned types, and constraints. The output is a structured .d2 file, suitable for rendering into SVG or PNG, helping developers document the persistence model.

This skill enforces an algorithm-first discipline, requiring the user to state the time and space complexity (Big-O), the intended data structure, and the core algorithm family before writing any complex code (loops, queries, recursion). It serves as a critical gatekeeper to prevent common performance pitfalls like O(n²) complexity, N+1 database queries, and brute-force implementation errors, significantly improving code robustness and efficiency.

This skill captures and persists critical user decisions, project constraints, and architectural choices across multiple sessions and agents. It saves this context into a structured memory database (`mdbase`), ensuring that future development steps or agents can retrieve the original intent without re-deriving it from scratch. Ideal for documenting project rules, tech stacks, and design rationale.

Use the composio CLI to orchestrate complex, end-to-end product releases across multiple services: Stripe for billing updates, Supabase for database migrations, and Vercel for frontend deployments. This single pipeline ensures that billing models, database schemas, and user interfaces are consistently updated in the correct sequence, guaranteeing reliable full-stack product launches.

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.