Design and implement RESTful API endpoints following REST principles with clear resource-based URLs and appropriate HTTP methods. Use this skill when creating API routes, defining API endpoints, implementing HTTP request handlers, working on route files (routes.ts, route.ts, api/*, controllers/*, handlers/*), building REST APIs, designing API versioning strategies, setting up query parameters for filtering and pagination, implementing rate limiting, or returning appropriate HTTP status codes. Apply this skill when structuring backend API architecture, creating new API endpoints, refactoring existing endpoints, or reviewing API design for consistency and best practices.
Create and manage database migrations following best practices for schema changes and data migrations. Use this skill when creating database migration files, modifying database schemas, adding or removing tables and columns, working with migration files (prisma/migrations/*, db/migrate/*, migrations/*), implementing reversible migrations with rollback methods, managing database indexes, handling zero-downtime deployments, separating schema changes from data migrations, or ensuring backwards compatibility during schema updates. Apply this skill when setting up new database tables, altering existing database structures, creating migration scripts, or reviewing migration safety and rollback strategies.
Define and structure database models with proper naming conventions, data integrity constraints, and relationship definitions. Use this skill when creating or modifying database model files, defining table schemas, setting up model relationships (one-to-many, many-to-many, one-to-one), working with ORM model files (schema.prisma, models/*, app/models/*, entities/*), implementing data validation at the model level, adding timestamps and audit fields, defining foreign keys and indexes, choosing appropriate data types, configuring cascade behaviors, or balancing database normalization with query performance. Apply this skill when designing database schemas, creating new models, refactoring existing model structures, or reviewing data integrity and relationship configurations.
Write optimized and secure database queries using parameterized queries, eager loading, and proper indexing strategies. Use this skill when writing database queries, constructing SQL statements, using ORM query methods, implementing data fetching logic, preventing SQL injection attacks, optimizing query performance, avoiding N+1 query problems, selecting specific columns instead of all data, implementing transactions for related operations, setting query timeouts, caching expensive queries, or working with WHERE clauses, JOINs, and ORDER BY statements. Apply this skill when fetching data from databases, optimizing slow queries, refactoring data access code, or reviewing query security and performance.
Build accessible user interfaces using semantic HTML, ARIA attributes, keyboard navigation, and proper color contrast. Use this skill when creating or modifying UI components, implementing forms and interactive elements, working with navigation menus, building modals and dialogs, adding images and media content, writing JSX/HTML markup, ensuring keyboard accessibility, testing with screen readers, managing focus states, implementing proper heading hierarchies, providing alternative text for images, maintaining color contrast ratios, using ARIA labels and roles, or ensuring all interactive elements are keyboard-navigable. Apply this skill when building frontend components, reviewing UI accessibility, refactoring markup for better semantics, or implementing WCAG compliance requirements.
Design and build reusable, composable UI components following single responsibility principle with clear interfaces and proper state management. Use this skill when creating React components, Vue components, or other framework components, defining component props and interfaces, managing component state, building reusable UI elements, working with component files (*.tsx, *.jsx, *.vue, *.svelte, components/*, ui/*), implementing component composition patterns, encapsulating component logic, documenting component APIs, keeping state local or lifting it up when needed, designing component hierarchies, or refactoring monolithic components into smaller pieces. Apply this skill when building new components, refactoring existing component structures, reviewing component design patterns, or ensuring components are maintainable and reusable.
Write and maintain CSS following project conventions using consistent methodologies like Tailwind CSS, BEM, CSS modules, or utility classes, while creating distinctive, aesthetically excellent designs. Use this skill when writing CSS styles, applying Tailwind utility classes, creating custom CSS, working with styling files (*.css, *.scss, *.module.css, globals.css, tailwind.config.*), maintaining design systems and design tokens, defining CSS variables for colors and spacing, implementing typography styles with unique font choices, creating atmospheric backgrounds and depth, adding animations and micro-interactions, avoiding framework style overrides, avoiding generic "AI slop" aesthetics (purple gradients, Inter/Roboto everywhere, cookie-cutter designs), optimizing CSS for production with purging and tree-shaking, or ensuring consistent styling patterns across the application. Apply this skill when styling components, refactoring CSS code, setting up design systems, choosing fonts and colors, creating animat
Build responsive layouts that adapt seamlessly across devices using mobile-first design, fluid layouts, and standard breakpoints. Use this skill when implementing responsive designs, creating mobile-first layouts, defining breakpoint styles, working with responsive components and pages, using relative units (rem, em) instead of fixed pixels, implementing media queries, ensuring touch-friendly tap targets, optimizing images and assets for different screen sizes, maintaining readable typography across breakpoints, prioritizing content for smaller screens, testing UI across mobile, tablet, and desktop devices, or building fluid container layouts. Apply this skill when building responsive UI components, optimizing layouts for different screen sizes, or reviewing mobile and tablet user experiences.