Skill UI

A comprehensive guide to modern backend development patterns for scalable server-side applications using Node.js, Express, and Next.js. Covers API design (RESTful), data access patterns (Repository, Service Layer), database optimization (N+1 prevention, Transactions), and advanced caching strategies (Redis, Cache-Aside). Essential for building robust, high-performance APIs.

This skill simulates a senior engineer conducting comprehensive code reviews. It analyzes code diffs and files to identify bugs, security vulnerabilities (e.g., SQL injection, XSS), performance issues (N+1), code smells, and architectural flaws. It is ideal for reviewing pull requests, performing code quality audits, or conducting security assessments, providing structured, actionable, and prioritized feedback.

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.

Actionable guidance for analyzing plans, indexing, connection pooling, partitioning, and detecting N+1 queries to keep PostgreSQL and MySQL workloads fast and reliable.

An expert guide to designing secure, performant GraphQL APIs covering schema design, resolvers, federation, DataLoader batching, subscriptions, and client integration with Apollo/urql, including advice on when REST may be preferable.

This skill guides the design and implementation of complex GraphQL APIs. It specializes in schema design, utilizing Apollo Federation for distributed microservices, optimizing resolvers with DataLoader for N+1 prevention, and implementing real-time subscriptions. It covers security, complexity analysis, and adherence to best practices for building scalable, high-performance graph architectures.

Guidance for building robust GraphQL services: schema design with Relay-style pagination, resolver patterns that leverage per-request DataLoader for N+1 prevention, subscription handling, and structured error payloads to simplify client integrations.

A comprehensive guide to optimizing interactions with the Linear API. Learn advanced techniques to improve application performance by eliminating N+1 queries, implementing robust caching strategies for static data (e.g., teams, states), managing cache invalidation via webhooks, and efficiently batching multiple mutations into single GraphQL requests. Essential for building scalable, low-latency SaaS applications.

A comprehensive guide covering advanced patterns for the Linear SDK using TypeScript/JavaScript. Learn how to implement efficient cursor-based pagination, avoid N+1 query problems by batch-loading relations, perform complex filtering, and handle API calls with type-safe error management when integrating with the Linear GraphQL API.

An expert assistant providing deep knowledge and best practices for Prisma ORM. It covers the entire lifecycle of database interaction, including optimal schema design, relation modeling, safe migration workflows, and advanced query optimization techniques (addressing N+1 issues and implementing raw queries) across PostgreSQL, MySQL, and SQLite.

This skill performs deep, line-by-line scanning of an entire codebase to understand its architecture, patterns, and dependencies. It systematically identifies critical issues across security vulnerabilities (SQL injection, secrets), performance bottlenecks (N+1 queries, caching), architectural flaws, and code quality gaps. It then automatically refactors and fixes all identified issues, transforming the code into professional, production-grade, enterprise-level quality.

Specializes in building modern, high-performance Rails 7+ web applications. Expertise includes optimizing Active Record queries (N+1 prevention), implementing partial page updates with Hotwire (Turbo Frames/Streams), handling real-time communication via Action Cable, and managing background jobs using Sidekiq. The process includes rigorous RSpec testing and database schema management.