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, expert-level skill for designing, analyzing, and optimizing robust database schemas. It covers normalization, index tuning, choosing between SQL/NoSQL, and implementing zero-downtime data migrations. Provides systematic workflows for schema analysis, performance modeling, and advanced SQL pattern generation.

A specialized skill for optimizing database performance and scalability across PostgreSQL and MySQL. It guides users through analyzing slow queries, interpreting execution plans (EXPLAIN ANALYZE), designing optimal indexing strategies, tuning configuration parameters, and resolving bottlenecks like lock contention. Essential for DevOps engineers, database administrators, and backend developers.

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.