Skill UI

An expert architect specializing in designing, optimizing, and scaling entire data layers from inception (greenfield) to re-architecture. Proficient in selecting the optimal database technology (SQL, NoSQL, Graph, Time-series), designing robust schemas, implementing sophisticated indexing strategies, and planning complex migration paths. Suitable for defining data storage solutions that meet high performance, scalability, and data integrity requirements.

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.

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.

Automates database schema design guidance for backend projects, activating whenever you ask about schema patterns, best practices, or implementation in node.js, Python, Go, microservices, caching, or messaging contexts.

Designs normalized database schemas by analyzing requirements, mapping relationships, generating ERD diagrams, and producing SQL CREATE statements so you can build well-structured relational databases and follow best practices.

A comprehensive, end-to-end workflow bundle guiding developers through the entire software development lifecycle. It covers project scaffolding, frontend development (React/Next.js), robust backend architecture, database design, rigorous testing (TDD, E2E), code quality review, and modern CI/CD deployment practices for web and mobile applications.

This skill details best practices for handling and structuring Evernote data. It covers designing local database schemas (SQL), advanced ENML content processing (to Markdown/HTML), managing attachments, and implementing reliable incremental synchronization using Update Sequence Numbers (USN). Ideal for developers building robust applications requiring deep, local data access and integrity checks for Evernote content.

Provides a robust, event-driven reference architecture for building meeting intelligence platforms using Fireflies.ai. This guide details the full production pipeline, covering multi-source meeting ingestion (Zoom, Teams), webhook processing, and subsequent data enrichment into structured action items, analytics reports, and database storage. Ideal for designing complex integrations or advanced meeting analytics systems.

This comprehensive workflow guides the entire lifecycle of building a complex full-stack feature, from initial architectural design to final integration testing. It enforces an API-first approach, ensuring that the database schema, backend services, and frontend components are developed cohesively, promoting scalability, testability, and adherence to modern industry best practices.

Automates GraphQL resolver creation for backend teams, giving step-by-step guidance, industry best practices, and production-ready code/configs to validate resolvers across Node.js, Python, Go, database design, caching, messaging, and microservices.

This skill provides comprehensive guidance for senior-level Laravel engineering. It focuses on building production-grade, maintainable, and highly secure applications using modern architectural patterns (clean architecture, services, etc.). Use this when developing new features, refactoring complex code, designing robust APIs, or optimizing database interactions within a Laravel environment. Adheres to best practices like Eloquent optimization and proper authentication flows.

Automates designing and implementing table partitioning strategies to keep large databases performant, optimize time-series workloads, and shorten maintenance windows, with guidance on key selection, SQL scripts, and query tuning.