context7-best-practices

What problem does it solve?

Provides a canonical, project-specific set of library best practices to reduce architectural drift, prevent common performance regressions, and enforce security and database correctness across Drizzle ORM, React, Express.js, and TanStack Query usage in the codebase.

Core Features & Use Cases

• Database & Drizzle ORM: Rules for adding explicit foreign key indexes, GIN full-text indexes, transaction usage for multi-table writes, and correct array column definitions to avoid performance and correctness issues.
• React Performance: Enforced lazy-loading for pages, memoization patterns (useMemo, useCallback, React.memo) for expensive computations and list rendering, and guidance to isolate heavy dependencies.
• Express Security & Performance: Applied HTTP header hardening, CSP and allowlists, async error handling patterns, caching strategies, and rationale for avoiding Helmet in favor of custom headers.
• TanStack Query Data Management: Hierarchical query key conventions, infinite staleTime for stable financial data, optimistic updates with rollback, bulk invalidation strategies, and prefetching recommendations.
• Use Cases: Architecture decisions, code reviews, feature development checklists, and onboarding new engineers to ensure consistent, auditable implementations.

Quick Start

Use the context7-best-practices skill to audit a feature branch for FK indexes, React performance patterns, Express security headers, and TanStack Query key and caching usage.